SELECT DECODE(c.description, '', 'Total', c.description) "Support Data", count(b.case_cd) "Count"
FROM
a,b,r
WHERE
a.case_id = b.case_cd AND
b.outcome_support_data_cd = c.outcome_support_data_id and
a.closure_date >= to_date('{?closure_start_date}','MM/DD/YYYY') AND
-------> this line above and the one below if comment errors disappers
a.closure_date <= to_date('{?closure_end_date}','MM/DD/YYYY')
AND a.deleted_ind = 0 AND
a.region_assigned = r.region_id AND
UPPER(r.description) LIKE UPPER('{?description}'||'%')
GROUP BY DECODE(c.description, '', 'Total', c.description)
ORDER BY 1