What is a sub-query? When would you use one?

-----------------