When I ran an SQL query in BigQuery to get some summary data from a public dataset, the first row returned is not something I want in the results.
Query used:
SELECT
usertype,
CONCAT (start_station_name, ‘ to ‘, end_station_name) AS route,
COUNT (*) as num_trips,
ROUND(AVG(CAST(tripduration AS INT64)/60), 2) AS duration
FROM bigquery-public-data.new_york_citibike.citibike_trips
GROUP BY
start_station_name,
end_station_name,
usertype
ORDER BY
num_trips DESC
LIMIT 10
Results:
Query results
Yasara Ran is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.