Error Rate by Region

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

Domain

SQL

Difficulty

medium

Seniority

staff

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.

Practice This Problem

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