I am trying to access the records for the year 2015 from the nyc_yellow cabs table on big query. And I keep ruing into this error.
Error: Quota exceeded: Your project exceeded quota for free query bytes scaed. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors.
My Query is: SELECT DAYOFWEEK(pickup_datetime) dayofweek, INTEGER(100*AVG(trip_distance/((dropoff_datetime-pickup_datetime)/3600000000)))/100 speed, FROM [nyc-tlc:yellow.trips] WHERE fare_amount/trip_distance between 2 and 10 and year(pickup_datetime) = 2015 GROUP BY 1 ORDER BY 1
I am using the Free trial.