Scribd
Upload
789 views1 page

Intro To BigQuery Solutions

This document provides solutions to queries for an intro to BigQuery activity, including queries to find a station name by ID, rental details by bike ID, and a bike model by bike ID.

Uploaded by

yamini kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
789 views1 page

Intro To BigQuery Solutions

This document provides solutions to queries for an intro to BigQuery activity, including queries to find a station name by ID, rental details by bike ID, and a bike model by bike ID.

Uploaded by

yamini kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Intro to BigQuery solutions

These are the solutions to the Intro to BigQuery activity. You can refer to this document if you
are troubleshooting your own queries. You can also copy and paste these solutions to test them
in your own BigQuery console.

1. What is the name of the station whose start_station_id is 111?

SELECT
start_station_name
FROM
`bigquery-public-data.london_bicycles.cycle_hire`
WHERE
start_station_id = 111;

2. Return all of the rental_ids, station IDs, and station names that bike_id 1710 started
from.

SELECT
rental_id,
start_station_id,
start_station_name
FROM
`bigquery-public-data.london_bicycles.cycle_hire`
WHERE
bike_id = 1710;

3. What is the bike_model of bike_id 58782?

SELECT
bike_model
FROM
`bigquery-public-data.london_bicycles.cycle_hire`
WHERE
bike_id = 58782;

You might also like