Фильтрация в агрегатных функциях Filter.

select 

count(*),

count(*) filter(where length > 100),

count(*) filter(where length > 120),

count(*) filter(where length > 140)

from 

film;

select 

f.rating,

count(*),

count(*) filter(where length > 100),

count(*) filter(where length > 120),

count(*) filter(where length > 140)

from 

film f

group by

f.rating;

select * from film f order by rating, length desc;

select 

count(*)

from 

film

where