Question Constellation Sign up for free

AQA · GCSE · Computer Science · Higher

SQL SELECT query completion

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:

Some parts of the SQL have been replaced by labels.

State the SQL that should have been written in place of the labels A and B.

Practice unavailable

This question can be viewed, but its original response format is not available for practice yet.

Write your answer first. You can study the marking guidance whenever you need it.

Study the marking See what earns credit and compare it with a full-mark answer.

Marking points

  1. 1 Replaces label A with SELECT.
  2. 2 Replaces label B with a correct Year = 2019 condition.

Why this answer loses marks

I filled the row condition but left the command blank.

Both structural gaps matter: the query needs its leading command clause as well as a condition that filters the target rows.