QUESTION 7 The latest scores from the Japanese Baseball League are in the table

Question

QUESTION 7 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 Dragons RunsFor Tigers Swallows Giants Hawks Bay Stars Ham Fighters Buffaloes 12 Lions Tigers Swallows Giants Hawks Buffaloes Golden Eagles Dragons Carp Stars Marines Ham F Golden Eages Lions What is the result of executine the followine query on this data SELECT Team FROMScores WHERE RunsFor> ( RunsAgainst+ 2): Identify. in the list below, a row in the result ?Carp ? Giants O Tigers O Golden Eagles

Explanation / Answer

Answer: Golden Eagles

Explanation :

For Carp, RunsFor = 4 and RunsAgainst = 6, so RunsFor > (RunsAgainst + 2) which is 4 > 8 is false. So, Carp will not be in result.

For Giants, RunsFor = 1 and RunsAgainst = 2, so RunsFor > (RunsAgainst + 2) which is 1 > 4 is false. So, Giantswill not be in result.

For Tigers, RunsFor = 3 and RunsAgainst = 5, so RunsFor > (RunsAgainst + 2) which is 3 > 7 is false. So, Tigers will not be in result.

For Golden Eagles, RunsFor = 12 and RunsAgainst = 8, so RunsFor > (RunsAgainst + 2) which is 12 > 10 is true. So, Golden Eagles will be in result.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.