SQL1

SELECT Products.ProductName,COUNT(OrderDetails.OrderDetailID) AS NumberOfOrders FROM OrderDetails
LEFT JOIN Products ON Products.ProductID = OrderDetails.ProductID
GROUP BY ProductName;