SQL Queries

select employeeid,salary
from employeedemographics as d
join employeesalary as s
using(employeeid);

select a.employeeid,a.firstname,b.jobtitle,c.age
from employeedemographics a
left join employeesalary b
on a.employeeid=b.employeeid
left join warehouseemployeedemographics c
on a.employeeid=c.employeeid;


select *
from employeedemographics
join employeesalary
using(employeeid);


select gender,count(gender) as count_gender
from employeedemographics
join employeesalary
using(employeeid)
group by gender;