Просмотр поста

SELECT 
    a.SupplierID, a.ProductName, a.Price
FROM
    Products a
        INNER JOIN
    (SELECT 
        SupplierID, MAX(Price) AS mPrice
    FROM
        Products
    GROUP BY SupplierID) b ON (a.SupplierID = b.SupplierID
        AND a.Price = b.mPrice);

SELECT TOP 1 
    a.SupplierName, SUM(b.Price) AS summa
FROM
    Suppliers a
        INNER JOIN
    Products b ON (a.SupplierID = b.SupplierID)
GROUP BY SupplierName , b.Price
ORDER BY b.Price DESC;

SELECT TOP 1
    SUM(a.Price) AS summa, b.SupplierName 
FROM
    Products a
        INNER JOIN
    Suppliers b ON b.SupplierID = a.SupplierID
GROUP BY b.SupplierName
ORDER BY SUM(a.Price) DESC;