SQL Queries

select * from employeedemographics;

select Gender,count(Gender) as count_gender

from employeedemographics

where age>31

group by Gender;

select Gender,count(Gender) as count_gender

from employeedemographics

where age>31

group by Gender

order by count_gender desc;

select * from employeedemographics

order by age desc;

select * from employeedemographics

order by age,gender desc;

select * from employeedemographics

order by age desc,gender desc;

select * from employeedemographics

order by 4 desc,5 desc;

select * from employeedemographics;

select * from employeesalary;

select * 

from employeedemographics as e1

inner join employeesalary as e2

on e1.employeeid=e2.employeeid;

select * 

from employeedemographics

inner join employeesalary

using(employeeid);