SQL kaggle learn with as excercise

SQL kaggle learn with as excercise

rides_per_year_query = """

SELECT EXTRACT(YEAR FROM trip_start_timestamp) AS year ,COUNT(unique_key) AS num_trips

FROM `bigquery-public-data.chicago_taxi_trips.taxi_trips`

GROUP BY year

ORDER BY year
#运行报错

Query cancelled; estimated size of 5.255455803126097 exceeds limit of 1 GB

None

rides_per_year_query = """

SELECT EXTRACT(YEAR FROM trip_start_timestamp) AS year ,COUNT(1) AS num_trips

FROM `bigquery-public-data.chicago_taxi_trips.taxi_trips`

GROUP BY year

ORDER BY year

"""
#返回正确结果

 year  num_trips

0  2013   26870287

1  2014   31021726

2  2015   27400744

3  2016   19878276

4  2017    7689021