#newgradiance #dbms #sql #joins Q1

Question

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

Scores(Team, Opponent, RunsFor, RunsAgainst)

The data in this table is as follows:

Team	Opponent	RunsFor	RunsAgainst
Dragons	Tigers	5	3
Carp	Swallows	4	6
Bay Stars	Giants	2	1
Marines	Hawks	5	3
Ham Fighters	Buffaloes	1	6
Lions	Golden Eagles	8	12
Tigers	Dragons	3	5
Swallows	Carp	6	4
Giants	Bay Stars	1	2
Hawks	Marines	3	5
Buffaloes	Ham Fighters	6	1
Golden Eagles	Lions	12	8

What is the result of executing on this data the query:

     SELECT S1.Team, S2.Team
     FROM Scores S1, Scores S2
     WHERE S1.Team < S2.Team AND
         (S1.RunsFor = S2.RunsFor 
          OR S1.RunsAgainst = S2.RunsAgainst)

Remember that when strings are compared, "<" means "precedes in alphabetical order.

Identify, in the list below, a row of the result.

a)	Ham Fighters Lions
b)	Bay Stars Buffaloes
c)	Lions Marines
d)	Golden Eagles Lions