Consider the table employee(empId, name, department, salary)

what will be output ,, and how ?

please explain complete mechanism in details.

i am can't understand anything how it works.

|| create table employee(empId Int(50), name varchar(50), department int(50), sal 2 insert into employee values (1, 'a', 4, 90) 3 insert into employee values (2, b', 5, 3) 4 insert into employee values (3, 'c, 5, se); 5 insert into employee values (4, 'd', 5, 8e): 6 insert into employee values (8, f', 7, 10) 1 Select 1 Select * From employee e where not exists (Select From employee s where s.department 5 and s.salary e.salary 4