Redshift - 用于从键值对中提取值的SQL脚本

I have a columns containing JSON data as below. I am trying to extract values corresponding to each key pair in the column. Could anyone advice how could I do using SQLI have a columns containing JSON data as below.