SQL · Coinbase · Hard
You are given two relational tables for a product-analytics task: A single users row may be linked to zero, one, or many transactions rows through user_id. All timestamps use the format YYYY-MM-DD HH24:MI:SS. Part A — Regional monthly rates For every user_region, compute two decimal ratios for the inclusive window 2025-08-01 00:00:00 through 2025-08-31 23:59:59: $$\text{adoption\_rate} = \frac{\#\{\text{users in that region whose } adopted\_at \text{ lies in August…
Checking your access…