select department_id,avg(salary) from employees group by department_id; select department_id,max(salary),sum(salary) from employees group by department_id; select job_id,avg(salary) from employees ...