Usage Funnels with Warby Parker


I have a problem with running the code on problem no. 5:

Each row will represent a single user from the browse table:

  • If the user has any entries in home_try_on , then is_home_try_on will be True .
  • number_of_pairs comes from home_try_on table
  • If the user has any entries in purchase , then is_purchase will be True .

Use a LEFT JOIN to combine the three tables, starting with the top of the funnel (quiz) and ending with the bottom of the funnel (purchase).

Select only the first 10 rows from this table (otherwise, the query will run really slowly).


I tried to do it with the hint solving also, but when i try to run it, the query results stays empty. Please help!

Hi, welcome to the forums!

Can you please paste your formatted code?