USE NORTHWIND DATABASE:

SQL

Answer the question: Which region produces the most orders? Write a SELECT statement that returns two columns: RegionDescription, and NumberOfOrders, where NumberOfOrders is the count of OrderID. Group by the RegionDescription. Order the results by the region with the most orders first. The result set should only show the number of orders for each region (there should be 4 rows in the result set). Hint: You will have to join multiple tables to get the required data.