SELECT          public.sys_guid() as id, a.hm_oem001_karyawan_id, b.employee_id as hm_oem001_karyawan_nik, b.name as hm_oem001_karyawan_name,
                a.hm_mem006_lokasi_kerja_id, c.code as hm_mem006_lokasi_kerja_code, c.name as hm_mem006_lokasi_kerja_name,
                COUNT(CASE WHEN a.jadwal = 'Masuk' THEN 1 ELSE null END) as jumlah_hari_kerja,
                COUNT(CASE WHEN a.jadwal <> 'Masuk' THEN 1 ELSE null END) as jumlah_hari_libur,
                null as version, null as user_create, null as creation_time, null as user_modify, null as modification_time
FROM            hat_get_jadwal_kerja_o001 a
INNER JOIN      hm_oem001 b ON b.id = a.hm_oem001_karyawan_id
INNER JOIN      hm_mem006 c ON c.id = a.hm_mem006_lokasi_kerja_id
WHERE           a.process_id IN ('1580374487772d9NHE', '1580374487838GsGQM', '1580374487937xEgzh', '1580374488009CTBgz', '15803744880772cViC', '1580374488147RdFfI', '1580374488435U478B', '1580374488496oWGHN', '1580374488558q4YvY', '15803744886250MMkL', '1580374488694JGdyC', '1580374488759WLyBU', '1580374488826K1F7o', '1580374488886ZE33g', '1580374488962IiZd7', '1580374489075M2Wyz', '1580374489143NTcAN', '1580374489214PImKD', '1580374489295aKWTt', '1580374489358S9e60', '1580374489423KuLDS', '15803744894954krvZ', '1580374489565FbZdp', '1580374489637kX2js', '15803744897128Tnr6', '15803744897826yh6O', '1580374489849Ak87f', '1580374489914Y6WJc', '1580374489983ytds8', '1580374490047GjDd2', '1580374490129piU3e', '1580374490197n1Mee', '1580374490269xzJj7', '15803744903518NRH5', '1580374490423ZEUDn', '1580374490490BlOqI', '15803744905563Z9xj', '1580374490627BPlKm', '1580374490687Pa7JB', '1580374490754GW4fT', '1580374490825xOZAz', '15803744909002oaE3')
GROUP BY        a.hm_oem001_karyawan_id, b.employee_id, b.name, a.hm_mem006_lokasi_kerja_id, c.code, c.name