This is a collection of specific (and sometimes pedantic) problems that I encountered and resolved. MySQL - Having vs Where