The Failure Report

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

Domain

SQL

Difficulty

medium

Seniority

L6

Problem

Each event in event_data has a type such as open, error, or crash. Enrich the event_data table with the users table to get each user's age_bucket as a proxy for region. Then compute the ratio of error events (types error and crash) to total open events, broken down by day and region.

Summary

Errors by day and region. Some areas are worse than they appear.

Practice This Problem

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