SQL - Structured Query Language

Lesson Instructions

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

Key Information and content - all you need to do here is watch and listen
Learning activity - this activity involves answering different questions about SQL
Consolidation - these are past exam question and are for deliberate practice to check your understanding.

SQL Full Lesson Video.mp4

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

Page updated

Report abuse