Simple SQL Queries

Begin!
  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