Filtering with more complex subquery conditions
In the previous exercise, you generated a list of teams that have no home matches listed in the soccer database using a subquery in WHERE
. Let's do some further exploration in this database by creating a list of teams that scored 8 or more goals in a home match.
In order to do this, you will construct a subquery in the WHERE
statement with its own filtering condition.
This exercise is part of the course
Data Manipulation in SQL
Exercise instructions
- Create a subquery in
WHERE
clause that retrieves allhometeam_ID
values frommatch
with ahome_goal
score greater than or equal to 8. - Select the
team_long_name
andteam_short_name
from theteam
table. Include all values from the subquery in the main query.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Select the team long and short names
___,
___
FROM ___
-- Filter for teams with 8 or more home goals
WHERE team_api_id ___
(SELECT ___
FROM ___
WHERE ___ >= ___);