Build Tags with String Functions

easy
Unit 5 · Dates & Set Operations0/3 to milestone

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