• I didn't realize you could use a subquery in all those places such as the HAVING clause.