Question

4. The latest scores from the Japanese Baseball League are in the table with schema Scores(Team, Opponent, RunsFor, Runs Against) The data in this table is as follows: 2 Team Opponent RunsFor RunsAgainst Dragons Tigers Carp Swallows 4 Bay Stars Giants Marines Hawks Ham Fighters Buffaloes Lions Golden Eagles 8 Tigers Dragons 3 Swallows Carp 6 Giants Bay Stars 1 Hawks Marines Buffaloes Ham Fighters 6 Golden Eagles Lions 12 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 statement. O a) 4 appears twice. O b) 5 appears twice. O c) 2 appears twice. O d) 8 appears twice.

Answer 1

4 appears once
5 appears twice
2 appears once
8 appears once

So, answer is 5 appears twice


Answer:

5 appears twice