Branch inside a query

SELECT name, CASE WHEN age >= 18 THEN 'adult' ELSE 'minor' END AS group_name FROM users;