What would be the best answer for the following MySQL syntax and why?
1) A query to formulate a report that shows the total number of orders by customer since December 31, 1996 and which returns rows for which the NumOrders is greater than 15 could be:
SELECT c.CompanyName, COUNT(o.OrderID) AS NumOrders
FROM Customers c