https://tannock.net/2002/01/29/the-joy-of-subqueries/
The joy of subqueries