ashih

select employee_name,a.employee_id from(select  employee_id from works_sagarwal where salary >all (select salary from works_sagarwal where company_id=5 or  company_id=4 or  company_id=3))a
 inner join employee_sagarwal b on a.employee_id=b.employee_id;

 select e.employee_name from employee_sagarwal e, company_sagarwal c where c.company_name='hwt'and e.city = c.city;

select employee_name from( select employee_id from works_sagarwal t where salary >(select avg(salary) from works_sagarwal s where t.company_id = s.company_id))a inner join
 employee_sagarwal b on a.employee_id=b.employee_id;

DELETE FROM works_sagarwal  WHERE salary<1000 and employee_id IN (select e.employee_id from employee_sagarwal e where e.is_active='no');

UPDATE WORKS_sagarwal set salary = salary +  salary*5/100 where works_sagarwal.employee_id in (select employee_id from employee_sagarwal where is_active='yes' and
 datediff(month,date_of_joining,getdate())<18);