← All practice problems

Ordered page_view → checkout funnel

senior · sql🔒Walkthroughs

NEW

Ordered page_view → checkout funnel

Build a two-step funnel from the events table: page_view → checkout.

The funnel is ordered — a user only counts as converted if their checkout happens *strictly after* their FIRST page_view. A user who checks out with no prior page_view does not count toward either step.

Return one row per step: - step — 'page_view' then 'checkout' - users — distinct users who reached that step (ordered) - pct_of_entry — users at this step as a percent of the top-of-funnel step, rounded to 1 decimal (the entry step is 100.0)

Sort by funnel order (page_view first).

Tables & sample data

events

Loading preview…

query.sql

Loading…

Loading editor…