Use SQL query with window function to rank members by transaction amount in each city.

• Use SQL query with PARTITION BY clause to group members by city

• Use ORDER BY clause to rank members by transaction ...read more