BIT BY BYTE
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.
SELECT FirstName, Surname FROM Students WHERE YearGroup = 11 ORDER BY Surname;
SELECT * FROM Students WHERE Surname = 11;
SELECT FirstName AND Surname FROM Students SORT Surname;
GET FirstName, Surname FROM Students IF YearGroup = 11;
Check Answer