Hi,
I have a query nested within a much larger query :
SELECT COUNT(1) FROM table1 X WHERE x.person_uid = person_uid AND car = '401' AND
(TO_DATE(startdate,'YYYYMMDD') BETWEEN COVERAGE_BEGIN_DATE AND coverage_end_date OR
TO_DATE(enddate,'YYYYMMDD') BETWEEN COVERAGE_BEGIN_DATE AND...