Common Queries for MySQL 5

I found a very cool and helpful web page: Common Queries for MySQL 5. I found the idea very inspiring. So now I would like to emulate them. Whatever queries I write shall be posted here. Just look for the query category on this blog.