SQL A/B testing question: Q: You are tasked to analyze an experiment called thanksgiving-coupon. Instacart users in this experiment are randomly assigned to “incentive” group or “nonincentive” group. Users in the “incentives” group get an email with $10 off for their next order, and users in the “no incentives” group get an email reminding them to stock up groceries for the Thanksgiving weekend. The $10 off coupon expires on 11/29/2020 (Sunday) 11:59pm PST. How would you analyze this experiment? You have the table Experiments, which contains experiment assignments for Instacart users. Fields: user_id experiment: experiment name group_ind: experiment group a user is assigned to assigned_at_utc: assignment timestamp. You also have the Orders table, which contains all orders from a user. Fields: user_id order_id order_created_timestamp_utc order_amount_usd You can use this code to convert time zones: order_created_timestamp_utc at time zone 'utc' at time zone 'pst' You also have the Coupon_spend table, which contains the redeemed thanksgiving-coupon for an order. Fields: user_id order_id coupon_spend
