is a subselect appropriate here? if so how?

Printable View