check_5.sql

select 
	substr(create_dt::varchar,1,7) as month
	, round(avg(coalesce(score, 0)), 1) as "Среднее"
	, trunc(median(coalesce(score, 0))) as "Медиана"
	, count(*) as "Общее кол-во"
	, sum(case when score = 1 then 1 else 0 end) as "Оценка 1"
	, sum(case when score = 2 then 1 else 0 end) as "Оценка 2"
	, sum(case when score = 3 then 1 else 0 end) as "Оценка 3"
	, sum(case when score = 4 then 1 else 0 end) as "Оценка 4"
	, sum(case when score = 5 then 1 else 0 end) as "Оценка 5"
	, sum(case when score is null then 1 else 0 end) as "Без оценки"
from 
	home.dt_banki_responses
where
	date(create_dt) >= '2021-01-01'
	and status in ('Проблема решена', 'Зачтено')
group by substr(create_dt::varchar,1,7)
order by substr(create_dt::varchar,1,7) asc;