It works as WHERE clause for aggregate functions.
Example - You need to know city wise max salaries of employees where the max salary is more than 2150.
%%sql
select max(e.empsal) max_sal, d.depcity
from emp_<<your lab username>> e, deptt_<<your lab username>> d
where e.depid = d.depid
group by d.depcity
having max(e.empsal) > 2150
order by d.depcity
;
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...