codejump
EasySQL

List Unique Product Categories

SQLDatabases

Write a SQL query that returns the distinct categories found in the
products table, sorted alphabetically.

Table: `products`

idnamepricecategory
1Laptop999Electronics
2Wireless Mouse29Electronics
3Standing Desk349Furniture
4Office Chair199Furniture
5Notebook5Stationery
6Pen Set8Stationery
7Headphones79Electronics

Expected output (column: category)

Electronics
Furniture
Stationery

Use SELECT DISTINCT to eliminate duplicate category values.

Sample tests

Test #17 products across 3 distinct categories
Input: "CREATE TABLE products (id INTEGER, name TEXT, price INTEGER, category TEXT);\nINSERT INTO products VALUES\n (1, 'Laptop', 999, 'Electronics'),\n (2, 'Wireless Mouse', 29, 'Electronics'),\n (3, 'Standing Desk', 349, 'Furniture'),\n (4, 'Office Chair', 199, 'Furniture'),\n (5, 'Notebook', 5, 'Stationery'),\n (6, 'Pen Set', 8, 'Stationery'),\n (7, 'Headphones', 79, 'Electronics');"
Output: "Electronics\nFurniture\nStationery"
← All challenges