SQL - Structured Query Language
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.
Task - SQL Task
Task - Exam Questions - Deliberate Practice
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)
WHERE Discontinued = False
AND QuantityLeft < ReorderLevel