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

Explanation: