SQL tips and tricks

From the repo

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years in my job as a data analyst.