Skip to content

Instantly share code, notes, and snippets.

@thorwebdev

thorwebdev/no_of_trips.sql

Created December 15, 2014 20:34
Show Gist options
  • Save thorwebdev/c5b483737f52cafcfa76 to your computer and use it in GitHub Desktop.
Save thorwebdev/c5b483737f52cafcfa76 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate the number of trips that started in a certain area.
Raw
no_of_trips.sql
SELECT
pickup_polyId,
COUNT(*) AS no_of_trips
FROM
[nyctaximap:dataflow.nyc_output_join_fare_distinct]
GROUP BY
pickup_polyId
ORDER BY
no_of_trips DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment