count(case when COACH_DRIVE = 'C' then 'C' end ) coach,
count(case when COACH_DRIVE = 'M' then 'M' end ) mini, count(*) totals
where drive_date between '01-jun-2014' and '31-aug-2014'
and coach_drive in ('C','M')
and drive_cancelled is null
group by drive_date,TO_CHAR(DRIVE_D
order by drive_date
Users keep changing what they need. So entering another question. Will close the previous one. That worked. Now they need
They need ALL the Sunday’s totals added together, all the Monday’s, etc.
coach and mini added together.