Just because I have a captive audience
Stuff I like to talk about that may be useful
Kagel’s First Law of SQL: Any SELECT statement can be written in at least three ways to return the same result.
Kagel’s Second Law of SQL:
SQL is NOT a programming language it is a user language. If you insist on thinking like a programmer you will write efficient queries with lots of sub-queries.