query to get address number via SourceSystem and SourceSystemReferenceValue (address).

Summary:

query to get address number via SourceSystem and SourceSystemReferenceValue (address).
Looking for table_name to get the values of SourceSystem and SourceSystemReferenceValue

Content (please ensure you mask any confidential information):

objective: to build a query to get address number

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

select site_number from table_name
where
sourcesystem="OneKey"
SourceSystemReferenceValue = 'ADD001'

Regards,

Mohammed Hyder