Here's a reference to tips and examples in MySQL. I'm having having formatting issues posting here, so I'll just include a link.
The above link is from my notes... Anyone have additional examples that I could add? Adding more content may help others.