hardMeta Amazon Airbnb

Write SQL for a multi-step funnel: what fraction of users complete each step, in order?

Funnels look like simple counts until you require the steps happen in order and within a window. Counting each step independently overstates conversion. Here is the ordered-funnel query.

Updated Aug 2026 · Grounded in real Applied AI Engineer interview loops and written to a senior-engineer editorial bar.

Funnels look like simple counts until you require the steps happen in order and within a window. Counting each step independently overstates conversion. Here is the ordered-funnel query.

Unlock the other 750 answers · ₹2,000 / $25Your progress and mastery stay saved · 6 months · one payment · no auto-renew

UP NEXT ON YOUR JOURNEY

Next in this trackFind each user's longest streak of consecutive active days in SQL (gaps and islands).Next in this trackDo vector similarity search inside SQL (pgvector / warehouse). When is this the right call?Next in this trackPull a random sample, and a stratified sample, for an ML training set in SQL.

DISCUSSION · 0

No comments yet — be the first to share your approach.