To find the Number of goals scored by that country

Given the database of Football tournament , sort the countries by the number of the goals scoreed by that country, descending. The number of goals scored by the country is the sum of the goals scored by its players .

if two or more countries have the same number of code sort the countries by their countries.id

---

Players table

----------------  ID      name  1      XXX  2       YYY  3      ZZZ  4     JJJ  ----------------  

Countires table

-----------  id name  1 Country1  2 Country2  -------------  

Goals table

----------------------------  Player_id Country_id goals  1          1         6  2          2         8  3          1         9  4          2         10  

https://stackoverflow.com/questions/65819817/to-find-the-number-of-goals-scored-by-that-country January 21, 2021 at 09:05AM