1. Learn
    2. /
  2. Courses
    3. /
  3. Data Manipulation in SQL

Exercise

COUNT using CASE WHEN

Do the number of soccer matches played in a given European country differ across seasons? We will use the European Soccer Database to answer this question.

You will examine the number of matches played in 3 seasons within each country listed in the database. This is much easier to explore with each season's matches in separate columns. Using the country and unfiltered match table, you will count the number of matches played in each country during the 2012/2013, 2013/2014, and 2014/2015 match seasons.

Instructions 1/2

undefined XP
    1
    2
  • Create a CASE statement that identifies the id of matches played in the 2012/2013 season. Specify that you want ELSE values to be NULL.
  • Wrap the CASE statement in a COUNT function and group the query by the country alias.