从产品表Products中查询单价UnitPrice在6~10的产品名称和单价信息,正确的SQL有()
A.
SELECT Name, UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
B.
SELECT Name, UnitPrice FROM Products WHERE UnitPrice BETWEEN IN(6,10)
C.
SELECT Name, UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10< /div>