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!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
- 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 Réponses
+ 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