SELECT DISTINCT CASE WHEN Carrier = 'OpenSearch-Air' Then FlightDelayMin END AS delay FROM opensearch_dashboards_sample_data_flights
SELECT DISTINCT CASE WHEN FlightDelay = true Then Carrier END AS name FROM opensearch_dashboards_sample_data_flights
SELECT DISTINCT CASE WHEN FlightDelay = true Then Carrier WHEN FlightDelay = false THEN NULL END AS name FROM opensearch_dashboards_sample_data_flights