PavloSheichenko

SELECT s.SupplierID, s.SupplierName, p.ProductName, p.Price
FROM Suppliers s, Products p
WHERE p.SupplierID=s.SupplierID GROUP BY Suppliername ORDER BY MAX(Price) DESC