IF
SELECT `Clothing ID`, IF (Age >= 30, 'O' , 'X') AS 'if_result' FROM dataset2;
CASE WHEN END
SELECT `Clothing ID`, CASE WHEN age >= 30 THEN 'O' WHEN age < 30 THEN 'X' END AS 'case_result' from dataset2;