Names Starting with Pro

Easysql

Write a query returning id, name for every product whose name starts with 'Pro', 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
1	ProLaptop
4	ProPhone

A trailing % wildcard matches any suffix after the fixed prefix. Reference: SELECT id, name FROM products WHERE name LIKE 'Pro%' ORDER BY id;

Names Starting with Pro

Related Problems

Input (stdin)

Output