Skip to main content
All Problems
easy0% acceptance

Uppercase Product Names

The export team needs product names in uppercase for a data feed. Write a query that returns the product id, the original name, and the name converted to uppercase (as upper_name). Also include the length of each product name (as name_length). Sort by name_length descending.

Schema

🔑idINT
nameTEXT
🔗category_idINT
priceREAL
costREAL
stock_quantityINT
created_atTIMESTAMP
postgresql

Run your query to see results

Press Ctrl + Enter to execute