从产品表Products中查询单价UnitPrice在6~10(含6、10)的产品名称和单价信息,正确的SQL为()
A、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
D、SELECT Name,UnitPrice FROM Products WHERE UnitPrice>6 AND UnitPrice <10<br>