已知Titles(Title_Id char(4), Title char(20), Pub_id char(4), price integer),其中Title_Id图书编号,Title图书名,Pub_id出版商编号,price价格。列出Titles表中其价格高于出版商ID为0736的出版商出版的书的最大价格的书的标题和ID,合适的查询语句是_________。
A.
SELECT Title_Id , Title FROM Titles WHERE price > ALL ( SELECT price FROM Titles ) AND Pub_id= ‘ 0736 ’
B.
SELECT Title_Id , Title FROM Titles WHERE price > ALL ( SELECT price FROM Titles WHERE Pub_id= ‘ 0736 ’)
C.
SELECT Title_Id , Title FROM Titles WHERE price > ANY ( SELECT price FROM Titles ) AND Pub_id= ‘ 0736 ’
D.
SELECT Title_Id , Title FROM Titles WHERE price > ANY ( SELECT price FROM Titles WHERE Pub_id= ‘ 0736 ’)