sql中，如何找出连续5天中出现3次的人（最好是数据）?

// 表test

{name: "billy", date: "2019-01-01"}

{name: "billy", date: "2019-01-03"}

{name: "billy", date: "2019-01-04"}

{name: "billy", date: "2019-01-08"}

{name: "billy", date: "2019-01-10"}

{name: "billy", date: "2019-01-21"}

{name: "billy", date: "2019-01-25"}

{name: "billy", date: "2019-01-26"}

{name: "rose", date: "2019-01-01"}

{name: "rose", date: "2019-01-03"}

{name: "rose", date: "2019-01-06"}

{name: "rose", date: "2019-01-07"}

{name: "mike", date: "2019-01-01"}

{name: "mike", date: "2019-01-08"}

{name: "mike", date: "2019-01-20"}