Names in capitals
Easy
Show each product name in capital letters, in a column called shout.
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
| shout |
|---|
| WIRELESS MOUSE |
| MECHANICAL KEYBOARD |
| USB-C HUB |
| 27-INCH MONITOR |
| NOISE-CANCELLING HEADPHONES |
| PYTHON CRASH COURSE (BOOK) |
| DEEP LEARNING (BOOK) |
| SQL POCKET GUIDE |
| STANDING DESK |
| ERGONOMIC CHAIR |
| DESK LAMP |
| COFFEE BEANS 1 KG |
| GREEN TEA, 100 BAGS |
| A5 NOTEBOOK |
| GEL PENS, PACK OF 10 |
15 rows
Show a solution
SELECT UPPER(name) AS shout FROM products;
SQL used
New to SQL? The free SQL course teaches everything these problems use, with a self-checking exercise in every lesson.