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!
New course! Every coder should learn Generative AI!
Try a free lesson
- 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

sql
26th May 2021, 1:31 PM
saffadya devan
3 Answers
+ 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
0
Hope this helps you. https://code.sololearn.com/Wj8CzNv9Ydvl/?ref=app
26th May 2021, 4:39 PM
Naryani Priya
Naryani Priya - avatar

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Strange narrowing conversion error from FLTK Color to Color Struct, Stroustrup's header Graph.h
0 Votes
Can anyone help me with this?
0 Votes
Python Question
3 Votes
How to learn fast C?
0 Votes
Hi everyone! I want change div with name "cd" to text(how to add url here)when I click button. No my code not worked. help me.
1 Votes
While loop with input dont work
1 Votes
There is a Python test on Solularen, but I did not find the correct solution.
0 Votes
Initials of name
1 Votes
Radios
0 Votes
Coder or Programmers
2 Votes