user_txn +---------+-------------+------------+---------------+------------------+---------------------+ | user_id | user_region | adopted_at | transacted_at | transacted_region | timestamp | +---------+-------------+------------+---------------+------------------+---------------------+ | 101 | US | 2023-01-05 | 2023-01-10 | US | 2023-01-10 09:00 | | 101 | US | 2023-01-05 | 2023-02-01 | CA | 2023-02-01 12:30 | | 202 | CA | 2023-01-07 | 2023-01-20 | CA | 2023-01-20 14:00 | | 303 | UK | 2023-01-08 | NULL | NULL | NULL | | 404 | US | 2023-01-09 | 2023-03-01 | UK | 2023-03-01 16:45 | +---------+-------------+------------+---------------+------------------+---------------------+ ##### Scenario A user_txn table records user adoption dates and subsequent transactions across regions; the business wants adoption/transaction KPIs and insights on cross-region behavior. ##### Question Compute overall adoption_rate (users with adopted_at) and transaction_rate (users with at least one transaction) for a given date range. For each adopted user, calculate the time in days from adoption to their first transaction. Identify cross-region sales: transactions where transacted_region differs from the region of the user’s first transaction, and list those transactions. ##### Hints Use conditional aggregation for rates, MIN() OVER or subqueries for first transaction, and compare regions in a CTE.