1. Table rows Partition in SQL using window functions SELECT FirstName, LastName, City, ROW_NUMBER() OVER ( PARTITION BY City ORDER BY...