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(1,'p1',1500);
INSERT INTO empSalary VALUES(2,'p4',1600);
INSERT INTO empSalary VALUES(3,'p4',1600);
INSERT INTO empSalary VALUES(4,'p4',1600);
INSERT INTO empSalary VALUES(5,'p5',1800);


SELECT *
FROM (
    SELECT ROW_NUMBER() OVER(order BY empId desc) AS RowNumber 
            
    FROM empDetails
) e                                 --  may be problem in this version
WHERE e.RowNumber % 2 = 0