select ticket_id, name, history_type_id, create_time from ticket_history
where ticket_id in (190961, 190938) 
order by 1 desc, 4 desc

create_time>=date_trunc('month', current_date)

select ticket_id, name, history_type_id from ticket_history
where ticket_id in (190961, 190938) and (name like '%closed%' or name like '%SolutionTimeStart%' or name like '%SolutionTimeStop%')
order by 1 desc, 3

select *
from crosstab('select ticket_id, name, history_type_id from ticket_history
where ticket_id in (190961, 190938) and (name like ''%closed%'' or name like ''%SolutionTimeStart%'' or name like ''%SolutionTimeStop%'')
order by 1 desc, 3') as ct (ticket_id bigint, name text, history_type_id text)

SELECT *
FROM crosstab(
    'SELECT ticket_id, name, history_type_id
    FROM ticket_history
    ORDER BY 1'
) AS ct (ticket_id int, name1 varchar, name2 varchar)

CREATE EXTENSION tablefunc

select * from (select ticket_id, split_part(name,'%%',3) as name, history_type_id from ticket_history
	where create_time>=date_trunc('month', current_date) and (history_type_id in (27,41,44))) 
	as t where name in ('closed successful', 'triggered') order by 1,2
	 
select * from crosstab(
'select * from (select ticket_id, split_part(name,''%%'',3) as name, history_type_id from ticket_history
	where create_time>=date_trunc(''month'', current_date) and (history_type_id in (27,41,44))) 
	as t where name in (''closed successful'', ''triggered'') order by 1,2'
	) as ct(ticket_id varchar, "closed successful" varchar, triggered varchar) order by 1