vendredi 30 janvier 2015

Count of 3 consecutive unsynced dates


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