Simple SQL Queries Begin!

This category deals with the basics of SQL. It covers select and where clauses, case expressions, unions, and a few other odds and ends.

1. Retrieve everything from a table
2. Retrieve specific columns from a table
3. Control which rows are retrieved
4. Control which rows are retrieved - part 2
5. Basic string searches
6. Matching against multiple possible values
7. Classify results into buckets
8. Working with dates
9. Removing duplicates, and ordering results
10. Combining results from multiple queries
11. Simple aggregation
12. More aggregation