Practice
Practice library
Every graded exercise in SQL Quest, in one place. Filter by skill to drill a weak spot, or pick challenge and debugging exercises to stretch. Each opens in its lesson workspace with the right dataset.
625 exercises
- Open the products tableSQL Foundations · What SQL is and what a database does · SELECT and FROMGuided
- See every orderSQL Foundations · What SQL is and what a database does · SELECT and FROM, Relational model: tables, rows, columnsPractice
- Fix the typoSQL Foundations · What SQL is and what a database does · SELECT and FROMDebug
- Count the catalogueSQL Foundations · Tables, rows and columns · Relational model: tables, rows, columnsGuided
- One value per rowSQL Foundations · Tables, rows and columns · Relational model: tables, rows, columns, SELECT and FROMPractice
- Count the ordersSQL Foundations · Tables, rows and columns · Relational model: tables, rows, columnsPractice
- The table that isn't thereSQL Foundations · Tables, rows and columns · Relational model: tables, rows, columns, SELECT and FROMDebug
- Look up a customer by keySQL Foundations · Keys and relationships · Primary and foreign keys, SELECT and FROMGuided
- Where does an order point?SQL Foundations · Keys and relationships · Primary and foreign keysPractice
- All orders of one customerSQL Foundations · Keys and relationships · Primary and foreign keys, Relational model: tables, rows, columnsPractice
- Who placed the cancelled order?SQL Foundations · Keys and relationships · Primary and foreign keysChallenge
- Columns of the products tableSQL Foundations · Reading a schema · Reading a schema and its relationshipsGuided
- Which order fields are optional?SQL Foundations · Reading a schema · Reading a schema and its relationshipsPractice
- Find the foreign keysSQL Foundations · Reading a schema · Reading a schema and its relationships, Primary and foreign keysPractice
- Map the keys of a bigger tableSQL Foundations · Reading a schema · Reading a schema and its relationships, Primary and foreign keysChallenge
- Product names and pricesSQL Foundations · Your first query · SELECT and FROMGuided
- Customer contact listSQL Foundations · Your first query · SELECT and FROM, Reading query output and data typesPractice
- Fix the broken querySQL Foundations · Your first query · SELECT and FROMDebug
- Stock checkSQL Foundations · Your first query · SELECT and FROMChallenge
- Tidy and extendSQL Foundations · SQL syntax and style · SELECT and FROMGuided
- The column that returns its own nameSQL Foundations · SQL syntax and style · SELECT and FROM, Reading query output and data typesDebug
- Double troubleSQL Foundations · SQL syntax and style · SELECT and FROMDebug
- Clauses in the wrong orderSQL Foundations · SQL syntax and style · SELECT and FROMDebug
- Value of stock on the shelfSQL Foundations · Understanding query results · Expressions and calculated columns, Reading query output and data typesGuided
- Name the calculationSQL Foundations · Understanding query results · Reading query output and data types, Expressions and calculated columnsDebug
- Follow-up dateSQL Foundations · Understanding query results · Expressions and calculated columns, Reading query output and data typesPractice
- Customer labels with gapsSQL Foundations · Understanding query results · Reading query output and data types, Expressions and calculated columnsChallenge
- Measure the order linesSQL Foundations · Exploring an unfamiliar database · Relational model: tables, rows, columnsGuided
- The first customersSQL Foundations · Exploring an unfamiliar database · SELECT and FROM, Reading query output and data typesPractice
- Who carries the order key?SQL Foundations · Exploring an unfamiliar database · Reading a schema and its relationshipsPractice
- What does a shipment look like?SQL Foundations · Exploring an unfamiliar database · Reading a schema and its relationships, Reading query output and data typesChallenge
- Top three by priceSQL Foundations · How a query runs · SELECT and FROM, Reading query output and data typesGuided
- Delivered orders, oldest firstSQL Foundations · How a query runs · SELECT and FROMPractice
- The alias WHERE can't seeSQL Foundations · How a query runs · Expressions and calculated columns, SELECT and FROMDebug
- Most money on the shelfSQL Foundations · How a query runs · Expressions and calculated columns, Reading query output and data typesChallenge
- Kitchen rangeSQL Foundations · Foundations practice set · SELECT and FROMPractice
- Who is behind order 21?SQL Foundations · Foundations practice set · Primary and foreign keysPractice
- Reorder listSQL Foundations · Foundations practice set · Expressions and calculated columns, Reading query output and data typesChallenge
- Optional customer fieldsSQL Foundations · Foundations practice set · Reading a schema and its relationshipsPractice
- Margin per productSQL Foundations · Foundations practice set · Expressions and calculated columns, Reading query output and data typesChallenge
- Three bugs, one querySQL Foundations · Foundations practice set · SELECT and FROM, Reading query output and data types, Expressions and calculated columnsDebug
- Stock value per productRetrieving and Filtering Data · Calculated columns · Expressions and calculated columnsGuided
- Weekend sale pricesRetrieving and Filtering Data · Calculated columns · Expressions and calculated columnsPractice
- Full cartons and loose unitsRetrieving and Filtering Data · Calculated columns · Expressions and calculated columnsChallenge
- The fill rate is always zeroRetrieving and Filtering Data · Calculated columns · Expressions and calculated columns, Reading query output and data typesDebug
- A contact sheet with friendly namesRetrieving and Filtering Data · Column and table aliases · Column and table aliasesGuided
- Margin per productRetrieving and Filtering Data · Column and table aliases · Column and table aliases, Expressions and calculated columnsPractice
- column "unit_margin" does not existRetrieving and Filtering Data · Column and table aliases · Column and table aliasesDebug
- Headings for a spreadsheet exportRetrieving and Filtering Data · Column and table aliases · Column and table aliases, Expressions and calculated columnsChallenge
- Our delivery partnersRetrieving and Filtering Data · Removing duplicates with DISTINCT · DISTINCTGuided
- Payment methods and outcomesRetrieving and Filtering Data · Removing duplicates with DISTINCT · DISTINCTPractice
- One row per brandRetrieving and Filtering Data · Removing duplicates with DISTINCT · DISTINCTDebug
- How many ways can you type a coupon?Retrieving and Filtering Data · Removing duplicates with DISTINCT · DISTINCTChallenge
- Kitchen productsRetrieving and Filtering Data · Filtering rows with WHERE · WHERE with comparison operatorsGuided
- Delivered ordersRetrieving and Filtering Data · Filtering rows with WHERE · WHERE with comparison operatorsPractice
- Business accountsRetrieving and Filtering Data · Filtering rows with WHERE · WHERE with comparison operatorsPractice
- column "Abha" does not existRetrieving and Filtering Data · Filtering rows with WHERE · WHERE with comparison operatorsDebug
- The premium rangeRetrieving and Filtering Data · Comparison operators · WHERE with comparison operatorsGuided
- Recent sign-upsRetrieving and Filtering Data · Comparison operators · WHERE with comparison operators, Filtering dates and numbersPractice
- Margin under pressureRetrieving and Filtering Data · Comparison operators · WHERE with comparison operatorsChallenge