← All courses

SQL with SQLite

Answer any question about your data with an SQL query: from SELECT and GROUP BY to JOINs, CTEs and window functions.

22 tasks
  1. Create a SQLite databaseeasy
  2. SQLite query into a fileeasy
  3. SQLite: unique cities (DISTINCT)easy
  4. SQLite: top 3 by price (ORDER BY + LIMIT)easy
  5. SQLite: revenue per category (GROUP BY)easy
  6. SQLite: update rows by condition (UPDATE)easy
  7. SQLite: combine two sets of rows (UNION)easy
  8. SQLite: index on a foreign keyeasy
  9. SQLite: filtering groups with HAVINGmedium
  10. SQLite: categorization with CASEmedium
  11. SQLite: INNER JOIN of two tablesmedium
  12. SQLite: LEFT JOIN and customers without ordersmedium
  13. SQLite: join a table to itselfmedium
  14. SQLite: create a view (VIEW)medium
  15. SQLite: common table expression (CTE)medium
  16. SQLite: ranking with a window functionmedium
  17. SQLite: running totalmedium
  18. SQLite: orders above average (subquery)medium
  19. SQLite: CHECK constraint on a columnmedium
  20. SQLite: foreign keymedium
  21. SQLite: import data from CSVmedium
  22. SQLite: transfer money in a transactionmedium