The latest scores from the Japanese Baseball League are in the table with schema

Question

The latest scores from the Japanese Baseball League are in the table with schema Scores (Team, Day, Opponent. Runs) Gives the scores in the Japanese, Baseball league for two consecutive days the data in this table is follows: Determine the result of the following quart SELECT Team Day FROM Scores S1 WHERE NOT EXISTS. SELECT FRCM Scores S2. WHERE S1 Runs - S2 Rune; AND (S1 Team S2 Team OR S1 Day S2 Day Identify, in the list below one of the, tuples in the result (Bay stars Monday) Crop Sunday Bay Stars Sunday Corp Sunday

Explanation / Answer

The answer is B, (Carp, Sunday)

Explanation :
The query finds the team(s) that have scored least runs for each day.This is how the query does it. For each record in the table (outer query), the inner query select all the runs scored on the same day. Then, it checks whether the runs of the current team is less than ALL of them. The ALL clause is of importance here, it assures that the condition (runs <=) is applied over all the elements in the list and returns true only if it satisfies for all of them.

We get the following records in the result
(Carp, Sunday)
(Bay Stars, Sunday)
(Swallows, Monday)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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