【单选题】下面的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
【简答题】Why does the author assert that all things American are fascinating to foreigners? A) Because they have gained much publicity through the American media. B) Because they represent the world’s latest f...