Team Opponent RunsFor RunsAgainst Dragons Tigers Carp swallows 6 Bay Stars Giant

Question

Team Opponent RunsFor RunsAgainst Dragons Tigers Carp swallows 6 Bay Stars Giants I2 1 Marines Hawks Ham Fighters Buffaloes 1 6 Lions Golden Eagles 8 12 Tigers Dragons 3 5 Swallows Carp 6 Giants Bay Stars 2 Hawks Mari rines Buffaloes Ham Fighters Golden Eagles Lions What is the result of executing on this data the query: SELECT DISTINCT Team, RunsFor FROM Scores: In the list below are statements about certain numbers of runs and how many times they appear in the table that is printed as a result of this query. Identify the true O a. 3 appears once O b 4 appears once c 1 appears four times

Explanation / Answer

SELECT DISTINCT Team,RunsFor from Scores;

a. 3 appears once

false, 3 appears twice for Team Tigers and Hawks

b. 4 appears once

true for Team Carp

c. 1 appears 4 times

false 1 appears 2 times for Teams Ham Fighters and Giants

d. 2 appears twice.

false 2 appears once for Team Bay Stars.

Select Team from Scores where RunsFor > (RunsAgainst + 1);

There are 5 rows matching the condition in the query

Team            RunsFor            RunsAgainst

Dragons         5                       3

Marines         5                         3

Swallows       6                        4

Buffaloes       6                        1

Golden Eagles 12                    8

Answer : Swallows

select * from Scores where RunsFor > 5;

Buffaloes    Ham Fighter   6 1

here RunsFor = 6 > 5

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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