Concatenating cities and states
In the previous exercise, you used the + operator to combine two columns into one. This time you need to do the same, but using the CONCAT() function.
To get this format for the concatenation: 'Las Vegas, Nevada', you will need to use the CASE expression in case the state column has NULL values.
Questo esercizio fa parte del corso
Cleaning Data in SQL Server Databases
Istruzioni dell'esercizio
- Concatenate the names of the cities with the states using the
CONCAT()function, while using aCASEstatement that returns''whenstateisNULLand performs a normal concatenation otherwise.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT
client_name,
client_surname,
-- Use the function to concatenate the city and the state
___(
___,
CASE WHEN state IS NULL THEN ''
ELSE ___(', ', ___) END) AS city_state
FROM clients