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?

<!-- Copy solution here -->

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

<!-- Copy solution here -->

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.

<!-- Copy solution here -->

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

<!-- Copy solution here -->

Useful Resources

• Filtering results

• Ordering results

• Grouping results