24. Refer to Table 3 and Table 4, please indicate the CORRECT SQL statement that can output as depicted in Table 5.

(A) SELECT * FROM movies
(B) SELECT TOP 1 movies.movie, actors.name FROM movies INNER JOIN actors ON movies.actor = actors.id ORDER BY actors.salary DESC
(C) SELECT movies.movie, actors.name FROM movies INNER JOIN actors ON movies.actor = actors.id ORDER BY actors.salary
(D) All of the above can output the same results, as shown in Table 5.
(E) None of the above can output the same results, as shown in Table 5.

答案:登入後查看
統計: A(1), B(4), C(2), D(0), E(2) #2911462