daily_rute_price
01-Sun 02-Mon 03-Tue 04-Wed 05-Thu 06-Fri 07-Sat 08-Sun 09-Mon 10-Tue 04-Wed
jalan
nl=0
nl>0
1-tool harga
2-tool dr-to
3-tool nopol
4-tool omset
5-tool ccd
PB ME BR TB LA | MR BI BO CB CG CI PG BK BD | PW WO JO SL KL BJ SM KS KP SR MT PL GM PA | MG MA PO TR BL SB ML JB
Hiace MicroBus Patas Pariwisata Executive ExecutivePlus ExecutivePlusSHD Combi SuperTopSHD DoubleDecker 5 DailySeq toolDD Tool Seq #0 Tool Seq #1 Tool Seq #2
PB ME BR TB LA | MR BI BO CB CG CI PG BK BD | PW WO JO SL KL BJ SM KS KP SR MT PL GM PA | MG MA PO TR BL SB ML JB
PB ME BR TB LA | MR BI BO CB CG CI PG BK BD | PW WO JO SL KL BJ SM KS KP SR MT PL GM PA | MG MA PO TR BL SB ML JB
Hiace MicroBus Patas Pariwisata Executive ExecutivePlus ExecutivePlusSHD Combi SuperTopSHD DoubleDecker 5 DailySeq toolDD Tool Seq #0 Tool Seq #1 Tool Seq #2
PB ME BR TB LA | MR BI BO CB CG CI PG BK BD | PW WO JO SL KL BJ SM KS KP SR MT PL GM PA | MG MA PO TR BL SB ML JB
select dr_ccd,to_ccd,kelas_id,count(*) as jum,sum(jalan) as jalan, sum(full) as full, sum(omset) as omset, sum(kursi_terjual) as kursi_terjual, sum(kursi_open) as kursi_open from daily_rute_price where tgl='5738' group by dr_ccd,to_ccd,kelas_id