SQL Window Function to Retrieve Addresses with More Than One Unique Last Name in Snowflake

Ranking Multiple Groups of Records Over Multiple Columns Using SQL Window Functions