Scenario SQL Question
Comprehensive Data Quality Scorecard
Build mastery in Finding Duplicates with this scenario-based SQL challenge and live execution support.
Problem Statement
Write a query to create a data quality scorecard showing: NULL count, duplicate email count, and overall data quality percentage. Use multiple CTEs to calculate metrics.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: