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

/*select empId,project,salary,count(*) from empSalary
where salary=1600;*/
select * from empSalary;

--How many Duplicate salary we have 
select salary,count(salary)
from empSalary
group by salary
having count(salary) >1;   

/*1600|2
  1800|2*/


--How many Duplicate record we have, (means: group by te joto gula record lagbe oigula koto gula kotogula duplicate thake) 
--https://[Log in to view URL]

select empId,project,salary,count(*)
from empSalary
group by project,salary
having count(*) >1;