![](https://cos-cdn.shuashuati.com/pipixue-web/2020-1231-2005-12/ti_inject-812ce.png)
已知 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 > ANY ( SELECT price FROM Titles WHERE Pub_id= ‘ 0736 ’)
C.
SELECT Title_Id , Title FROM Titles WHERE price > ALL ( SELECT price FROM Titles WHERE Pub_id= ‘ 0736 ’)
D.
SELECT Title_Id , Title FROM Titles WHERE price > ANY ( SELECT price FROM Titles ) AND Pub_id= ‘ 0736 ’