1,967 of our person profiles work for a "Dunder Mifflin" company
complete
C
Chris Horan
Not sure how I came across it but this small number of fake profiles could be some insight into potentially many other fake company and person profiles we have that are in our production dataset.
SELECT *
--COUNT(*)
FROM person.person a,
person.job b
WHERE a.id = b.person_id
AND b.company_id IN (
SELECT id
FROM company.company
WHERE primary_name LIKE '%dunder%mifflin%');
B
Ben Eisenberg
complete
This was fixed in v_25.2
C
Christine Biddlecombe
doing now