Great info!
I'll have to try those at work!

Just a very humble and simple observation: this (great) article would greatly benefit from using a simple example table, instead of A, B, C, 1, 2, 3.
I'm sure I'm not the only average SQL user who can't really follow the examples provided.