>Ok Im going to try this but i was also thinking about using a scan to count the instances of a record
>
Either way will work. SCAN may be a better option, I wanted to do this as one-liner.

I leave the SCAN exercise to you to complete.