You work as a Database Administrator for Domain.com. You have created a table named
Students in the database. Following are the data contained in this table:
You have written the following query to retrieve records from the Students table:
SELECT Stu_ID, Last_Name, SUM(Fees)
FROM Students
WHERE Fees < 3000
GROUP BY Class
ORDER BY Last_Name;
You get an error on executing the query. Which of the following is the cause of the error?
A.
ORDER BY Last_Name
B.
WHERE Fees < 3000
C.
GROUP BY Class
D.
FROM Students