Is a sub query necessary for this ?

Printable View