SQL practice: Text Functions
Chapter 19 · 9 questions · included in full access
Question 1 · easy
Solve it in your browserShow each customer's name in capitals with their city in lowercase.
Question 2 · easy
Solve it in your browserShow a single column reading name - city for every customer.
Question 3 · medium
Solve it in your browserShow each product name with its length in characters.
Question 4 · medium
Solve it in your browserShow the first 3 characters of every city name in branches.
Question 5 · medium
Solve it in your browserFind customers whose name is longer than 18 characters.
Question 6 · medium
Solve it in your browserShow every branch name with the word 'Branch' replaced by 'Office'.
Question 7 · medium
Solve it in your browserShow each customer as Shree Interiors (Delhi) — name, space, city in brackets.
Question 8 · hard
Solve it in your browserFind customers whose name contains 'facade' regardless of capitalisation.
Question 9 · hard
Solve it in your browserShow each product with a spec line like 'ACP Sheet, 4.0 mm'. Products with no thickness should show just their category, but they come out NULL. Fix it.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing