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

Exercise

Conditional selection and summation with CASE WHEN

You can use CASE statements to apply a constraint and run a calculation by including the statement inside an aggregate function like SUM()!

In this exercise, your goal is to filter for a specific team (Real Sociedad) and calculate their total home and away goals per season.

Instructions

100 XP
  • Create a CASE statement to calculate the total number of home goals where the hometeam_id is 8560.
  • Create a second CASE statement to calculate the total number of away goals where the awayteam_id is 8560, aliasing the column as away_goals.
  • Group the query by season.