SELECT product_name ,  product_id FROM products WHERE product_price BETWEEN 600 AND 700
Return the names and ids of all products whose price is between 600 and 700.
SELECT product_name , product_id FROM products WHERE product_price BETWEEN 600 AND 700
select product_name , product_id from products where product_price between value and value
Return the names and ids of all products whose price is between 600 and 700 .