select bersarang

SELECT tgl_input, count(pemasukan.no_izin),
(SELECT sum(biaya) FROM pemasukan WHERE jenis_kendaraan=1 and tgl_input like '$tahun-$bulan-%') as kendaraankecil,
(SELECT sum(biaya) FROM pemasukan WHERE jenis_kendaraan=2 and tgl_input like '$tahun-$bulan-%') as kendaraansedang,
(SELECT sum(biaya) FROM pemasukan WHERE jenis_kendaraan=3 and tgl_input like '$tahun-$bulan-%') as kendaraanbesar,
(SELECT sum(biaya) FROM pemasukan WHERE jenis_kendaraan=5 and tgl_input like '$tahun-$bulan-%') as taksi,
(SELECT sum(biaya) FROM pemasukan WHERE jenis_kendaraan=6 and tgl_input like '$tahun-$bulan-%') as sewa,
(SELECT sum(biaya) FROM pemasukan WHERE jenis_kendaraan=8 and tgl_input like '$tahun-$bulan-%') as ajdp,
(SELECT sum(biaya) FROM pemasukan WHERE jenis_kendaraan=4 and tgl_input like '$tahun-$bulan-%') as moda,
sum(denda),
sum(biaya+denda) as total,j_perusahaan, nama_perusahaan, pemasukan.no_izin
FROM pemasukan, perusahaan where perusahaan.no_izin=pemasukan.no_izin and tgl_input like '$tahun-$bulan-%' GROUP BY pemasukan.no_izin
ORDER BY  tgl_input ASC