Write a query to output all teams which conceded the least number of goals in the league ordered by scored goals in descending o

Question

Can anyone please help me with the answer. I am new learner to SQL and tried many times but the code is showing error.

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

Answer 1

no @Simba. I can't.

Answer 2

/*Try this*/

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

Answer 3

Can we see your code?

Answer 4

It's OK.
Me neither 👋

Answer 5

GOT correct code from a post :)

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

Thanks!

Answer 6

oh..sorry I got it wrong :P
CODE is posted below my question.