Microsoft
70-433 · Question #124
You have two tables named Customers and Orders. for customers that have placed at least one order, you need to produce a list of customer names and the number of orders for each customer. Which…
The correct answer is D. SELECT c.CustomerName. See the full explanation below for the reasoning.
Question
You have two tables named Customers and Orders. for customers that have placed at least one order, you need to produce a list of customer names and the number of orders for each customer. Which query should you use?
Options
- ASELECT c.CustomerName,
- BSELECT COUNT(o.OrderId) AS [OrderCount]
- CSELECT c.CustomerName,
- DSELECT c.CustomerName,
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- C8% (2)
- D83% (20)
Community Discussion
No community discussion yet for this question.