試題詳解

17. Refer to Tables 1 and 2 below, please choose the CORRECT outputs ( A ) and ( B ) resulted from the execution of the following SQL statements:

Output

Table 1. students

Table 2. math

 
(A) Name = Sam, Score = 80
(B) Name = Jerry, Score = 55
(C) Name = Mary, Score = 60
(D) Name = Sam, Score = 73
(E) Name = Mary, Score = 73