Trace SELECT result

GCSE · Computer Science · AQA · CS7.2 — SQL — SELECT statements: SELECT … FROM … WHERE …; using AND/OR; ORDER BY; selecting columns and filtering rows

Question

Given the following Students table: ID | Name | TutorGroup | Mark 1 | Aisha | 10A | 84 2 | Ben | 10B | 67 3 | Chloe | 10A | 92 4 | Dan | 10C | 71

State the result of: SELECT Name, Mark FROM Students WHERE TutorGroup = '10A' ORDER BY Mark DESC;

3 marks · take your time before peeking.

Sign up to try the next 30 problems

Save your streak, mark answers against the spec, and build a daily revision habit. Free during public beta — no card, no auto-renew.

Create a free account I already have one

Generated by TopMyGrade AI · cross-check official sources before relying on the mark-scheme phrasing.