SELECT *
FROM SUPPLIER
WHERE Sno IN (SELECT Sno FROM SHIPMENT GROUP BY Sno HAVING SUM(Qty*Price) >= ALL(SELECT SUM(Price*Qty) FROM SHIPMENT GROUP BY Sno))