SQL with SQLite
Answer any question about your data with an SQL query: from SELECT and GROUP BY to JOINs, CTEs and window functions.
- Create a SQLite databaseeasy
- SQLite query into a fileeasy
- SQLite: unique cities (DISTINCT)easy
- SQLite: top 3 by price (ORDER BY + LIMIT)easy
- SQLite: revenue per category (GROUP BY)easy
- SQLite: update rows by condition (UPDATE)easy
- SQLite: combine two sets of rows (UNION)easy
- SQLite: index on a foreign keyeasy
- SQLite: filtering groups with HAVINGmedium
- SQLite: categorization with CASEmedium
- SQLite: INNER JOIN of two tablesmedium
- SQLite: LEFT JOIN and customers without ordersmedium
- SQLite: join a table to itselfmedium
- SQLite: create a view (VIEW)medium
- SQLite: common table expression (CTE)medium
- SQLite: ranking with a window functionmedium
- SQLite: running totalmedium
- SQLite: orders above average (subquery)medium
- SQLite: CHECK constraint on a columnmedium
- SQLite: foreign keymedium
- SQLite: import data from CSVmedium
- SQLite: transfer money in a transactionmedium