Ultimate access to all questions.
The following JSON is stored in a VARIANT column called src
in the CAR_SALES
table:
{
"dealership": "Friendly Automotive",
"location": {
"city": "Toronto",
"country": "Canada"
},
"sales": [
{"make": "Honda", "model": "Civic", "year": 2022},
{"make": "Toyota", "model": "Camry", "year": 2021}
]
}
A user needs to extract the dealership information from the JSON.
How can this be accomplished?