SELECT 
                aa.depart_date AS depart_date,
                aa.depart_time AS depart_time,
                SUM(aa.nominal_total_price) AS nominal_total_price,
                SUM(aa.wna_adult) AS wna_adult,
                SUM(aa.wna_child) AS wna_child,
                SUM(aa.wni_adult) AS wni_adult,
                SUM(aa.wni_child) AS wni_child,
                SUM(aa.foc) AS foc,
                SUM(aa.guide) AS guide,
                SUM(aa.infant) AS infant,
                SUM(aa.cargo) AS cargo,
                SUM(aa.wna_adult + aa.wna_child + aa.wni_adult + aa.wni_child + aa.foc + aa.guide) AS total
            FROM
                sysoffice_pendapatan aa
            WHERE
                aa.depart_time = '12:30 Transfer' and aa.depart_date='2025-12-10'
            GROUP BY aa.depart_date , aa.depart_time