SELECT FlightNum FROM opensearch_dashboards_sample_data_flights WHERE FlightDelayMin >= CASE WHEN FlightDelay = true THEN 200 END
SELECT FlightNum FROM opensearch_dashboards_sample_data_flights WHERE FlightDelayMin >= CASE WHEN FlightDelay = true THEN 200 ELSE 0 END
SELECT FlightNum FROM opensearch_dashboards_sample_data_flights WHERE FlightDelayMin >= CASE FlightDelay WHEN true THEN 200 END
SELECT FlightNum FROM opensearch_dashboards_sample_data_flights WHERE FlightDelayMin >= CASE FlightDelay WHEN true THEN 200 ELSE 0 END
SELECT CASE WHEN FlightDelay = true THEN 1 ELSE 0 END AS bool, MAX(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY CASE WHEN FlightDelay = true THEN 1 ELSE 0 END
SELECT CASE FlightDelay WHEN true THEN 1 WHEN false THEN 0 END AS bool, MAX(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY CASE FlightDelay WHEN true THEN 1 WHEN false THEN 0 END
SELECT CASE WHEN FlightDelay = true THEN 'delayed' ELSE NULL END AS delay, MAX(FlightDelayMin) FROM opensearch_dashboards_sample_data_flights GROUP BY CASE WHEN FlightDelay = true THEN 'delayed' ELSE NULL END