Mid-Range Prices

Easysql

Write a query returning id, name, price for every product priced between 200 and 1000 (inclusive), ordered by id.

sql
CREATE TABLE products (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  category TEXT NOT NULL,
  price INTEGER NOT NULL,
  stock INTEGER
);

Sample data:

sql
INSERT 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;

Mid-Range Prices

Related Problems

Input (stdin)

Output