sql: select employee_id x_employee_id, min(case when payroll_archive.code='contract_bs' then payroll_archive. amount end) x_contract_bs, min(case when payroll_archive.code='position_allw' then payroll_archive. amount end) x_position_allw, min(case when payroll_archive.code='addion_allw' then payroll_archive. amount end) x_addion_allw, min(case when payroll_archive.code='rate' then payroll_archive. amount end) x_rate, min(case when payroll_archive.code='transportation_allowance' then payroll_archive. amount end) x_transportation_allowance, min(case when payroll_archive.code='cash_allow' then payroll_archive. amount end) x_cash_allow, min(case when payroll_archive.code='F_S_P' then payroll_archive. amount end) x_F_S_P, min(case when payroll_archive.code='cola' then payroll_archive. amount end) x_cola, min(case when payroll_archive.code='Family_allow' then payroll_archive. amount end) x_Family_allow, min(case when payroll_archive.code='Child-care_Subsidy' then payroll_archive. amount end) x_Child_care_Subsidy, min(case when payroll_archive.code='Bonus' then payroll_archive. amount end) x_Bonus, min(case when payroll_archive.code='hypo_tax_rate' then payroll_archive. amount end) x_hypo_tax_rate, min(case when payroll_archive.code='rz_bonus' then payroll_archive. amount end) x_rz_bonus, min(case when payroll_archive.code='zinv_allw' then payroll_archive. amount end) x_zinv_allw, min(case when payroll_archive.code='One-Child_Allowance' then payroll_archive. amount end) x_one_Child_Allowance from payroll_archive left join hr_employee on payroll_archive.employee_id=hr_employee.id where hr_employee.active=True and (payroll_archive.effective_date<=current_date and (payroll_archive.expired_date is null or payroll_archive.expired_date>=current_date)) group by payroll_archive.employee_id