Stock With a Default

Easysql

Some products have a NULL stock (never counted). Write a query returning id, name, and a stock column that shows 0 instead of NULL when stock hasn't been counted, 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	stock
1	ProLaptop	12
2	Notebook	0
3	Python Basics	5
4	ProPhone	0
5	Novel	0
6	Desk Lamp	8

COALESCE returns the first non-NULL argument. Reference: SELECT id, name, COALESCE(stock, 0) AS stock FROM products ORDER BY id;

Stock With a Default

Related Problems

Input (stdin)

Output