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 transactionsFROM sales
B. SELECT name, COUNT(DISTINCT name) AS transactionsFROM sales
C. SELECT name, COUNT(*) AS transactionsFROM salesGROUP BY name
D. SELECT DISTINCT name, COUNT(*) AS transactionsFROM salesGROUP BY transactions
|
Download Printable PDF. VALID exam to help you PASS. |
 |