从产品表Products中查询单价UnitPrice在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 IN(6,10) D. SELECT Name, UnitPrice FROM Products WHERE UnitPrice>=6 AND UnitPrice<=10