IBM
C2090-610 · Question #109
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…
The correct answer is C. SELECT name, COUNT(*) AS transactions. See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT name, COUNT(*) AS transactions
- BSELECT name, COUNT(DISTINCT name) AS transactions
- CSELECT name, COUNT(*) AS transactions
- DSELECT DISTINCT name, COUNT(*) AS transactions
How the community answered
(32 responses)- A9% (3)
- B6% (2)
- C81% (26)
- D3% (1)
Community Discussion
No community discussion yet for this question.