Where Quality Breaks

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

Data quality checks only record a fail percentage when they flag a problem, so a check that flagged one always has a recorded rate. For each source table, take just those flagged checks and report how many there were, how many different rules they involved, and their average fail rate, then keep only the tables averaging above 30 percent.

Summary

Which tables the checks keep flagging.

Practice This Problem

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