1 2 3 4 5 6 7 8 9 10 11 12 13 14
| select subStr(safpf_buss_date,0,11) as subStr_buss_date,
expsm8_id||expsm8_name as driverid,
safpf_route_no as route_no,
safpf_bus_no as bus_no,
psc5_service_rate as service_rate,
psc5_type_name as type_name,
sum(safpf_boarding_qty)as sum,
sum(safpf_boarding_qty)as amt,
sum(safpf_boarding_qty)as people
from expsm8
inner join safpf on CAST(safpf_driver_no AS INTEGER)=CAST(expsm8_id AS INTEGER)
inner join psc5 on psc5_card_type=safpf_card_type
group by driverid,subStr_buss_date
order by subStr_buss_date
|