SQL exercises on soccer Database: Find those two teams which scored three goals in a single game at this tournament

SQL soccer Database: Joins Exercise-27 with Solution

27. From the following tables, write a SQL query to find those two teams, scored three goals in a single game in this tournament. Return match number and country name.

Sample table: match_details

Sample table: soccer_country

Sample Solution:

SQL Code:

SELECT match_no,country_name
FROM match_details a
JOIN soccer_country b
ON a.team_id=b.country_id
WHERE goal_score=3  AND win_lose='D';

Sample Output:

 match_no | country_name
----------+--------------
       34 | Hungary
       34 | Portugal
(2 rows)

Relational Algebra Expression:

Relational Algebra Tree:

Practice Online

Sample Database: soccer

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following tables, write a SQL query to find the oldest player appeared in a EURO cup 2016 match. Return country name, player name, jersey number and age.
Next: From the following tables, write a SQL query to find those teams that finished bottom of their respective groups after conceding four times in three games. Return country name, team group and match played.