Average DQ Fail Rate

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

Several downstream consumers are complaining about bad data but nobody knows which source tables are the worst offenders. Compute the average data quality check fail rate per table, but only surface tables where more than one validation rule has actually been evaluated. Show the table name and its average fail percentage.

Summary

Average failure rate, table by table.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.