+ 1

MIN Function - GOAL SQL

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

31st Mar 2021, 6:21 AM
Sirisha Tammina
Sirisha Tammina - avatar
1 Answer
+ 2
The code that worked for me was: SELECT * FROM league WHERE conceded_goals = (SELECT MIN(conceded_goals) FROM league) ORDER BY scored_goals DESC;
25th May 2021, 9:17 PM
Devan Hall
Devan Hall - avatar