You are given a table with the following information: ID json 1 {"name":"s1", "msg":"QA"} {"name":"s2", "msg" :"MD"} 3 {"name":"s3", "msg" :"MD"} 4 {"name":"s4", "msg" :"QD} Write a SQL script that...

DO NOT COPY FROM OTHER WEBSITES

Correct and detailed answer will be Upvoted else downvoted. Thank you!

Extracted text: You are given a table with the following information: ID json 1 {"name":"s1", "msg":"QA"} {"name":"s2", "msg" :"MD"} 3 {"name":"s3", "msg" :"MD"} 4 {"name":"s4", "msg" :"QD} Write a SQL script that will pull what comes after name, and after message.