CREATE TABLE empDetails (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  managerID INTEGER NOT null,
  gender TEXT NOT NULL
);
-- create a table empSalary
create table empSalary (
 empId INTEGER PRIMARY KEY,
 project TEXT not NULL,
 salary INTEGER not NULL
);

-- insert some values
INSERT INTO empDetails VALUES (1, 'Ryan',102, 'M');
INSERT INTO empDetails VALUES (2, 'Joanna',103, 'F');
INSERT INTO empDetails VALUES (3, 'adnan',104, 'M');
INSERT INTO empDetails VALUES (4, 'Joanna',105, 'F');
INSERT INTO empDetails VALUES (5, 'adnan',106, 'M');
INSERT INTO empDetails VALUES (6, 'Joanna',108, 'F');
-- fetch some values
INSERT INTO empSalary VALUES(2,'p1',1500);
INSERT INTO empSalary VALUES(3,'p4',1600);
INSERT INTO empSalary VALUES(4,'p4',1600);
INSERT INTO empSalary VALUES(5,'p4',1800);
INSERT INTO empSalary VALUES(7,'p5',1800);



select * from empSalary emp1
WHERE 2 = (                                             -- 2 dea mane : 3rd highest
   SELECT COUNT(DISTINCT(emp2.salary)) FROM empSalary emp2
    WHERE emp1.salary < emp2.salary                               --- version problem
)