MIN Function - GOAL SQL

Question

Guys in MIN function in sql we have que about goals, where I gave the code
Select team, scored_goals, (select MIN(conceded goals) from league) as conceded_goals from league order by scored_goals DESC;

Not sure where I went wrong but it’s not working

Answer 1

The code that worked for me was:

SELECT * FROM league
WHERE conceded_goals = (SELECT MIN(conceded_goals) FROM league)
ORDER BY scored_goals DESC;