#0122

Signup to Purchase Funnel

MediumSQL25 min20 XP

Problem

Given events(user_id, event_name), return one row with signups and purchases counting distinct users for each event_name.

Funnels are one of the most common product analytics SQL tasks.

events(user_id INTEGER, event_name TEXT)

Example 1

Inputusers with signup and purchase events

Outputsignups and purchases counts

Distinct user counts avoid double-counting repeated events.

CodeSQL

SELECT
  -- write your code here
  0 AS signups,
  0 AS purchases;

SELECT
  -- write your code here
  0 AS signups,
  0 AS purchases;

Visible browser tests run here when available.

Testcases1 visible / 3 hidden categories

Core example

Inputusers with signup and purchase events

Expectedsignups and purchases counts

Distinct user counts avoid double-counting repeated events.

Hidden Test Categories

repeat signupsno purchasesusers with purchase but no signup