Question: The table Scores ( Team , Day, Opponent, Runs ) Contains the following 1 2 rows: Team Day Opponent Runs Dragons Sunday Swallows 4 Tigers

The table
Scores(Team, Day, Opponent, Runs)
Contains the following 12 rows:
Team Day Opponent Runs
Dragons Sunday Swallows 4
Tigers Sunday Bay Stars 9
Carp Sunday NULL NULL
Swallows Sunday Dragons 7
Bay Stars Sunday Tigers 2
Giants Sunday NULL NULL
Dragons Monday Carp NULL
Tigers Monday NULL NULL
Carp Monday Dragons NULL
Swallows Monday Giants 0
Bay Stars Monday NULL NULL
Giants Monday Swallows 5
What is the result of the following query?
SELECT S1.Team, S2.Team
FROM Scores S1, Scores S2
WHERE S1.Opponent = S2.Opponent
AND S1.Team <> S2.Team
Identify in the list below a tuple of the result.
Question 9 options:
Swallows Swallows
Giants Giants
Bay Stars Bay Stars
Dragons Giants
Question 10(1 point)
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:
Team Opponent RunsFor RunsAgainst
Dragons Tigers 53
Carp Swallows 46
Bay Stars Giants 21
Marines Hawks 53
Ham Fighters Buffaloes 16
Lions Golden Eagles 812
Tigers Dragons 35
Swallows Carp 64
Giants Bay Stars 12
Hawks Marines 35
Buffaloes Ham Fighters 61
Golden Eagles Lions 128
What is the result of executing on this data the query:
SELECT *
FROM Scores
WHERE RunsFor >5
Identify in the list below, a row in the result.
Question 10 options:
Lions Golden Eagles 12
Golden Eagles Lions 128
Buffaloes Ham Fighters 1
Swallows Carp 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!