create database MyEmployees;
use myemployees;
create table Emp(id int, Username varchar(10), age smallint, salary mediumint, Phone bigint, Designation varchar(15));
insert into Emp values(100, 'Abhi',25,800000,98789309874,'Manager');
select * from Emp;
insert into Emp values(200, 'Kabhi',45,900000,9867809874,'Manager');
insert into Emp values(300, 'Jabhi',25,48000,98789309874,'Manager');
insert into Emp values(400, 'Tabhi',25,30000,98789309874,'Manager');
select * from Emp;
select * from Emp where Salary <=60000;
insert into Emp values(500, 'King',24,30000,9082209875, 'Analyst');
select * from Emp;
SET SQL_SAFE_UPDATES=0;
UPDATE emp set salary=90000 where id=500;
select * from Emp;
select * from Emp where designation='Manager';
select * from Emp; 
select * from Emp where salary<=50000 and designation='manager';
select * from Emp where age<=50 and designation='manager';
select * from Emp; 
update emp set designation='Clerk' where Username='Kabhi';
select * from Emp; 
update emp set salary=150000, designation='manager' where id=500;
select * from Emp;
delete from emp where id=200;
select * from Emp;
update emp set designation='analyst' where id=500;