-- create a table empDetails
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,'p2',1600);
INSERT INTO empSalary VALUES(4,'p3',1700);
INSERT INTO empSalary VALUES(5,'p4',1800);
INSERT INTO empSalary VALUES(7,'p5',1900);

SELECT name,gender FROM empDetails e where empId IN (
 SELECT empId FROM empSalary where salary >= 1500 and e.name like "%___nna%"
)
group by gender
order by name desc
;