Query and transform marketplace data in SQL/Python

This exercise is set in a marketplace-analytics setting, and every timestamp is to be interpreted in UTC. Three relations are available; the orders relation may hold more than one row for a given order_id, since each status transition is written as its own record. Schema events(event_time TIMESTAMP, user_id INT, event_type ENUM(impression, click, add_to_cart, purchase), city STRING, session_id STRING) orders(order_id INT, user_id INT, created_at TIMESTAMP, status…