【单选题】
A SELECT shirt_id，shirt_name，shirt_price FROM SHIRTABLE WHERE shirt_price > AVG(shirt_price)
B SELECT shirt_id，shirt_name，shirt_price FROM SHIRTABLE WHERE shirt_price > (SELECT AVG(shirt_price) FROM SHIRTABLE)
C SELECT shirt_id，shirt_name，shirt_price FROM SHIRTABLE HAVING shirt_price > AVG(shirt_price)
D SELECT shirt_id，shirt_name，shirt_price FROM SHIRTABLE WHERE shirt_price > (SELECT AVG(shirt_price) FROM SHIRTABLE WHERE shirt_price > AVG(shirt_price))
查看更多
