This website is for reference purposes only. Users are responsible for any misuse. The owner is not liable for any consequences.
CodeTantraAnswers
Back to Database Management Systems (Laboratory)
3.1.9MediumCODE

Simple Queries - Group By and Having Clause

Question

Solution

SQL

SELECT sarea, SUM(spocket) AS result
FROM stud
GROUP BY sarea
HAVING SUM(spocket) < 600;

1/1 test cases passed

No hidden test cases