create table employee(
    Sno int primary key not null auto_increment,
    emp_id bigint,
    emp_name varchar(255),
    emp_dept varchar(255),
    emp_salary int,
    emp_city varchar(255)
);
select * from employee where emp_city = 'Noida' or emp_city = 'New Delhi';
update employee set emp_salary = emp_salary + emp_salary*0.2 where emp_city = 'Greater Noida';
select * from employee where emp_name = 'Akash' or emp_id = 12116491214;
select * from employee where emp_salary in (select max(emp_salary) from employee where emp_dept = 'ECE') and emp_dept = 'ECE';
select * from employee where emp_city <> 'New Delhi' and emp_city <> 'Gurgaon';