Hi all,

I have this query:

select count(b.vrm) from plateimage b
where b.capturedate < trunc(sysdate-10)
and not exists
(select vrm from hotmatch h where b.vrm = h.vrm and datecreated < trunc(sysdate-10))

This basically gets a count of all records (vrms) that are older than are certain date and not part of a corresponding table. Now, as can be seen this gets the total count of vrms. If i wanted to rewrite this so that it reports on the total no of vrms per day before the cut off how would i do that? Any help will be highly appreciated.

Thanks in advance,