1,967 of our person profiles work for a "Dunder Mifflin" company
complete
A
Apricot cream Dormouse
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
L
Loud Stork
doing now