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?
A.
SELECT c.CustomerName,
SUM(o.OrderID) AS [OrderCount]
FROM Customers c
JOIN Orders o
ON c.CustomerID = o.CustomerID
GROUP BY c.CustomerName
B.
SELECT COUNT(o.OrderId) AS [OrderCount]
FROM CUSTOMERS c
JOIN ORDERS o
ON c.CUSTOMERID = o.CUSTOMERID
C.
SELECT c.CustomerName,
COUNT(o.OrderID) AS [OrderCount]
FROM Customers c
JOIN Orders o
ON c.CustomerID = o.CustomerID
GROUP BY c.CustomerName
HAVING COUNT(o.OrderID) > 1
D.
SELECT c.CustomerName,
COUNT(o.OrderId) AS [OrderCount]
FROM Customers c
JOIN Orders o
ON c.CustomerId = o.CustomerId
GROUP BY c.CustomerName