The match_referees table links each match to five referee roles; the referee column holds the id of the head referee. Join matches, match_referees and referees to find the head referee's name for every match.
Return three columns: match_num, match_date, and the head referee's name as referee_name.
Order the rows by match_date.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan