select count(1)
from table_name
where inspection_date
between
to_date(start_date, 'MM/DD/YYYY'))
and to_date(end_date, 'MM/DD/YYYY'));
And make sure you inout the start_date and end_date as :
<br />
'11/01/2008'<br />
'11/01/2010'<br />
Thanks,
Kuthuparakkal