Matches scoring above the host average — DBMS OPPE Question
Matches scoring above the host average
00:00
Across all rows in the matches table, compute the average host_team_score. Then return the match_num and host_team_score for every match whose host_team_score is strictly greater than that overall average. Order the result by host_team_score (highest first), then by match_num.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan