Given a table of user_activity with user_id, activity_date, and activity_type, write a query that returns users whose first three activities were all of type 'view' rather than 'purchase' or 'click'.

Question

Answer

Stay specific. One example, told well, beats three told fast. Make your decisions visible — what you chose between. End on what changed, for whom.

Given a table of user_activity with user_id, activity_date, and activity_type, write a query that returns users whose first three activities were all of type 'view' rather than 'purchase' or 'click'.

Practice more