【单选题】下面的SQL语句用于在SQL Server的PUBS数据库中查找所有住在California,并且收到的某本书的版税低于30%的第二作者的姓名,与之返回结果相等的SQL语句是( )。 SELECT au_lname, au_fname FROM authors WHERE state=’CA’ AND au_id IN (SELECT au_id FROM titleauthor...
A.
SELECT au_lname, au_fname FROM authors INNER JOIN titleauthor ON authors.au_id= titleauthor.au_id WHERE state=’CA’ AND royaltyper<30 AND au_ord=2
B.
SELECT au_lname, au_fname FROM authors UNION titleauthor ON authors.au_id= titleauthor.au_id WHERE state=’CA’ AND royaltyper<30 AND au_ord=2
C.
SELECT au_lname, au_fname FROM authors OUTTER JOIN titleauthor ON authors.au_id= titleauthor.au_id WHERE state=’CA’ AND royaltyper<30 AND au_ord=2
D.
SELECT au_lname, au_fname FROM authors CROSS JOIN titleauthor ON authors.au_id= titleauthor.au_id WHERE state=’CA’ AND royaltyper<30 AND au_ord=2
【单选题】The English, as a race, are very different from all other nationalities, including their closest neighbors, the French, Belgians and Dutch. It is claimed that living on an island separated from the re...