I have a table set out like so:
user_id date minutes_asleep
----------------------------
1 2015-01-01 480
1 2015-01-02 0
1 2015-01-03 0
1 2015-01-04 0
1 2015-01-05 321
1 2015-01-06 0
1 2015-01-07 0
1 2015-01-08 0
2 2015-01-01 567
2 2015-01-02 0
2 2015-01-03 285
2 2015-01-04 0
2 2015-01-05 577
2 2015-01-06 0
2 2015-01-07 0
2 2015-01-08 0
I need to find the count of 3 consecutive dates where minutes asleep is 0. So in the example above user_id 1 would have a count of 2, user_id 2 would have a count of 1. The total count would be 3. So the returning result would be:
total_count
-----------
3
Aucun commentaire:
Enregistrer un commentaire