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

Смотреть код

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
length > 100;