在客户定单表(CUSTOMER)中有一列为单价(PRICE),写一个SELECT命令显示所有单价在500以上的查询语句,正确的是()
A. SELECT * FROM CUSTOMER WHERE PRICE LIKE %500%
B. SELECT * FROM CUSTOMER WHERE PRICE BETWEEN 500 AND *
C. SELECT * FROM CUSTOMER WHERE PRICE>500
D. SELECT * FROM CUSTOMER WHERE PRICE>=500