The Shape of a User

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

Domain

SQL

Difficulty

medium

Seniority

L6

Problem

Our product analytics team wants a per-user funnel snapshot pulled from the raw event log. Produce one row per user, with separate columns counting that user's search, add_to_cart, and purchase events.

Summary

Every user leaves a trail of events. The report needs them lined up side by side.

Practice This Problem

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