Last active
August 29, 2015 13:56
-
-
Save bakercp/9216583 to your computer and use it in GitHub Desktop.
Divvy API Queries
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Get the most popular routes | |
SELECT count(*) AS CNT, from_station_id, to_station_id FROM `Divvy_Trips_2013` GROUP BY from_station_id, to_station_id ORDER BY CNT DESC | |
// | |
SELECT COUNT(*) AS CNT, from_station_id FROM `Divvy_Trips_2013` WHERE gender = 'F' AND birth_year > 1994 GROUP BY from_station_id ORDER BY CNT DESC |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment