Purchases over 500 from a JSON amount

Return event_id and amount (as an integer) for purchase events whose payload amount is greater than 500. 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…