Use window functions like ROW_NUMBER() to find highest sales from each city in SQL.

• Use PARTITION BY clause in ROW_NUMBER() to partition data by city

• Order the data by sales in descending order

• Filter th...read more