Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT bike_number, ROUND(SUM(duration_seconds)/3600) AS duration_hours
- FROM tutorial.dc_bikeshare_q1_2012
- WHERE duration_seconds <175*3600
- GROUP BY bike_number
- ORDER BY SUM(duration_seconds) DESC
- LIMIT 300
Add Comment
Please, Sign In to add comment