You use a Microsoft SQL Server database that contains a table. The table has records of customer orders.
Your company has three divisions that have the following names:
East
Central West
You need to create a query that displays the following information:
The number of sales for each product (ProductName) grouped by the division (Division) that sold the product A column for each division
Which Transact-SQL query should you use?
A.
B.
C.
D.