check_4.sql

select 
	status 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'
group by status
order by 2 desc;