A table named SALES contains a record for every sales transaction a company processes.
A user wishes to see the number of transactions that are made by each salesman. Which

SQL statement will produce the desired results?

A.
SELECT name, COUNT(*) AS transactions FROM sales

B.
SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

C.
SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

D.
SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY
transactions