Sharper filters · Shape your results
Results you'd actually share
You can calculate in SELECT: age * 12 is age in months. Name any column with AS.
DISTINCT removes duplicate rows. CASE WHEN … THEN … ELSE … END turns values into labels.
Go deeper: SQL CASE WHEN
Try it
SELECT name, CASE WHEN adopted THEN 'home' ELSE 'waiting' END AS status FROM pets;
Press Enter to continue