单项选择题

A.SELECT *FROM CUSTOMER WHERE PRICE MORE THAN 500
B.SELECT *FROM CUSTOMER WHERE PRICE BETWEEN 500AND 
C.SELECT *FROM CUSTOMER WHERE PRICE LIKE ’%500%’
D.SELECT *FROM CUSTOMER WHERE PRICE>=500