Same Aggregate Functions are applied on grouped data. Grouping is done on the required columns of the table.
For example, you need to know manager wise sum of salaries of employees.
%%sql
select sum(empsal) sum_sal,mgrempid from emp_<<your lab username>>
group by mgrempid
order by mgrempid
;
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...