Filter Rows by a JSON Attribute

Return the ids of events whose payload has plan equal to 'pro'.

Table schema

Events(id INT PRIMARY KEY, payload JSON)

Sample data

id | payload
1 | {"user": "amit", "plan": "pro"}
2 | {"user": "riya", "plan": "free"}