Question

Consider the following relational database schema, which describes the schedule of competition among National Football (soccer) Teams in the upcoming 2018 FIFA World Cup.

STADIUMS (StadiumName, City, Capacity)

MATCHES (StadiumName, Date, Time, Country-1, Country-2)

TEAMS (Country, Trainer, Continent)

PLAYERS (PlayerName, Country, NumGoals, Position)

Express the following query in SQL:

List the player names of all the Goalkeepers (Position), along with their corresponding country name and trainer/coach.

Answer 1

Please find the SQL query below.

QUERY:

SELECT P.PlayerName, P.Country, T.Trainer FROM PLAYERS P JOIN TEAMS T ON P.Country = T.Country WHERE P.Position = 'Goalkeeper';