Extract a JSON Field

Return each event's id and the user name stored in its JSON payload. Order by id.

Table schema

Events(id INT PRIMARY KEY, payload JSON)

Sample data

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