PreviousNext
Coding/SQL

Signed up, viewed, purchased

SQLHard14 minMeta style

Your task

Return one row with the funnel counts: signed_up, viewed and purchased, each counting DISTINCT users who did that thing at least once.

Tables

app_user
idINTEGERnameTEXTplanTEXTjoined_onTEXT
1Arifree2026-01-02
2Beapro2026-01-02
3Caifree2026-01-15
4Dotpro2026-02-01
5Elifree2026-02-20
event
idINTEGERuser_idINTEGERnameTEXToccurred_onTEXTsession_idTEXT
11signup2026-01-02s1
21view2026-01-02s1
31view2026-01-03s2
42signup2026-01-02s3
52view2026-01-02s3
62purchase2026-01-02s3
More rows not shown