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

delete from empSalary
where empId in (
select empId from empSalary
group by project,salary
having count(*) > 1
);
select * from empSalary;     -- duplicate thakle 1 ta delete kore dibe