Guest User

Untitled

a guest
Mar 19th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT COUNT (DISTINCT min(start_time::date), user_id),
  2. start_time::date as date
  3. FROM mytable
  4. GROUP BY date
  5.  
  6. date count
  7. 1 2017-11-22 56
  8. 2 2017-11-23 73
  9. 3 2017-11-24 13
  10. 4 2017-11-25 91
  11. 5 2017-11-26 107
  12. 6 2017-11-27 33...
Add Comment
Please, Sign In to add comment