SQL - Structured Query Language

Lesson Instructions

Watch and follow the YouTube video, the lesson contains three parts:

  1. Key Information and content - all you need to do here is watch and listen

  2. Learning activity - this activity involves answering different questions about SQL

  3. Consolidation - these are past exam question and are for deliberate practice to check your understanding.

Task - SQL Task

Task - Exam Questions - Deliberate Practice

Exam Questions - Web

Mark Scheme

Question 1 (i)

  • Supplier = Killey's.

  • Answer: 0003, 0006 - Accept product names or any other response where the record selected is clear.

  • Price > £1.00 OR Supplier = Hill Farm

  • Answer: 0001, 0002, 0004, 0008

Question 1 (ii)

  • SELECT *

  • FROM Products
    WHERE Discontinued = False

  • AND QuantityLeft < ReorderLevel