Removing missing values
It is common to find missing values in your data. SQL Server represents missing values with NULL
.
IS NULL
and IS NOT NULL
enable you to select or remove the rows where missing values are represented by NULL
.
The airport_city
column of the airports
table has some NULL
values. Try to find them!
This exercise is part of the course
Cleaning Data in SQL Server Databases
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT *
-- Select the appropriate table
FROM ___
-- Exclude the rows where airport_city is NULL
WHERE ___ ___ ___ ___