select  
	sum(cnt) filter(where group_name='заблок') as "заблок",
	sum(cnt) filter(where group_name='сегодня') as "сегодня", 
	sum(cnt) filter(where group_name='a') as "today", 
	sum(cnt) filter(where group_name='месяц') as "месяц", 
	sum(cnt) filter(where group_name='ab') as "month", 
	sum(cnt) filter(where group_name='всего') as "всего", 
	sum(cnt) filter(where group_name='abc') as "all"
from (
	select count(id)*1.0 as cnt, 'a' as group_name
	union all
	select count(id)*6.0, 'a' from ticket where change_time>=date_trunc('month',current_date) and user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9) and service_id=2
	union all
	...
	union all
	select count(id)*2.5, 'a' from ticket where change_time>=date_trunc('month',current_date) and user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9) and service_id=73
	union all
	...
	union all
	select count(id)*1.0, 'ab' from ticket where change_time>=current_date and user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9) and service_id=1
	union all
	...
	select count(id)*2.5, 'ab' from ticket where change_time>=current_date and user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9) and service_id=73
	union all
	...
	select count(id)*6.0, 'abc' from ticket where user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9) and service_id=1
	union all
	...
	union all
	select count(id)*2.5, 'abc' from ticket where user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9) and service_id=73
	union all
	...
	union all
	select count(id), 'месяц' from ticket where change_time>=date_trunc('month',current_date) and user_id in 24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9)
	union all
	select count(id), 'сегодня' from ticket where change_time>=current_date and user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9)
	union all
	select count(id), 'всего' from ticket where user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9)
	union all
	select count(id), 'заблок' from ticket where responsible_user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id not in (2,3,5,7,8,9)
) as t

SELECT
  user_id,
  sum(cnt_day) AS "сегодня",
  sum(cnt_day * coeff) AS "today",
  sum(cnt_month) AS "месяц",
  sum(cnt_month * coeff) AS "month",
  sum(cnt_all) AS "всего",
  sum(cnt_all * coeff) AS "all"  
FROM (
    SELECT 
    user_id, 
    service_id,
    count(*) FILTER (WHERE change_time >= current_date) AS cnt_day, 
    count(*) FILTER (WHERE change_time >= date_trunc('month', current_date)) AS cnt_month,
    count(*) AS cnt_all
  FROM ticket
  WHERE user_id in (24,82,76,80,73,44,41,63,70,71,57) and ticket_state_id in (2,3,5,7,8,9)
  GROUP BY user_id, service_id) AS t
JOIN service_coeff USING (service_id)  
GROUP BY user_id

SELECT
  user_id,
  sum(cnt_day) AS "сегодня",
  sum(cnt_day * coeff) AS "today",
  sum(cnt_month) AS "месяц",
  sum(cnt_month * coeff) AS "month",
  sum(cnt_all) AS "всего",
  sum(cnt_all * coeff) AS "all",
  (SELECT count(*) FROM ticket WHERE responsible_user_id = t.user_id AND ticket_state_id NOT IN (2,3,5,7,8,9)) AS "заблок"
FROM (
    SELECT 
    user_id, 
    service_id,
    count(*) FILTER (WHERE change_time >= current_date) AS cnt_day, 
    count(*) FILTER (WHERE change_time >= date_trunc('month', current_date)) AS cnt_month,
    count(*) AS cnt_all
  FROM ticket
  WHERE user_id IN (24,82,76,80,73,44,41,63,70,71,57) AND ticket_state_id IN (2,3,5,7,8,9)
  GROUP BY user_id, service_id) AS t
JOIN service_coeff USING (service_id)  
GROUP BY user_id