Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Challenge: Standardize Customer Names | String Functions
Functions in SQL

bookChallenge: Standardize Customer Names

Task

Swipe to start coding

Write a query to display each customer name in uppercase along with the length of that name.

  • Select all customer names from the customers table.
  • Convert each name to uppercase.
  • Calculate the length of each name.
  • Return both the uppercase name and its length.

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 2
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

close

bookChallenge: Standardize Customer Names

Swipe to show menu

Task

Swipe to start coding

Write a query to display each customer name in uppercase along with the length of that name.

  • Select all customer names from the customers table.
  • Convert each name to uppercase.
  • Calculate the length of each name.
  • Return both the uppercase name and its length.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 2
single

single

some-alt