Question Completion Status The data in this table is as follows: Team Day oppone

Question

Question Completion Status The data in this table is as follows: Team Day opponent Runs Dragons Sunday swallows 4 Tigers Sunday Bay Stars 9 Carp Monday Dragons 10 Monday Giants 7 Hawks Buffaloes Tuesday Tigers 2 Lions Tuesday Giants 0 2 Bay Stars Friday Tigers Golden Eagles Friday Swallows 5 What is the result of executing the following query on this data: SELECT S1.Team FROM Scores S1, Scores S2 WHERE S2. eam Dragons' AND si Team S2 team AND si Runs S2Runs; Identify in the list below a tuple of the result. O a. Buffaloes O b. Bay Stars O c Dragons O d Golden Eagles

Explanation / Answer

1) c.Dragons

Since it evaluates by comparing the runs scored

2) a.(3,4,2,4,6) it joins combining both tables

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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