Top Identified Event Types

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

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

Find the top 3 event types by total records, but only those where identified (non-null user_id) events outnumber anonymous (null user_id) events. Rank by total events, most frequent first. Return the event type and total event count.

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.