SELECT product_name ,  product_id FROM products WHERE product_price BETWEEN 600 AND 700
What are the names and ids of products costing 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
What are the names and ids of products costing between 600 and 700 ?