SELECT IF(1 < 2, 'T', 'F');

SELECT *, IF(Population >= 1000000, 'YES', 'NO') AS million FROM city LIMIT 40;
SELECT *,
CASE
	WHEN Population >= 1000000 THEN '>= 1 mln'
	WHEN Population >= 100000 THEN '>= 100 k'
	ELSE '< 100 k'
END AS million FROM city LIMIT 50;