---

select
    c.sale_channel_id_1c,
    c.sale_channel_id,
    sc.name as sale_channel_name,
    sc.brief as sale_channel_brief,
    count(*) as cnt
from ourpension.contract c
left join ourpension.sale_channel sc
    on sc.id = c.sale_channel_id
where c.service_type in ('NPO', 'PDS')
group by
    c.sale_channel_id_1c,
    c.sale_channel_id,
    sc.name,
    sc.brief
order by cnt desc;