Filling missing values using COALESCE()

In the previous exercise, you used the ISNULL() function to replace the NULL values of a column with another value.

Now, you want to create a new column, location, that returns the values of the airport_city column, and in case it has NULL values, return the value of airport_state. Finally, if airport_state is also NULL, you want to return the string 'Unknown'.

To do it, you can use COALESCE(), that evaluates the arguments between parenthesis and returns the first argument that is not NULL.

Bu egzersiz

Cleaning Data in SQL Server Databases

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Use COALESCE() to return the first non NULL value of airport_city, airport_state, or 'Unknown'.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT
airport_code,
airport_name,
-- Replace the missing values
___(___, ___, '___') AS location
FROM airports

Kodu Düzenle ve Çalıştır