Which plan each purchase was for

Each row in app_events has a JSON payload. For purchase events, the payload has a plan key, e.g. {"plan":"pro","amount":900}.

Return event_id, user_id, and plan (as plain text, without quotes) for purchase events. Sort by event_id.

Tables & sample data

app_events

6 rows total · first 5 shown

event_idvarchar	user_idvarchar	event_typevarchar	payloadvarchar
ev_1	u_1	purchase	{"plan":"pro","amount":900,"coupon":null}
ev_2	u_2	purchase	{"plan":"team","amount":1000,"coupon":"SPRING"}
ev_3	u_3	purchase	{"plan":"pro","amount":120,"device":{"os":"ios"}}
ev_4	u_1	signup	{"source":"ads","device":{"os":"android"}}
ev_5	u_4	purchase	{"plan":"basic","amount":90}

query.sql

Loading editor…