Get the count of person records those who don't have work email id

select 
COUNT(1) 
FROM PER_ALL_PEOPLE_F papf
where papf.person_id in ( SELECT ppos.person_id FROM per_periods_of_service ppos  ) 
and   not exists 
  (  SELECT PEA.EMAIL_ADDRESS FROM per_email_addresses PEA 
     WHERE PEA.PERSON_ID = PAPF.PERSON_ID 
     AND    PEA.EMAIL_TYPE = 'W1' and rownum = 1)

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin