Question Completion Status 10 Question 1 The latest scores from the Japanese Bas

Question

Question Completion Status 10 Question 1 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 Swallows Carp Giants 2 Bay Stars Hawks 5 Marines Ham Fighters Buffaloes 6 Lions Golden Eagles Tigers Dragons Swallows Bay Stars 1 2 Giants 3 Hawks Marines Buffaloes Ham Fighters What is the result of executing the following query on this data? SELECT Team AS Winner, RunsFor RunsAgainst AS Runs FROM Scores WHERE Runs For RunsAgainst Identify in the list below, a value and the name of a column in which it appears. a "Golden Eagles" appears in the column Team. b, s appears in the column Run2Against c. Dragons" appears in the column Winner d. "Buffaloes appears in the column Team Moving to another question will save this respons

Explanation / Answer

1) A is the answer. Because there will be two columns returned one as Winner and second as Runs.

In that dragon will come under winner column.

2) B is the answer as (1,2,4,7,9)

3)

4) A is the answer as 6 appears twice for swallows and buffaloes

5)D is the answer as Marines as it is the result which will show as runsfor (5) > runsagainst(3+1).

6) D is the answer as hawks. Because hawks is one of the result which satisfies the condition.

7)C is the answer as buffaloes and bay stars pair satisfy the question.

8) A is the answer as that satisfies the query and is one of the total result.

9)A is the answer as the Marines satisfies '_i%' as opponent stated in query

10) B is the answer as buffaloes satisfy the query where runsfor > rundagainst.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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