SQL with Jupyter Notebook Tutorial

29 / 61

Aggregate Functions

An aggregate function is a function where the values of multiple rows are grouped together to form a single value of more significant meaning or measurements such as a set, a bag or a list.

%%sql

select max(empsal) from emp_<<your lab username>>;

select avg(empsal) from emp_<<your lab username>>;

select sum(empsal) from emp_<<your lab username>>;

select count(empsal) from emp_<<your lab username>>;

No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...