Build Tags with String Functions

easy
Checkpoint challenge
Solve this to show you know the material and jump straight to Unit 6. Everything before it counts as cleared.

Build a tag for each customer: their name and country, both lowercase, joined by a hyphen ('Ada', 'UK' → 'ada-uk'). Return name, tag and name_length (the number of characters in the name). Sort by name_length descending, then name.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#strings#functions1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Build Tags with String Functions · TechGradify