SQL 15.2 Практика

Question

Как решить данную задачу?

Answer 1

https://www.sololearn.com/Discuss/2875983/?ref=app
https://www.sololearn.com/discuss/517493/?ref=app
https://www.sololearn.com/discuss/730454/?ref=app

Answer 2

it's easy sql query, for this task u need find all tables:
Select *

From league

Ok, query output all data in all tables, we need some condition (we search min conceded_goals in our table, u can use instead of 'in' sign '='):
Where conceded_goals in

Next we need subquery, for find min:
(Select Min(conceded_goals) From league)

Great, we select conceded_goals as min, final thing, u need right(desc) sort table on scored_goals:
Order by scored_goals desc

Done, after right order - ur query completed

Select *
From league
Where conceded_goals in (Select Min(conceded_goals) From league)
Order by scored_goals desc;