with t1 as
(
select 12 as id,  to_timestamp('09.08.2017','DD-MM-YYYY') as status_ts, 'in_progress' as status
union all
select 12 as id,  to_timestamp('09.08.2017','DD-MM-YYYY') as status_ts, 'approved' as status
union all
select 100 as id,  to_timestamp('09.08.2017','DD-MM-YYYY') as status_ts, 'in_progress' as status
union all
select 100 as id,  to_timestamp('10.08.2017','DD-MM-YYYY') as status_ts, 'correction' as status
union all
select 100 as id,  to_timestamp('11.08.2017','DD-MM-YYYY') as status_ts, 'approved' as status
)
select id, 
       max(
       case 
       when t1.status = 'in_progress'
       then t1.status_ts
       end
       ) as "in_progress",
       max(
       case 
       when t1.status = 'approved'
       then t1.status_ts
       end
       ) as "approved",
       max(
       case 
       when t1.status = 'correction'
       then t1.status_ts
       end
       ) as "correction"
  from t1
group by id 

id	in_progress             approved                correction
12	2017-08-09 00:00:00	2017-08-09 00:00:00	
100	2017-08-09 00:00:00	2017-08-11 00:00:00	2017-08-10 00:00:00