help me.送分 again&again&again&again

[trouble]

Which SELECT statement dispaly the ORDERID, PRODID and Quantity

of items in the
ITEM table that match both the product ID and Quantilty of item

in order 605?
(don't display the details for 605)
A. SELECT ordid, prodid, quantity
FROM item
WHERE (prodid, quantity) = (SELECT prodid, quantity
FROM item
WHERE ordid=605)
AND ordid<>605;

B. SELECT ordid, prodid, quantity
FROM item
WHERE (prodid, quantity)IN (SELECT prodid, quantity
FROM item
WHERE ordid=605)
AND ordid<>605;

c. SELECT ordid, prodid, quantity
FROM item
WHERE (prodid, quantity)=(SELECT prodid, quantity
FROM item
WHERE ordid=605)
AND ordid=605;

[昵称被占用了]

b