Json query

[call-stack]

I want to get a value of key which is JSON. May I know how I can achieve it?

Let say we have a column name payload containing json values. And one record contains values '{"country":"Peru"}' and another record contains '{"country":"India"}'. How can I get the list of all countries? ex : [Peru, India]

Thanks