SQL Queries

use empdemographics;

select * from employeedemographics;

select * from employeesalary;

select * 

from employeedemographics

inner join employeesalary

using(employeeid)

where firstname<>'michael';

select * 

from employeedemographics

inner join employeesalary

using(employeeid)

where firstname<>'michael' and jobtitle='salesman';

select jobtitle,count(jobtitle) as count_jobtitle

from employeedemographics

inner join employeesalary

using(employeeid)

where firstname<>'michael' and jobtitle='salesman'

group by jobtitle;

select jobtitle,count(jobtitle) as count_jobtitle

from employeedemographics

inner join employeesalary

using(employeeid)

where firstname<>'michael'

group by jobtitle;