Database: department_store
Question: What are the names and ids of products costing between 600 and 700?
SQL:
SELECT product_name ,  product_id FROM products WHERE product_price BETWEEN 600 AND 700