How can I make a query (SQL) with two tables?

I have a database like in the attached picture

I want to make a query that will display:

Please help. Thank you in advance.

I’m learning sql and I can’t deal with this query.

>Solution :

Based on the input table structure, you should use JOIN operator to get home and away team name for the result.

Here is the query:

SELECT
    h.name as home,
    a.name as away,
    g.score_home,
    g.score_away,
    g.date
FROM
    games g
JOIN
    team h
ON
    g.id_team_home = h.id_team
JOIN
    team a
ON
    g.id_team_away = a.id_team