By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
CREATE TABLE
INSERT 0 3
INSERT 0 5
| json_build_object |
|---|
| {"companyName" : "Nissan", "country" : "Japan", "cars" : { "Qashqai" : "SUV" }} |
| {"companyName" : "Volkswagen", "country" : "Germany", "cars" : { "Tiguan" : "SUV", "Golf" : "Hatchback" }} |
| {"companyName" : "Toyota", "country" : "Japan", "cars" : { "Corolla" : "Sedan", "Camry" : "Sedan" }} |
SELECT 3