Discovering subqueries is one of those "Eureka!" moments. A new landscape opens in front of you, and you can do really useful things such as: