I am unable to solve the 15.2 practice of SQL.

Question

My try:

SELECT team, scored_goals, MIN(conceded_goals) AS conceded_goals FROM league ORDER BY scored_goals DESC;

Answer 1

Posted by "Alan" in the course:
The MIN has to be a subquery. Try this :

SELECT * FROM league WHERE conceded_goals = (SELECT MIN(conceded_goals) FROM league) ORDER BY scored_goals DESC;
Sounds good to me 😎
https://www.sololearn.com/learning/1861/
Subquery link

Answer 2

Thanks but contradictory to their lesson taught.