Scenario SQL Question
Find Records Missing Critical Data (Multiple NULL Checks)
Build mastery in Finding Duplicates with this scenario-based SQL challenge and live execution support.
Problem Statement
Find every employee where EITHER email OR salary is NULL. Return employee_id, first_name, last_name, email, salary, ordered by employee_id ascending.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: