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

L4

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.

Summary

The top users by events, but only the identifiable ones.

Practice This Problem

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