Question

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]

Accepted Answer

Correct answer №1:

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

Question #76381

Expert's answer