CASE 1 WHEN 1 THEN 'One' END AS cases
CASE 2 WHEN 1 THEN 'One' WHEN 2 THEN 'Two' END AS cases
CASE 3 WHEN 1 THEN 'One' WHEN 2 THEN 'Two' ELSE 'More than two' END AS cases
CASE WHEN 'test' = 'test' THEN 'Test' END AS cases
CASE WHEN 'test' = 'hello world' THEN 'Hello' WHEN 1.0 = 1.0 THEN 'One' END AS cases
CASE WHEN 'test' = 'hello world' THEN 'Hello' WHEN 1.0 = 2.0 THEN 'One' ELSE 'Others' END AS cases
CASE ABS(-1) WHEN 1 THEN 'Absolute one' END AS cases
CASE ABS(2 * -1) WHEN 1 THEN 'Absolute one' WHEN 2 THEN 'Absolute two' END AS cases
CASE ABS(-3) WHEN 1 THEN 'Absolute one' WHEN 2 THEN 'Absolute two' ELSE TRIM(' Other ') END AS cases
CASE WHEN TRIM('test ') = TRIM(' test') THEN 'Test' END AS cases
CASE WHEN 'test' = 'hello world' THEN 'Hello' WHEN ABS(1.0) = ABS(-1.0) THEN 'One' END AS cases
CASE WHEN 'test' = 'hello world' THEN 'Hello' WHEN 1.0 = 2.0 THEN 'One' ELSE TRIM(' Others ') END AS cases
CASE 1 WHEN 1 THEN 'One' ELSE NULL END AS cases
CASE 1 WHEN 1 THEN 'One' WHEN 2 THEN 'Two' ELSE NULL END AS cases
CASE 2 WHEN 1 THEN NULL WHEN 2 THEN 'Two' ELSE NULL END AS cases
IFNULL(null, AvgTicketPrice) from opensearch_dashboards_sample_data_flights
IFNULL(AvgTicketPrice, 100) from opensearch_dashboards_sample_data_flights
IFNULL(AvgTicketPrice, null) from opensearch_dashboards_sample_data_flights