Electronics or Books
Easysql
Write a query returning id, name, category for every product in either the 'Electronics' or 'Books' category, 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 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;