SQL Queries

use empdemographics;

select * from employeesalary;

select * from employeedemographics;

select *

from employeedemographics

inner join employeesalary

using(employeeid);

select *

from employeedemographics

inner join employeesalary

using(employeeid)

where age>32;

select *

from employeedemographics

inner join employeesalary

using(employeeid)

where age>30 and gender='Female';

select *

from employeedemographics

inner join employeesalary

using(employeeid)

where age>30;

select *,

case when gender='male' then salary+(salary*.02)

else salary+(salary*.05)

end

from employeedemographics

inner join employeesalary

using(employeeid)

where age>30;