• Create a CASE statement that identifies whether a match in Germany included FC Bayern Munich, FC Schalke 04, or neither as the home team.
  • Group the query by the CASE statement alias, home_team.