SQL JSON Input | Extracting columns from JSON formatted data | JSON_VALUE | SQL Problem Solving

In this SQL problem solving session, we work out to extract the columns from JSON formatted data using JSON_VALUE function. Table creation & insertion script: CREATE TABLE user_det_json( details VARCHAR(1000) ); INSERT INTO user_det_json VALUES(&Ahuja","address":{"state_info":{"name":"Maharashtra","short":"MH"},"city":"Pune"}}'), (&Deshmukh","address":{"state_info":{"name":"Gujarat","short":"GJ"},"city":"Surat"}}'), (&Taneja","address":{"state_info":{"name":"Tamil Nadu","short":"TN"},"city":"Madurai"}}'); #problemsolving