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