从货物定单数据表（order）中查询出其中定单金额（order_price）在1000和5000之间的定单的详细信息，并按照定单金额（order_price）升序排列。正确的语句是（）。

A.Select *from order where order_price between 1000 and 5000order by order_price ASC
B.Select *from order where order_price between 1000 and 5000order by order_price DESC
C.Select *from order where 1000<order_price<5000order by order_price ASC
D.Select *from order where 1000<order_price<5000order by order_price DESC