Solution Review: JSON Data Type

In the challenge, you were asked to perform three tasks. Here, we’re going to discuss the solution to these three tasks.

Task 1

You were asked to create a cars table and insert data into it.

Solution

The DDL for creating the table and inserting records in the table is given below. You can check the data using the SELECT query given in the following playground. Click the “Run” button in the following widget to see the output of the code.