1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. Intermediate SQL Server

Connected

अभ्यास

Window functions with aggregations (II)

In the last exercise, you calculated the sum of all orders for each territory. In this exercise, you will calculate the number of orders in each territory.

निर्देश

100 XP
  • Count the number of rows in each partition.
  • Partition the table by TerritoryName.