Use DENSE_RANK() to generate unique IDs for address in silver_address, then join it in silver_people using city and country. Example:

sql

CopyEdit

DENSE_RANK() OVER (ORDER BY City, Country) AS ID

Join to map Address_ID for each person.