Can someone tell me the correct query for this problem using MIN

Question

Football is the most popular sport in the world!
Look at the following table named league.
Database Table Picture - https://api.sololearn.com/DownloadFile?id=4550
Write a query to output all teams which conceded the least number of goals in the league ordered by scored goals in descending order.

My Code -
SELECT * FROM league
WHERE conceded_goals = 2
ORDER BY scored_goals DESC;

Answer 1

your query looks like it would work. i usually use * for my initial query and as i get closer to the query i like, i replace * with the actual fields, even if i am querying all the columns (personal preference).
my take would look something like this:

select
team
,scored_goals
,conceded_goals
from
league
where
conceded_goals=(select min(conceded_goals) from league)
order by
scored_goals desc;

Answer 2

Thanks Andrew Choi, I was a bit confused with the where query, thanks for explaining it!

Answer 3

Yash Sawant , happy to assist.