(select count(id) as Блок from table2 where responsible=X and ticket_state_id!=2)

(select count(id) as День from table2 where change_time>=current_date and user_id=X and state_id=2)

(select count(id) as Месяц from table2 where change_time>=date_trunc('month',current_date) and user_id=X and state_id=2)

(select count(id) as Все_время from table2 where user_id=X and state_id=2)

sum(id*k1)+День/Месяц/Все_время (зависит от периода) - sum(id*k2) 	(есть моменты что table2.service_id=[null],тогда без сервиса считается за 1) 

Агент	| День_баллы	| Месяц_баллы 	| Все_время_баллы
  1	|     0		|	0,5	|	1,5

Агент	|	Блок	|	День	|	День_баллы	|	Месяц	|	Месяц_баллы	|	Все_время	|	Все_время_баллы
  1	|	1	|	4	|	3,5		|	24	|	74,5		|	431		|	1134,5
  2	|	0	|	3	|	2,5		|	12	|	24,5		|	31		|	64,5
  3	|	0	|	0	|	0		|	1	|	1,5		|	1		|	1,5
  4	|	3	|	1	|	0,5		|	2	|	2		|	33		|	94,5  

select text 'агент' as сотрудник, block, today, (пвд*2+...+почта*3,5)+(today-(пвд+...+почта)) as tod_point, month, (пвдй*2+...+почтай*3,5)+(month-(пвдй+...+почтай)) as mon_point, 
alll, (пвдйй*2+...+почтайй*3,5)+(alll-(пвдййй+...+почтаййй)) as all_point
from (select count(id) as пвд,
***
(select count(id) as почта	from ticket where change_time>=date_trunc('month',current_date) and user_id=82 and state_id in (2,3,5,7,8,9) and service_id=67),

(select count(id) as пвдй	from ticket where change_time>=current_date and user_id=82 and state_id in (2,3,5,7,8,9) and service_id=1),
***
(select count(id) as почтай	from ticket where change_time>=current_date and user_id=82 and state_id in (2,3,5,7,8,9) and service_id=67),

(select count(id) as пвдййй	from ticket where user_id=82 and state_id in (2,3,5,7,8,9) and service_id=1),
***
(select count(id) as почтаййй	from ticket where user_id=82 and state_id in (2,3,5,7,8,9) and service_id=67),

(select count(id) as today	from ticket where change_time>=current_date and user_id=82 and state_id in (2,3,5,7,8,9)),
(select count(id) as month	from ticket where change_time>=date_trunc('month',current_date) and user_id=82 and state_id in (2,3,5,7,8,9)),
(select count(id) as alll	from ticket where user_id=82 and ticket_state_id in (2,3,5,7,8,9)),
(select count(id) as block	from ticket where responsible=82 and state_id not in (2,3,5,7,8,9) and queue_id=1)
	from ticket where change_time>=date_trunc('month',current_date) and user_id=82 and state_id in (2,3,5,7,8,9) and service_id=1) ticket