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✔ Solved
Show the expected result
| name | category | price |
|---|---|---|
| Wireless mouse | Electronics | 29.0 |
| Mechanical keyboard | Electronics | 119.0 |
| USB-C hub | Electronics | 49.0 |
| 27-inch monitor | Electronics | 329.0 |
| Noise-cancelling headphones | Electronics | 249.0 |
| Python Crash Course (book) | Books | 45.0 |
| Deep Learning (book) | Books | 89.0 |
| SQL Pocket Guide | Books | 25.0 |
| Standing desk | Furniture | 549.0 |
| Ergonomic chair | Furniture | 399.0 |
| Desk lamp | Furniture | 59.0 |
| Coffee beans 1 kg | Grocery | 32.0 |
| Green tea, 100 bags | Grocery | 12.0 |
| A5 notebook | Stationery | 8.5 |
| Gel pens, pack of 10 | Stationery | 11.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.