Uppercase Names and Lengths
Easysql
Write a query returning id, an uppercase version of customer_name as name_upper, and the number of characters in customer_name as name_length, ordered by id.
sqlCREATE TABLE orders ( id INTEGER PRIMARY KEY, customer_name TEXT NOT NULL, amount INTEGER NOT NULL, order_date DATE NOT NULL );
Sample data:
sqlINSERT INTO orders (id, customer_name, amount, order_date) VALUES (1, 'Asha', 500, '2026-03-05'), (2, 'Rohan', 300, '2026-03-20'), (3, 'Neha', 700, '2026-04-02'), (4, 'Asha', 200, '2026-03-28');
Example 1
Input
(none)
Output
id name_upper name_length 1 ASHA 4 2 ROHAN 5 3 NEHA 4 4 ASHA 4
UPPER() and LENGTH() are standard string functions available in every mainstream dialect. Reference: SELECT id, UPPER(customer_name) AS name_upper, LENGTH(customer_name) AS name_length FROM orders ORDER BY id;