tempat tidur rawat inap

SELECT sk.nama AS jenis_pelayanan, COUNT(tt.id) AS jumlah_tempat_tidur,
SUM(CASE WHEN (kls.static_code='VVIP') THEN 1 ELSE 0 END) AS vvip,
SUM(CASE WHEN (kls.static_code='VIP') THEN 1 ELSE 0 END) AS vip,
SUM(CASE WHEN (kls.static_code='KELAS_1') THEN 1 ELSE 0 END) AS kelas_1,
SUM(CASE WHEN (kls.static_code='KELAS_2') THEN 1 ELSE 0 END) AS kelas_2,
SUM(CASE WHEN (kls.static_code='KELAS_3') THEN 1 ELSE 0 END) AS kelas_3,
SUM(CASE WHEN (kls.static_code='KELAS_KHUSUS') THEN 1 ELSE 0 END) AS kelas_khusus
FROM master_tempat_tidur tt
INNER JOIN master_kamar kmr ON kmr.id = tt.id_kamar
INNER JOIN master_kelas kls ON kls.id = kmr.id_kelas
INNER JOIN master_spesialisasi_kamar sk ON sk.id = kmr.id_spesialisasi_kamar
WHERE YEAR(tt.created_time) = 2014
GROUP BY sk.id