SQL Queries

select * 

from employeedemographics

inner join employeesalary

using(employeeid)

where gender='female';

select * 

from employeedemographics

full join employeesalary

using(employeeid);

select * 

from employeedemographics

left join employeesalary

using(employeeid);

select * 

from employeedemographics

right join employeesalary

using(employeeid);

select * 

from employeedemographics

right join employeesalary

using(employeeid)

where salary>50000;

select * 

from employeedemographics

full join employeesalary

using(employeeid)

where salary>50000

order by age desc;

select employeeid,jobtitle,salary

from employeedemographics

full join employeesalary

using(employeeid)

where salary>50000

order by age desc;