How to adjust a query to return only work email address and add Person Number

Summary:

Hi, I'm looking for some help to adjust the below query to only return work email address (W1) and if possible add in Person Number

Content (required):

select EMAIL_ADDRESS_ID, PERSON_ID, EMAIL_TYPE, DATE_FROM, DATE_TO, EMAIL_ADDRESS, MASTERED_IN_LDAP_FLAG

from fusion.per_email_addresses

Version (include the version you are using, if applicable):

22D

Code Snippet (add any code snippets that support your topic, if applicable):

select EMAIL_ADDRESS_ID, PERSON_ID, EMAIL_TYPE, DATE_FROM, DATE_TO, EMAIL_ADDRESS, MASTERED_IN_LDAP_FLAG

from fusion.per_email_addresses