SQL Queries

use empdemographics;

select jobtitle,avg(salary) as avg_salary

from employeedemographics as e1

join employeesalary as e2

using(employeeid)

group by jobtitle;

select jobtitle,avg(salary) as avg_salary

from employeedemographics as e1

join employeesalary as e2

using(employeeid)

group by jobtitle

order by avg_salary;

select jobtitle,avg(salary) as avg_salary

from employeedemographics as e1

join employeesalary as e2

using(employeeid)

group by jobtitle

order by avg_salary desc;

select jobtitle,avg(salary) as avg_salary

from employeedemographics as e1

join employeesalary as e2

using(employeeid)

group by jobtitle

having avg_salary>45000

order by avg_salary desc;

select jobtitle,round(avg(salary),0) as avg_salary

from employeedemographics as e1

join employeesalary as e2

using(employeeid)

group by jobtitle

having avg_salary>45000

order by avg_salary desc;

select jobtitle,round(avg(salary),-4) as avg_salary

from employeedemographics as e1

join employeesalary as e2

using(employeeid)

group by jobtitle

having avg_salary>45000

order by avg_salary desc;

select jobtitle,round(avg(salary),1) as avg_salary

from employeedemographics as e1

join employeesalary as e2

using(employeeid)

group by jobtitle

having avg_salary>45000

order by avg_salary desc;