prev question

We would like to find the average weight of cats grouped by breed. Also, in the same query find the average weight of cats grouped by breed whose age is over 1

---

Return: breed, average_weight, average_old_weight Order by: breed

Show Table Schema

Cats:

name	varchar
breed	varchar
weight	float
color	varchar
age	int

select * from cats

Click me!

Run Query Show Hint

This query requires:

Correct output but can you use 'filter'?

Desired output:

breed	average_weight	average_old_weight
British Shorthair	4.5	4.5
Maine Coon	5.6	5.6
Persian	4.6	4.8
Siamese	5.8	5.5

view answer

select breed, avg(weight) as average_weight, avg(weight) filter (where age > 1) average_old_weight from cats group by breed order by breed

Your output: