BIT BY BYTE
Back
Question 1 of 2
4 marks
Write a SQL query to list the first and last names of all students in Year 11, sorted by surname.
GET FirstName, Surname FROM Students IF YearGroup = 11;
SELECT * FROM Students WHERE Surname = 11;
SELECT FirstName AND Surname FROM Students SORT Surname;
SELECT FirstName, Surname FROM Students WHERE YearGroup = 11 ORDER BY Surname;
Check Answer