MySql query

[RageAx]

I have to make a query that I cannot, for the life of me, figure out. I have to return alliances that have more population than an average alliance has. But the thing is I have to calculate the average based on the number of population of an alliance, not individual players. In the spoiler window, there is a data model of the database.

Spoiler

Spoiler

SELECT a.aid, alliance, SUM(population) AS population FROM igralec i
INNER JOIN naselje n ON n.pid = i.pid
INNER JOIN aliansa a ON a.aid = i.aid
GROUP BY a.aid, alliance
ORDER BY populacija DESC;

This is how I get the number of people living in the alliances

 

Oh and sorry that some text in the tables is in Slovene and not English.

[abdullah2993]

wrong forum. you should post here: https://linustechtips.com/main/forum/20-programming/