securetorobert/years_in_bicycle_hire.sql

Created March 24, 2021 15:19

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/securetorobert/7f99c4c3aaa05f25a852eeaf79e3d620.js"></script>
Save securetorobert/7f99c4c3aaa05f25a852eeaf79e3d620 to your computer and use it in GitHub Desktop.

Download ZIP

Truncate the end_date to the year in London Bicycle Hires table and group by that.

Raw

years_in_bicycle_hire.sql

	SELECT
	DATE_TRUNC(DATE(end_date), YEAR)
	FROM
	`bigquery-public-data.london_bicycles.cycle_hire`
	GROUP BY
	1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment