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;