Please watch the following videos before you start your homework.

Dynamic Web Sites Using JSON $($Bellevue University, $2023).$

OPENJSON and JSON PATH $($Bellevue University, $2023).$

Then, answer the following problems:

Use the OPENJSON function to translate the following JSON object to a relational format and then insert the translated JSON into a table called JSON$\_$CUSTOMER

DECLARE @json NVARCHAR$($MAX$)$;

SET @json $=$ N$\text{'}[\{"$id$"$: $2,$ "info": $\{"$name$"$: "John", "surname": "Smith"$\},$ "age": $25\},$

$\{"$id$"$: $5,$ "info": $\{"$name$"$: "Jane", "surname": "Smith"$\},$ "dob": $"2005-11-04$T$12$:$00$:$00"\}$

$]\text{'}$;

Use JSON PATH to translate the rows and columns in the JSON$\_$CUSTOMER table back to JSON format.