分组操作

分组操作

• avg: average value (input: numbers)

select avg(salary)
from instructor
where dept_name = 'Comp.Sci';

• min: minimum value
• max: maximum value
• sum: sum of values (input: numbers)
• count: number of values

select count (distinct ID)
from teaches
where semester = 'Spring' and year = 2010;

Group by

Example:

select dept_name, avg (salary) as avg_salary
from instructor
group by dept_name;

Having

Example:

select dept_name, avg (salary)
from instructor
group by dept_name
having avg (salary) > 42000;