Year 11
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- In this lesson, we will use the music database from the previous lesson, 'Database essentials', to write our first SQL commands to access and manipulate the data.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
Loading...
3 Questions
Q1.
Which field would be most suitable to be the Primary Key
Car_Reg
Registered owner
Speed
Q2.
What would be the output of the following query: SELECT Car_reg WHERE Registered_Owner = "Abeni Barmore";
4
67
YM15PTO
Q3.
What would be the output of the following query: SELECT CaptureID WHERE Speed > 70;
1,2,3,6
4,5
6