Write a query to output all teams which conceded the least number of goals in the league ordered by scored goals in descending?? | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
- 4

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

Help me

26th May 2021, 1:31 PM
saffadya devan
3 Antworten
+ 1
select * from league where conceded_goals = (select min(conceded_goals) from league) order by scored_goals desc:
28th Jun 2021, 3:54 AM
Tyler
Tyler - avatar
0
show. your. attempt.
26th May 2021, 2:15 PM
Dino Wun (Use the search bar plz!)
Dino Wun (Use the search bar plz!) - avatar
26th May 2021, 4:39 PM
Naryani Priya
Naryani Priya - avatar