Write SQL and pandas for shopping events

You are given four fixed tables: users(user_id, country), pins(pin_id, creator_user_id, is_shopping_enabled, created_at), events(event_id, user_id, pin_id, event_type, event_ts, stay_time_sec, feature, product_category_code), and product_categories(code, name). Treat the current date as the literal 2025-09-01. Nothing may be passed in as a bind parameter. Every date, offset and window bound mentioned below is a hard-coded literal, and the column lists given for each task are…