Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
9. Team Scores in Football Tournament
On this page

Problem

Table: Teams

+---------------+----------+
| Column Name   | Type     |
+---------------+----------+
| team_id       | int      |
| team_name     | varchar  |
+---------------+----------+
team_id is the column with unique values of this table.
Each row of this table represents a single football team.

Table: Matches

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| match_id      | int     |
| host_team     | int     |
| guest_team    | int     | 
| host_goals    | int     |
| guest_goals   | int     |

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page