Question: You are importing data as JSON into a new table. You run CREATE TABLE json_data ( city JSON ); and insert rows into this table. What is the correct syntax to see the list of cities?

1. `SELECT city FROM json_data;`
2. `SELECT city->>'$.name' city FROM json_data;`
3. `SELECT city.name city FROM json_data;`
4. `SELECT city->'$.name' city FROM json_data;`

Answer: The correct answer of the above question is Option B:`SELECT city->>'$.name' city FROM json_data;`