Skip to content

Instantly share code, notes, and snippets.

@securetorobert

securetorobert/bicycle_hires_before_2017.sql

Created March 24, 2021 15:26
Show Gist options
  • Save securetorobert/3088ce20994df635a73817437a6ec2f1 to your computer and use it in GitHub Desktop.
Save securetorobert/3088ce20994df635a73817437a6ec2f1 to your computer and use it in GitHub Desktop.
Download ZIP
How many hires do we have before 2017
Raw
bicycle_hires_before_2017.sql
SELECT
COUNT(rental_id)
FROM
`bigquery-public-data.london_bicycles.cycle_hire`
WHERE
DATE_TRUNC(DATE(end_date), year) < '2017-01-01'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment