Miscellany
public text v1 · immutableSELECT
id,
name,
color,
count(meals.id) as num_meals
FROM cats
join meals
on meals.cat_id = cats.id
group by id,
name,
color
HAVING count(meals.id) > 3
ORDER BY name ASCSELECT
id,
name,
color,
count(meals.id) as num_meals
FROM cats
join meals
on meals.cat_id = cats.id
group by id,
name,
color
HAVING count(meals.id) > 3
ORDER BY name ASC