Home goals scored per host team

From the matches table, compute the total goals each team scored in the matches it hosted. Return host_team_id and the sum of host_team_score as total_home_goals, one row per host team.

Order the result by total_home_goals (highest first), then by host_team_id.

---

Database schema

−+Fit
primary keyforeign keyarrow points to the referenced columndrag to pan