Pasted

SELECT 
b.nama_bidang,
COUNT(*) AS JML,
SUM(IF(k.kd_gol = 1, 1, 0)) AS jml_satu, 
SUM(IF(k.kd_gol = 2, 1, 0)) AS jml_dua,
SUM(IF(k.kd_gol = 3, 1, 0)) AS jml_tiga
FROM karyawan k
LEFT JOIN bidang b ON b.kd_bidang = k.kd_bidang
GROUP BY k.kd_bidang