SQL Queries

create table emp

(empid int,

firstname varchar(50),

lastname varchar(50),

age int,

gender varchar(50));

create table empsal

(empid int,

jobtitle varchar(50),

salary int);

insert into emp values

(1002, 'Pam', 'Beasley', 30, 'Female'),

(1003, 'Dwight', 'Schrute', 29, 'Male'),

(1004, 'Angela', 'Martin', 31, 'Female'),

(1005, 'Toby', 'Flenderson', 32, 'Male'),

(1006, 'Michael', 'Scott', 35, 'Male'),

(1007, 'Meredith', 'Palmer', 32, 'Female'),

(1008, 'Stanley', 'Hudson', 38, 'Male'),

(1009, 'Kevin', 'Malone', 31, 'Male');

insert into empsal values

(1001,'salesman',45000);

insert into empsal values

(1002, 'Receptionist', 36000),

(1003, 'Salesman', 63000),

(1004, 'Accountant', 47000),

(1005, 'HR', 50000),

(1006, 'Regional Manager', 65000),

(1007, 'Supplier Relations', 41000),

(1008, 'Salesman', 48000),

(1009, 'Accountant', 42000);

select * from emp limit 5;

select count(firstname) from emp;

select * 

from test.emp;

select gender,count(gender) as count_gender

from emp

where age>31

group by gender;

select gender,count(gender) as count_gender

from emp

where age>31

group by gender

order by count_gender desc;

select *

from emp

order by 4 desc,5 desc;

select *

from emp

inner join empsal

on emp.empid=empsal.empid;

select *

from emp

inner join empsal

using(empid);

select *

from emp

full join empsal

using(empid);