Electronics or Books

Easysql

Write a query returning id, name, category for every product in either the 'Electronics' or 'Books' category, 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	category
1	ProLaptop	Electronics
3	Python Basics	Books
4	ProPhone	Electronics
5	Novel	Books

IN checks membership against a list, avoiding repeated OR-equality checks. Reference: SELECT id, name, category FROM products WHERE category IN ('Electronics', 'Books') ORDER BY id;

Electronics or Books

Related Problems

Input (stdin)

Output