SQL Interview Question | 27 | #dataengineering | #dataanalyst | #powerbi | #sql #dataengineer

If you like this video please like, share & subscribe and comment down below.. if you have any suggestion or doubt in this video. Script: create table emp_info(id int, name varchar(10),dept varchar(10),salary int); insert into emp_info values(1,'Akash','Sales',100) insert into emp_info values(2,'John','Sales',110) insert into emp_info values(3,'Rohit','Sales',100) insert into emp_info values(4,'Tom','IT',200) insert into emp_info values(5,'Subham','IT',205) insert into emp_info values(6,'Vabna','IT',200) insert into emp_info values(7,'Prativa','Marketing',150) insert into emp_info values(8,'Rahul','Marketing',155) insert into emp_info values(9,'yash','Marketing',160)