Challenge: Understanding Nulls

Try a hands-on exercise to test your knowledge and understanding of NULLs.

Problem statement

In this challenge, you will complete two tasks to test your knowledge and understanding of null in SQL.

Task 1

Programming languages come with a special value for null values. SQL deals with such values differently than other languages because it provides a three-valued logic for nulls. Let’s check the behavior of null with the values true, false, and null.

Write a query to list the output using the SQL operator is null for the values true, false, and null.

Get hands-on with 1200+ tech skills courses.