Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

v Question completion Status: Scores(Team, opponent, RunsFor, RunsAgainst) The d

ID: 3810562 • Letter: V

Question

v Question completion Status: Scores(Team, opponent, RunsFor, RunsAgainst) The data in this table is as follows: nent RunsFor I RunsAgainst Dragons Swallows Bay Stars Giants 2 Marines Hawks Ham Fighters Buffaloes Lions Golden Eagles 8 12 Ti Dragons Swallows Bay Stars 1 Giants Hawks Marines Buffaloes Ham Fighters Golden Eagles Lions What is the result of executing the following query on this data: SELECT Team FROM Scores WHERE RunsFor RunsAgainst; Identify, in the list below, a row in the result. O Carp O Swallows O Bay Stars O Ham Fighters

Explanation / Answer

Q.
   Result of given queryy:
       Dragons
       Bay Stars
       Marines
       Swallows
       Buffalos
       Golden Egales

   Ans:
       B: Swallows
       C : Bay Stars

Q
   Given: (5,5,5) , a = 5, b = 5, c = 5

   Ans: d. (6, 7, 4)

       a = 6, b = 7, c = 4

       c should be in descending order (4 < 5)
       b should be in ascending order( 7 > 5)