SQL Quest › SQL Interview Questions › String Functions
Country Codes in Uppercase
An export report needs country names in uppercase to match the shipping system's expected format. Show order_id, product, and UPPER(country) AS country_code.
Order by order_id. Limit to the first 10 rows.
UPPER() and LOWER() are the workhorses of case normalization. You'll use them when joining or comparing strings that came from different sources with inconsistent casing — WHERE LOWER(email) = LOWER(?) is one of the most common patterns in production SQL.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".
Schema
orders
| order_id | customer_id | product | category | quantity | price | total | order_date | country | status |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Laptop Pro | Electronics | 1 | 1299.99 | 1299.99 | 2024-01-15 | USA | completed |
| 2 | 2 | Wireless Mouse | Electronics | 2 | 49.99 | 99.98 | 2024-01-16 | Canada | completed |
| 3 | 3 | Office Chair | Furniture | 1 | 349.99 | 349.99 | 2024-01-17 | USA | completed |
Expected output: country_code = 'USA'
Hint
SELECT, String Functions, UPPER, and open the hint there if you stall.Concepts
SELECT String Functions UPPER
Practise the topic: SQL practice questions · String function practice
In these company practice sets
A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.
Related questions
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test