Customer Initials and Name Lengths

easy
Unit 6 · Window Functions I0/3 to milestone

Return each customer's name, initial (first letter, upper case), name_length and label: the country code in lower case, a hyphen and the name in upper case (e.g. uk-ADA). Sort by name.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#strings1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Customer Initials and Name Lengths · TechGradify