/* Write a query to find all duplicate jobs in the People table */ select count(*) from People p1 join People p2 on p1.Job = p2.job and p1.FirstName <> p2.FirstName; /* Write a query to find all duplicate FirstName, and Job values in the People table and number of duplicates */ with cte as( select row_number() over(order by FirstName, job) as num, FirstName, job from People ) select count(*) from cte p1 join cte p2 on p1.Job = p2.job and p1.FirstName = p2.FirstName and p1.num <> p2.num; /* Write a query to find all duplicate First Names with different jobs in the People table */ select p1.FirstName from People p1 join People p2 on p1.Job < p2.job and p1.FirstName = p2.FirstName;
