plumiStructured query language (SQL): AQA GCSE Computer Science questions
Every AQA GCSE Computer Science exam question on 3.7.2 Structured query language (SQL), 2022–2025, with its mark scheme and examiner’s report.
Paper
All papers
Exam
All years
Calculations
Q20.4
The whole paper ↗Q20.5
The whole paper ↗Q18.5
The whole paper ↗Q18.6
The whole paper ↗Q18.7
The whole paper ↗Q14.4
The whole paper ↗Q14.5
The whole paper ↗Q18.5
The whole paper ↗Q18.6
The whole paper ↗Q09.3
The whole paper ↗Q09.4
The whole paper ↗
All 11 questions on Structured query language (SQL), as a list
- June 2025, Paper 2, Q20.4 (6 marks): Using the database shown in Figure 8, write an SQL query that lists all the students in GCSE Year 1 and their scores in Biology. The query must only return: • f
- June 2025, Paper 2, Q20.5 (2 marks): Mark Cooper currently has a score of 18 for one of his Biology tests. This score has been entered incorrectly. The correct score should be 28 The following SQL
- June 2024, Paper 2, Q18.5 (2 marks): A list of all the films from the year 2019 in the database is needed. The following SQL is run to produce the list: FilmID, Title, Year FROM Film WHERE Some par
- June 2024, Paper 2, Q18.6 (3 marks): The film with the title Toy Story 3 has been entered incorrectly into the database and should have the title Toy Story 4. Write the SQL to make this change. [3
- June 2024, Paper 2, Q18.7 (3 marks): A film called Gladiator from the year 2000 is to be added to the database with a FilmID of 103 The following SQL is run: INSERT INTO ( ) Some parts of the SQL h
- June 2023, Paper 2, Q14.4 (6 marks): Year 11 students must return their books after they have f
- June 2023, Paper 2, Q14.5 (2 marks): Barry Tucker has returned their copy of the book Python Basics. Complete the SQL to delete the loan record for the book PB002. [2 marks] DELETE FROM WHERE
- June 2022, Paper 2, Q18.5 (6 marks): The youth club needs to produce a report listing the members who have been given the Leader award. The report must include both names of each member and the dat
- June 2022, Paper 2, Q18.6 (2 marks): A new member joins the youth club. The following SQL is run to add their details to the database: INSERT INTO (5, 'Alina', 'Ahmed', '2020-11-30') Some of the SQ
- Specimen, Paper 2, Q09.3 (6 marks): Due to a change in layout at the café, the game table with an ID of 2 is no longer suitable for games that can have more than four players. The manager needs to
- Specimen, Paper 2, Q09.4 (2 marks): The LengthOfGame field shows the average amount of time it takes to play a game in minutes. A query to add 10 minutes to the length of time taken for all games
Questions, mark schemes and examiner’s reports are © AQA, from their published past papers. Plumi isn’t affiliated with any exam board. Want whole papers? Full past papers.
Rather write your answers by hand on iPad? Plumi marks them against the same mark schemes.