What is the average salary for all employees?
select avg(salary) from employees
What are the average salaries by job title?
select job_title, avg(salary) from employees as t1 join jobs as t2 on t1.job_id = t2.job_id group by t2.job_title