Hi,
You can use this query to get the TradeID and the lowest price from the table.
SELECT TradeId,MIN(TradeValue) from Trade Group By TradeId;
Trade - Table Name
Computer Software Engineer
Master In Computer Applications