qqqquery

SELECT
            YEAR(t.tanggal_selesai) AS tahun,
            SUM(tl.harga * COALESCE(lh.persentase_fee_agen, 0.1)) AS pendapatan
          FROM transaksi_layanan tl
          JOIN transaksi t
            ON t.kode_transaksi = tl.kode_transaksi
          JOIN layanan_harga lh
            ON tl.kode_harga_layanan = lh.kode_harga_layanan
          WHERE t.status_transaksi = ?
            AND t.kode_agen = ?
            AND YEAR(t.tanggal_selesai) BETWEEN ? AND ?
            AND t.hapus = ?
          GROUP BY YEAR(t.tanggal_selesai)
          ORDER BY t.tanggal_selesai DESC