SQL Practice Logo

SQLPractice Online

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

Write a query to find employees where either email OR salary is NULL. Return employee_id, first_name, last_name, email, and salary.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: