Question

From the previous query you can see that Lars Bender's scored a goal in game 1012. Now we want to know what teams were playing in that match.

Notice in the that the column matchid in the goal table corresponds to the id column in the game table. We can look up information about game 1012 by finding that row in the game table.
Show id, stadium, team1, team2 for just game 1012

Answer 1

The question involves using an SQL query to determine the teams playing in game 1012, where Lars Bender scored. This task is part of a Computers and Technology subject, specifically database management at the College level.

Step-by-step explanation:

The student is likely working on a database-related exercise, specifically involving SQL queries to retrieve information from relational database tables. The relevant subject for this question is Computers and Technology, and it appears suitable for a College-level course, potentially in a database management or information systems program.

To find out the teams involved in game 1012, which Lars Bender scored a goal in, you would need to perform an SQL query that joins the goal table and the game table, where the matchid from the goal table equals the id from the game table. By specifying the condition that the game id is 1012, you would retrieve information on the stadium, team1, and team2 for that specific game.