The latest scores from the Japanese Baseball League are in the table with schema
Scores(Team, Opponent, RunsFor. RunsAgainst)The data in this table is as follows (see picture):
(Choose 1 answer)
Suppose we would like to executethe following query:
SELECT Team, Opponent FROM Scores
WHERE Team LIKE '% %' OR
Opponent LIKE '_i%'
Identify, in the list below, a row of the result.
Team
Dragons
Carp
Bay Stars
A. (Giants, Bay Stars)
B. (Swallows. Carp)
C. (Hawks, Marines)
D. (Golden Eagles, Lions)
Opponent
RunsFor
RunsAgainst
Tigers
5
3
Swallows
4
6
Giants
2
1
Marines
Hawks
5
3
Ham Fighters
Buffaloes
1
6
Lions
Golden Eagles
8
12
Tigers
Dragons
3
5
Swallows
Carp
6
4
Giants
Bay Stars
1
2
Hawks
Marines
3
5
Buffaloes
Ham Fighters
6
1
Golden Eagles
Lions
12
8
Et 45
