Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What is linear transformation? Define with example

Answered: 1 week ago

Question

state what is meant by the term performance management

Answered: 1 week ago