1SELECT 
2  c.country,
3  m.competition_name,
4  COUNT(*) as matches_played,
5  ROUND(AVG(m.home_score + m.away_score), 2) as avg_goals_per_match,
6  SUM(m.home_score + m.away_score) as total_goals,
7  MIN(m.date)::date as "First Match",
8  MAX(m.date)::date as "Last Match"
9FROM "@blt.ultimate_soccer_dataset.matches" m
10JOIN "@blt.ultimate_soccer_dataset.seasons" s 
11  ON m.season_id = s.season_id
12JOIN "@blt.ultimate_soccer_dataset.competitions" c 
13  ON s.competition_id = c.competition_id
14WHERE m.status = 'Match Finished'
15GROUP BY c.country, m.competition_name
16ORDER BY avg_goals_per_match DESC