Ambiguous groups wrong

[leonardomathon]

The following queries will return the ambiguous groups anti-pattern which is wrong

SELECT Shippers.ShipperName, COUNT(Orders.OrderID) AS NumberOfOrders FROM Orders
LEFT JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID
GROUP BY ShipperName;

SELECT Shippers.ShipperName,
  COUNT(Orders.OrderID) AS NumberOfOrders
FROM Orders, Shippers
WHERE Orders.ShipperID = Shippers.ShipperID
GROUP BY ShipperName;

SELECT supplierId as a, AVG(price)
FROM product
WHERE pCategory <> NULL
GROUP BY supplierId
HAVING AVG(price) > 9.99