SQL Queries

use empdemographics;

select *

from employeedemographics as e1

join employeesalary as e2

on e1.employeeid=e2.employeeid;

select *

from employeedemographics as e1

join employeesalary as e2

using(employeeid);

select firstname,lastname,jobtitle,salary,

case 

when jobtitle='salesman' then salary+(salary*.10)

when jobtitle='accountant' then salary+(salary*.05)

when jobtitle='hr' then salary+(salary*.000001)

else salary+(salary*.03)

end

from employeedemographics as e1

join employeesalary as e2

using(employeeid);