Data Science, Machine Learning, Design Patterns, Bigquery, Sql.
solution is to split the dataset based on the date column: SELECT airline, departure_airport, departure_schedule, arrival_airport, arrival_delay FROM `bigquery-samples`.airline_ontime_data.flights WHERE ABS(MOD(FARM_FINGERPRINT(date), 10)) < 8 -- 80% for TRAIN Besides solving the original problem