SQL Query Builder

Choose the correct SQL clause cards and drop them into the labelled boxes to build a working SQL statement.



Accuracy: 0% (0/0)
Challenge 1 of 10 Find Year 10 student names

Your task

Build a query to display the firstname and lastname of students in Year 10, ordered by lastname.

Your SQL will appear here...

Table preview

student_idfirstnamelastnameyear_grouphousepoints
1AishaKhan10Turing128
2BenJones11Lovelace92
3CaraSmith10Berners-Lee145
4DylanPatel9Turing76
🗄 Table: students
Drop one card into each labelled SQL clause box:
SELECT
FROM
WHERE
ORDER BY
Choose one card from each column:
SELECT
FROM
WHERE
ORDER BY

Need a hint?

Use the Hint button if you get stuck.

Each visible column has one correct card and two distractors.

Progress
1 / 10