SELECT
       SUM(CASE WHEN pendidikan_terakhir != 1 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) <= 750000 THEN 1 ELSE 0 END) AS '<750K-1',
       SUM(CASE WHEN pendidikan_terakhir != 1 AND (
              bekerja = 1
              OR penyandang_cacat != 5
              OR status_pernikahan = 2
              OR bekerja_upah = 1
              OR bekerja_tanpa_upah = 1
              OR mengasuh_adik = 1
              OR bermain_sepanjang_hari = 1
              OR rencana_menghentikan_pendidikan_anak = 1
              OR (
                     sekolah_monitor_proses_bdr = 0
                     AND kunjungan_guru_kerumah = 0
                     AND sekolah_memonitor_kelanjutan_pendidikan = 0
                     AND kepala_desa_memonitor_kelanjutan_pendidikan = 0
              )
              OR fas_hp < (SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.hubungan_dgn_kk != 1 AND tdk2.sipbm_id=tp.sipbm_id))
              AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) <= 750000  THEN 1 ELSE 0 END) AS '<750K-2',
       SUM(CASE WHEN pendidikan_terakhir = 1 AND alasan_tidak_sekolah_covid19 = 1 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) <= 750000  THEN 1 ELSE 0 END) AS '<750K-3',
       SUM(CASE WHEN pendidikan_terakhir = 1 AND alasan_tidak_sekolah_covid19 = 0 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) <= 750000  THEN 1 ELSE 0 END) AS '<750K-4',

       SUM(CASE WHEN pendidikan_terakhir != 1 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) BETWEEN 750001  AND 1500000  THEN 1 ELSE 0 END) AS '750K-1500K-1',
       SUM(CASE WHEN pendidikan_terakhir != 1 AND (
              bekerja = 1
              OR penyandang_cacat != 5
              OR status_pernikahan = 2
              OR bekerja_upah = 1
              OR bekerja_tanpa_upah = 1
              OR mengasuh_adik = 1
              OR bermain_sepanjang_hari = 1
              OR rencana_menghentikan_pendidikan_anak = 1
              OR (
                     sekolah_monitor_proses_bdr = 0
                     AND kunjungan_guru_kerumah = 0
                     AND sekolah_memonitor_kelanjutan_pendidikan = 0
                     AND kepala_desa_memonitor_kelanjutan_pendidikan = 0
              )
              OR fas_hp < (SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.hubungan_dgn_kk != 1 AND tdk2.sipbm_id=tp.sipbm_id))
              AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) BETWEEN 750001  AND 1500000  THEN 1 ELSE 0 END) AS '750K-1500K-2',
       SUM(CASE WHEN pendidikan_terakhir = 1 AND alasan_tidak_sekolah_covid19 = 1 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) BETWEEN 750001  AND 1500000  THEN 1 ELSE 0 END) AS '750K-1500K-3',
       SUM(CASE WHEN pendidikan_terakhir = 1 AND alasan_tidak_sekolah_covid19 = 0 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) BETWEEN 750001  AND 1500000  THEN 1 ELSE 0 END) AS '750K-1500K-4',

       SUM(CASE WHEN pendidikan_terakhir != 1 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) >= 1500001  THEN 1 ELSE 0 END) AS '>1500K',
       SUM(CASE WHEN pendidikan_terakhir != 1 AND (
              bekerja = 1
              OR penyandang_cacat != 5
              OR status_pernikahan = 2
              OR bekerja_upah = 1
              OR bekerja_tanpa_upah = 1
              OR mengasuh_adik = 1
              OR bermain_sepanjang_hari = 1
              OR rencana_menghentikan_pendidikan_anak = 1
              OR (
                     sekolah_monitor_proses_bdr = 0
                     AND kunjungan_guru_kerumah = 0
                     AND sekolah_memonitor_kelanjutan_pendidikan = 0
                     AND kepala_desa_memonitor_kelanjutan_pendidikan = 0
              )
              OR fas_hp < (SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.hubungan_dgn_kk != 1 AND tdk2.sipbm_id=tp.sipbm_id))
              AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) >= 1500001  THEN 1 ELSE 0 END) AS '>1500K-2',
       SUM(CASE WHEN pendidikan_terakhir = 1 AND alasan_tidak_sekolah_covid19 = 1 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) >= 1500001  THEN 1 ELSE 0 END) AS '>1500K-3',
       SUM(CASE WHEN pendidikan_terakhir = 1 AND alasan_tidak_sekolah_covid19 = 0 AND pengeluaran_rata_rata/(SELECT COUNT(*) FROM tb_data_keluarga tdk2 WHERE tdk2.sipbm_id=tp.sipbm_id) >= 1500001  THEN 1 ELSE 0 END) AS '>1500K-4'
FROM tb_pengeluaran tp
INNER JOIN tb_data_keluarga tdk USING(sipbm_id)
INNER JOIN tb_penerangan tpr USING(sipbm_id)
WHERE tdk.hubungan_dgn_kk != '1' AND TIMESTAMPDIFF(YEAR, lahir_tgl, CURDATE()) BETWEEN 4  AND 18;