Question 1mediummultiple choice
Read the full Performance Optimization, Querying, and Transformation explanation →Refer to the exhibit. Which SQL snippet correctly extracts the 'total' value of the second order in the JSON object stored in a column named 'src'?
Exhibit
{
"customer": "Acme Corp",
"orders": [
{"id": "O1", "total": 100},
{"id": "O2", "total": 250}
]
}