Scenario SQL Question

Find Data Quality Issues Across Multiple Columns

Build mastery in Finding Duplicates with this scenario-based SQL challenge and live execution support.

Problem Statement

For each employee with at least one quality issue, count how many of {salary, department_id, manager_id} are NULL. Return employee_id, first_name, last_name, quality_issues — ordered by quality_issues DESC, employee_id ascending.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics:

GROUP BY FundamentalsAggregate Functions & Grouping
HAVING ClauseAggregate Functions & Grouping
DISTINCT & Removing DuplicatesSQL Fundamentals