{"sql":"SELECT \r\n    kode_rute_armada,\r\n    lambung,\r\n    nopol,\r\n    dr_ccd,\r\n    to_ccd,\r\n    armada_kelas,\r\n    dr_time,\r\n    sum(kursi_terjual) as kursi_terjual,\r\n    sum(kursi_open) as kursi_open,\r\n    sum(omset) as omset,\r\n    sum(omset_tiket) as omset_tiket,\r\n    sum(omset_total) as omset_total,\r\n    sum(jseat_bagasi) as jseat_bagasi,\r\n    sum(jseat_penumpang) as jseat_penumpang\r\n  from daily_rute_price where tgl='2026-07-28' and jseat_bagasi>0 group by kode_rute_armada"}