AlgoDaily - Databases and SQL Interview Questions Cheat Sheet

But if we want to perform the same operation using the HAVING clause, we'd switch it up like this.

To use the HAVING clause, we first have to form a grouping, and then apply the condition.

xxxxxxxxxx
 
SELECT studentname, 
       Sum(attendance) AS TotalAttendance 
FROM   class 
GROUP  BY studentname 
HAVING totalattendance > 80

OUTPUT

Results will appear here.