strawquery PT

Learn SQL with Studio Mochi

30 short lessons. Each one is a scene at a small anime studio, a bit of SQL and a few questions to answer with a query. You only read data here: every query is a SELECT.

0 of 30 lessons done

Part 1 Reading the data

  1. 1 Welcome to Studio Mochi
  2. 2 More than one column
  3. 3 Filtering with numbers
  4. 4 Filtering with text
  5. 5 AND, OR and parentheses
  6. 6 IN, NOT IN and BETWEEN
  7. 7 Patterns with LIKE

Part 2 Shaping the answer

  1. 8 Sorting the results
  2. 9 LIMIT and OFFSET
  3. 10 DISTINCT
  4. 11 Missing values
  5. 12 Calculated columns and aliases
  6. 13 Working with text
  7. 14 Dates
  8. 15 CASE: answers that depend

Part 3 Joining tables

  1. 16 INNER JOIN
  2. 17 Joining several tables
  3. 18 LEFT JOIN
  4. 19 Finding what is missing
  5. 20 A table joined to itself
  6. 21 Stacking results with UNION

Part 4 Summing it all up

  1. 22 Counting and summing
  2. 23 GROUP BY
  3. 24 HAVING
  4. 25 WHERE or HAVING?

Part 5 Questions inside questions

  1. 26 Subqueries in WHERE
  2. 27 EXISTS, FROM and correlated subqueries
  3. 28 WITH: naming your steps
  4. 29 Window functions
  5. 30 The board meeting

Unofficial fan project. Titles belong to their creators and rights holders.