SQL · Google · Hard
You are working with three PostgreSQL relations describing an app's users, their activity, and identity merges: user_profile(user_id, signup_ts, country, is_employee, is_test) user_events(user_id, event_ts, event_type, revenue, platform) user_merges(child_user_id, parent_user_id, merged_ts) Write a single PostgreSQL query that produces monthly cohort retention for the three signup cohorts of 2025-01, 2025-02 and 2025-03, for offsets $$k = 0, 1, 2, 3$$, where offset $$k$$…
Checking your access…