Home / SQL / Practice problems / Easy

List all products

Easy

Show the name, category and price of every product.

Tables: customers(customer_id, name, city, country, joined) · products(product_id, name, category, price) · orders(order_id, customer_id, order_date, status) · order_items(order_id, product_id, quantity, unit_price)

Your query
Show the expected result
namecategoryprice
Wireless mouseElectronics29.0
Mechanical keyboardElectronics119.0
USB-C hubElectronics49.0
27-inch monitorElectronics329.0
Noise-cancelling headphonesElectronics249.0
Python Crash Course (book)Books45.0
Deep Learning (book)Books89.0
SQL Pocket GuideBooks25.0
Standing deskFurniture549.0
Ergonomic chairFurniture399.0
Desk lampFurniture59.0
Coffee beans 1 kgGrocery32.0
Green tea, 100 bagsGrocery12.0
A5 notebookStationery8.5
Gel pens, pack of 10Stationery11.0

15 rows

Show a solution
SELECT name, category, price FROM products;

SQL used

New to SQL? The free SQL course teaches everything these problems use, with a self-checking exercise in every lesson.