The attributes on the left of γ go in GROUP BY. The aggregates on the right go in SELECT.
dept_name γ count(id) (instructor)γ max(salary) (instructor)dept_name γ sum(credits) as total_credits (course)- How many tuples does
dept_name γ avg(salary) (instructor)return? σ n > 1 (dept_name γ count(id) as n (instructor))