Question Completion Status The data in this table is as follows: opponent RunsFo

Question

Question Completion Status The data in this table is as follows: opponent RunsFor Runs Against Dragons Ti 5 Swallows Bay Stars L Giants 2 Marines Hawks 5 1 6 Ham Fighters Buffaloes Golden Eagles 12 Lions Tigers Dragons 3 5 swallows Bay Stars Giants Hawks Marines Buffaloes Ham Fighters Lions 12 8 Golden Eagles What is the result of executing the following query on this data: SELECT FROM Scores WHERE Runs For 5; Identify, in the list below, a row in the result. O Giants Bay Stars 1 2 O Dragons Tigers 5 3 Tigers Dragons 3 5 O Lions Golden Eagles 8

Explanation / Answer

SELECT * FROM Scores WHERE RunsFor > 5;
This will select the rows of the table which has the column RunsFor value > 5.
So, among the given choices, the answer is:
Lions GoldenEagles 8 12 qualify the query. All other field values are either lessthan or equal to 5.

SELECT Team FROM Scores WHERE RunsFor > (RunsAgainst + 1);
This will select the Team column of the table whose wins agains the team by more than one run.
Baby Stars RunsFor(2) is equal to RunsAgainst+1(1+1), so doesn't qualify.
Swallows RunsFor(6) is greater than RunsAgainst+1(4+1) so this do qualify.
Carp and HamFighters scored less than their Opponents.
So, the answer is: Swallows.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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