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.
GROUP BY Class
B.
ORDER BY Last_Name
C.
FROM Students
D.
WHERE Fees < 3000