Mid-Range Prices
Easysql
Write a query returning id, name, price for every product priced between 200 and 1000 (inclusive), ordered by id.
sqlCREATE TABLE products ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, category TEXT NOT NULL, price INTEGER NOT NULL, stock INTEGER );
Sample data:
sqlINSERT INTO products (id, name, category, price, stock) VALUES (1, 'ProLaptop', 'Electronics', 85000, 12), (2, 'Notebook', 'Stationery', 40, NULL), (3, 'Python Basics', 'Books', 350, 5), (4, 'ProPhone', 'Electronics', 45000, 0), (5, 'Novel', 'Books', 220, NULL), (6, 'Desk Lamp', 'Home', 900, 8);
Example 1
Input
(none)
Output
id name price 3 Python Basics 350 5 Novel 220 6 Desk Lamp 900
BETWEEN is inclusive of both endpoints. Reference: SELECT id, name, price FROM products WHERE price BETWEEN 200 AND 1000 ORDER BY id;