Football Matches - Tasks

Each of the questions/tasks below can be answered using a SELECT query. When you find a solution copy it into the code block under the question before pushing your solution to GitHub.

  1. Find all the matches from 2017.

<!-- Copy solution here -->
  1. Find all the matches featuring Barcelona.

<!-- Copy solution here -->
  1. What are the names of the Scottish divisions included?

<!-- Copy solution here -->
  1. Find the division code for the Bundesliga. Use that code to find out how many matches Freiburg have played in the Bundesliga since the data started being collected.

<!-- Copy solution here -->
  1. Find the unique names of the teams which include the word "City" in their name (as entered in the database)

<!-- Copy solution here -->
  1. How many different teams have played in matches recorded in a French division?

<!-- Copy solution here -->
  1. Have Huddersfield played Swansea in the period covered?

  1. How many draws were there in the Eredivisie between 2010 and 2015?

  1. Select the matches played in the Premier League in order of total goals scored from highest to lowest. Where there is a tie the match with more home goals should come first.

  1. In which division and which season were the most goals scored?

Useful Resources

Last updated