[solved] – Question 76381

Select the statement with the correct syntax below.

SELECT [CustomerID]
,[SalespersonID]
,count(*)
FROM [dbo].[Order_T]
GROUP BY [CustomerID]
,[SalespersonID]

SELECT [CustomerID]
,[SalespersonID]
,count(*)
FROM [dbo].[Order_T]
GROUP BY [CustomerID]

SELECT [CustomerID]
,[SalespersonID]
,count(*)
FROM [dbo].[Order_T]
ORDER BY [CustomerID]
,[SalespersonID]

SELECT [CustomerID]
,[SalespersonID]
,count(*)
FROM [dbo].[Order_T]

Expert Answer

---