Postgres 9.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

--PostgreSQL 9.6
--'\\' is a delimiter
create table example (
   ID Serial CONSTRAINT pk_id_cars PRIMARY KEY,
     jsonTest jsonb NOT NULL, 
 create_at date
    
    );
insert into example( jsonTest,create_at) values 
('{"vehicle":[{"vehicle_type":"Van","car_make":"Suzuki","car_model":"XL-7","quantity":9,"seats":3,"price_hour":49,"price_day":187,"color":["White","Orange","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Dodge","car_model":"Caravan","quantity":7,"seats":8,"price_hour":37,"price_day":232,"color":["Pink","White","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"GMC","car_model":"Yukon XL 2500","quantity":5,"seats":2,"price_hour":37,"price_day":211,"color":["Silver","Pink","Indigo","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mazda","car_model":"Millenia","quantity":8,"seats":8,"price_hour":27,"price_day":186,"color":["Orange","Silver","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Audi","car_model":"S4","quantity":6,"seats":5,"price_hour":39,"price_day":262,"color":["Blue","White","Grey","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Toyota","car_model":"Echo","quantity":5,"seats":3,"price_hour":33,"price_day":223,"color":["Grey","Silver","Pink","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercury","car_model":"Topaz","quantity":9,"seats":4,"price_hour":33,"price_day":162,"color":["Purple","Indigo","Black","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Isuzu","car_model":"Trooper","quantity":9,"seats":5,"price_hour":16,"price_day":284,"color":["White","Silver","Purple","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Porsche","car_model":"Boxster","quantity":6,"seats":2,"price_hour":16,"price_day":198,"color":["Pink","Blue","Grey","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mitsubishi","car_model":"Pajero","quantity":6,"seats":4,"price_hour":32,"price_day":186,"color":["Purple","Orange","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mazda","car_model":"B-Series","quantity":9,"seats":7,"price_hour":32,"price_day":211,"color":["Purple","Silver","Indigo","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Lexus","car_model":"ES","quantity":8,"seats":8,"price_hour":25,"price_day":275,"color":["Pink","Indigo","Orange","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Lotus","car_model":"Esprit","quantity":6,"seats":2,"price_hour":46,"price_day":238,"color":["Grey","Black","Silver","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Hyundai","car_model":"Accent","quantity":6,"seats":4,"price_hour":17,"price_day":273,"color":["Orange","Silver","Purple","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ford","car_model":"Escort","quantity":5,"seats":7,"price_hour":28,"price_day":157,"color":["Pink","Indigo","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Plymouth","car_model":"Colt","quantity":6,"seats":2,"price_hour":29,"price_day":226,"color":["Orange","Grey","Silver","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Infiniti","car_model":"FX","quantity":7,"seats":8,"price_hour":29,"price_day":242,"color":["Pink","Blue","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Porsche","car_model":"928","quantity":9,"seats":2,"price_hour":28,"price_day":268,"color":["Grey","Black","Orange","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Cadillac","car_model":"Escalade EXT","quantity":9,"seats":7,"price_hour":50,"price_day":151,"color":["Blue","Pink","Grey","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Chevrolet","car_model":"Suburban 1500","quantity":5,"seats":2,"price_hour":48,"price_day":281,"color":["Indigo","Purple","Grey","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Buick","car_model":"Century","quantity":8,"seats":7,"price_hour":34,"price_day":251,"color":["Silver","Orange","Pink","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mercedes-Benz","car_model":"E-Class","quantity":8,"seats":4,"price_hour":49,"price_day":212,"color":["Purple","White","Pink","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Ram 2500","quantity":9,"seats":8,"price_hour":47,"price_day":261,"color":["Black","Purple","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"MINI","car_model":"MINI","quantity":9,"seats":7,"price_hour":39,"price_day":188,"color":["Purple","Black","White","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Ford","car_model":"Econoline E350","quantity":6,"seats":5,"price_hour":32,"price_day":163,"color":["Silver","Blue","Black","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Hyundai","car_model":"Sonata","quantity":6,"seats":2,"price_hour":49,"price_day":275,"color":["Orange","Blue","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Nissan","car_model":"Pathfinder","quantity":9,"seats":7,"price_hour":33,"price_day":294,"color":["Silver","Purple","Orange","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Nissan","car_model":"Maxima","quantity":8,"seats":2,"price_hour":44,"price_day":252,"color":["Grey","Pink","Silver","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mitsubishi","car_model":"Lancer Evolution","quantity":8,"seats":5,"price_hour":17,"price_day":182,"color":["Silver","White","Pink","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Thunderbird","quantity":7,"seats":7,"price_hour":25,"price_day":280,"color":["Indigo","Blue","Pink","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ferrari","car_model":"California","quantity":7,"seats":6,"price_hour":21,"price_day":238,"color":["White","Grey","Silver","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Acura","car_model":"CL","quantity":5,"seats":8,"price_hour":33,"price_day":180,"color":["Black","Silver","Pink","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Toyota","car_model":"Prius","quantity":5,"seats":2,"price_hour":49,"price_day":297,"color":["White","Purple","Pink","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Lotus","car_model":"Esprit","quantity":9,"seats":4,"price_hour":47,"price_day":254,"color":["Pink","Silver","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Dodge","car_model":"Avenger","quantity":6,"seats":5,"price_hour":39,"price_day":268,"color":["White","Black","Orange","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Cadillac","car_model":"CTS-V","quantity":5,"seats":6,"price_hour":18,"price_day":289,"color":["Black","Purple","Blue","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Pontiac","car_model":"1000","quantity":9,"seats":8,"price_hour":45,"price_day":172,"color":["Indigo","Grey","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mazda","car_model":"B-Series","quantity":6,"seats":6,"price_hour":15,"price_day":167,"color":["Blue","Indigo","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"BMW","car_model":"545","quantity":7,"seats":2,"price_hour":47,"price_day":265,"color":["Orange","White","Blue","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercury","car_model":"Cougar","quantity":5,"seats":8,"price_hour":21,"price_day":179,"color":["Grey","Orange","Purple","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Dodge","car_model":"Ram Van 2500","quantity":8,"seats":7,"price_hour":46,"price_day":186,"color":["Orange","Blue","Black","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Kia","car_model":"Rondo","quantity":6,"seats":5,"price_hour":19,"price_day":248,"color":["Pink","Indigo","Purple","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Acura","car_model":"TL","quantity":8,"seats":6,"price_hour":42,"price_day":177,"color":["Indigo","White","Grey","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mercedes-Benz","car_model":"600SEC","quantity":8,"seats":8,"price_hour":43,"price_day":145,"color":["Silver","White","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Cadillac","car_model":"SRX","quantity":9,"seats":3,"price_hour":30,"price_day":161,"color":["Purple","Orange","Black","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Subaru","car_model":"Loyale","quantity":7,"seats":3,"price_hour":50,"price_day":223,"color":["White","Silver","Pink","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Dodge","car_model":"Dakota Club","quantity":5,"seats":4,"price_hour":49,"price_day":156,"color":["Orange","Grey","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"GMC","car_model":"Savana 1500","quantity":6,"seats":3,"price_hour":35,"price_day":179,"color":["Indigo","Purple","Black","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Jeep","car_model":"Compass","quantity":8,"seats":5,"price_hour":29,"price_day":237,"color":["Indigo","Grey","Pink","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Volvo","car_model":"V50","quantity":9,"seats":4,"price_hour":45,"price_day":289,"color":["Silver","Black","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Cadillac","car_model":"Seville","quantity":7,"seats":8,"price_hour":22,"price_day":295,"color":["Black","Purple","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Pontiac","car_model":"Fiero","quantity":9,"seats":7,"price_hour":46,"price_day":152,"color":["Blue","Orange","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Saab","car_model":"9000","quantity":5,"seats":8,"price_hour":49,"price_day":238,"color":["Black","Pink","White","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Toyota","car_model":"Corolla","quantity":7,"seats":2,"price_hour":27,"price_day":236,"color":["Purple","White","Grey","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Colt","quantity":7,"seats":6,"price_hour":39,"price_day":207,"color":["Pink","Black","Silver","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Cadillac","car_model":"CTS-V","quantity":8,"seats":8,"price_hour":40,"price_day":205,"color":["Blue","Black","Purple","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Oldsmobile","car_model":"88","quantity":9,"seats":4,"price_hour":18,"price_day":140,"color":["Grey","Silver","Pink","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"GMC","car_model":"Sierra Hybrid","quantity":7,"seats":5,"price_hour":48,"price_day":246,"color":["Grey","Orange","Indigo","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Toyota","car_model":"RAV4","quantity":7,"seats":6,"price_hour":43,"price_day":143,"color":["White","Pink","Silver","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mitsubishi","car_model":"Montero","quantity":6,"seats":6,"price_hour":17,"price_day":282,"color":["Orange","White","Purple","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Plymouth","car_model":"Voyager","quantity":6,"seats":3,"price_hour":20,"price_day":198,"color":["Purple","White","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Infiniti","car_model":"FX","quantity":7,"seats":4,"price_hour":22,"price_day":242,"color":["Purple","White","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mitsubishi","car_model":"Lancer","quantity":8,"seats":2,"price_hour":36,"price_day":252,"color":["Black","Orange","Grey","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Ford","car_model":"Thunderbird","quantity":5,"seats":7,"price_hour":22,"price_day":282,"color":["Purple","Black","Blue","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"BMW","car_model":"3 Series","quantity":8,"seats":3,"price_hour":32,"price_day":180,"color":["Blue","Purple","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Oldsmobile","car_model":"Intrigue","quantity":6,"seats":2,"price_hour":25,"price_day":237,"color":["White","Silver","Grey","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Dodge","car_model":"Durango","quantity":7,"seats":3,"price_hour":44,"price_day":225,"color":["Blue","Pink","Orange","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"GMC","car_model":"Envoy","quantity":7,"seats":3,"price_hour":21,"price_day":192,"color":["White","Orange","Blue","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Spyker","car_model":"C8 Spyder","quantity":9,"seats":7,"price_hour":41,"price_day":253,"color":["Orange","Black","Pink","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Chevrolet","car_model":"Camaro","quantity":6,"seats":4,"price_hour":25,"price_day":196,"color":["Indigo","Orange","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Oldsmobile","car_model":"Aurora","quantity":8,"seats":5,"price_hour":22,"price_day":277,"color":["Silver","Orange","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Mazda","car_model":"Tribute","quantity":5,"seats":2,"price_hour":50,"price_day":257,"color":["Purple","Grey","Orange","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Audi","car_model":"Q5","quantity":9,"seats":6,"price_hour":17,"price_day":249,"color":["Purple","Blue","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Suzuki","car_model":"Kizashi","quantity":8,"seats":4,"price_hour":38,"price_day":215,"color":["Blue","Purple","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Ram 2500","quantity":8,"seats":3,"price_hour":17,"price_day":284,"color":["Indigo","Silver","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Maserati","car_model":"GranTurismo","quantity":8,"seats":5,"price_hour":50,"price_day":258,"color":["White","Blue","Silver","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Volkswagen","car_model":"Jetta","quantity":5,"seats":3,"price_hour":29,"price_day":212,"color":["Pink","Indigo","Purple","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Mazda","car_model":"Miata MX-5","quantity":9,"seats":7,"price_hour":36,"price_day":276,"color":["Silver","Grey","Pink","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Buick","car_model":"Somerset","quantity":7,"seats":7,"price_hour":37,"price_day":149,"color":["Silver","White","Grey","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Saab","car_model":"9-5","quantity":7,"seats":6,"price_hour":16,"price_day":228,"color":["Blue","Pink","Grey","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Toyota","car_model":"Previa","quantity":9,"seats":6,"price_hour":24,"price_day":253,"color":["Blue","Purple","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mitsubishi","car_model":"Expo","quantity":9,"seats":8,"price_hour":31,"price_day":143,"color":["Black","Indigo","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Dodge","car_model":"Ram 1500","quantity":5,"seats":6,"price_hour":29,"price_day":163,"color":["Purple","White","Grey","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Infiniti","car_model":"I","quantity":6,"seats":4,"price_hour":42,"price_day":199,"color":["Indigo","Black","Purple","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mitsubishi","car_model":"Lancer Evolution","quantity":6,"seats":8,"price_hour":37,"price_day":230,"color":["Indigo","Orange","White","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Toyota","car_model":"Celica","quantity":7,"seats":8,"price_hour":48,"price_day":234,"color":["Indigo","Orange","Silver","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Hyundai","car_model":"Tucson","quantity":8,"seats":6,"price_hour":27,"price_day":256,"color":["Blue","Black","Pink","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Fillmore","car_model":"Fillmore","quantity":9,"seats":6,"price_hour":39,"price_day":253,"color":["Blue","Grey","Black","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Lexus","car_model":"IS","quantity":9,"seats":5,"price_hour":37,"price_day":204,"color":["Pink","Orange","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Pontiac","car_model":"Firebird Formula","quantity":5,"seats":8,"price_hour":35,"price_day":245,"color":["Indigo","Orange","Black","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Buick","car_model":"Park Avenue","quantity":6,"seats":5,"price_hour":33,"price_day":176,"color":["Blue","Grey","Pink","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Chevrolet","car_model":"Corvette","quantity":6,"seats":5,"price_hour":30,"price_day":271,"color":["Pink","Grey","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"BMW","car_model":"M","quantity":7,"seats":7,"price_hour":18,"price_day":224,"color":["Orange","Blue","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Volvo","car_model":"S80","quantity":7,"seats":7,"price_hour":38,"price_day":235,"color":["Black","Orange","Silver","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Honda","car_model":"CR-V","quantity":5,"seats":2,"price_hour":41,"price_day":142,"color":["Black","Pink","Grey","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Aspire","quantity":6,"seats":7,"price_hour":48,"price_day":237,"color":["Blue","Orange","Silver","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Club Wagon","quantity":7,"seats":5,"price_hour":23,"price_day":247,"color":["White","Blue","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Subaru","car_model":"Legacy","quantity":9,"seats":5,"price_hour":21,"price_day":256,"color":["Pink","Black","White","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Volkswagen","car_model":"Passat","quantity":5,"seats":8,"price_hour":25,"price_day":193,"color":["Indigo","Grey","Blue","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Aston Martin","car_model":"DBS","quantity":8,"seats":8,"price_hour":34,"price_day":140,"color":["Blue","Pink","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercedes-Benz","car_model":"400SEL","quantity":7,"seats":8,"price_hour":45,"price_day":153,"color":["Black","Pink","Indigo","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Buick","car_model":"Coachbuilder","quantity":6,"seats":2,"price_hour":21,"price_day":270,"color":["Indigo","Grey","Silver","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Chevrolet","car_model":"Suburban","quantity":5,"seats":5,"price_hour":34,"price_day":229,"color":["Purple","Blue","Black","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Buick","car_model":"Park Avenue","quantity":6,"seats":8,"price_hour":21,"price_day":209,"color":["Black","Pink","White","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Porsche","car_model":"928","quantity":8,"seats":6,"price_hour":35,"price_day":152,"color":["Blue","Purple","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Hyundai","car_model":"Elantra","quantity":6,"seats":6,"price_hour":24,"price_day":233,"color":["Orange","Silver","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Buick","car_model":"Century","quantity":6,"seats":8,"price_hour":31,"price_day":297,"color":["Purple","Blue","Grey","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Isuzu","car_model":"Ascender","quantity":6,"seats":8,"price_hour":44,"price_day":279,"color":["Grey","Blue","Pink","Silver"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Lotus","car_model":"Esprit","quantity":7,"seats":7,"price_hour":16,"price_day":147,"color":["Purple","Pink","Blue","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Infiniti","car_model":"QX","quantity":6,"seats":3,"price_hour":25,"price_day":162,"color":["White","Silver","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Toyota","car_model":"Highlander","quantity":5,"seats":5,"price_hour":47,"price_day":284,"color":["Silver","Indigo","Purple","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Dodge","car_model":"Durango","quantity":5,"seats":2,"price_hour":24,"price_day":298,"color":["White","Indigo","Orange","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Mercedes-Benz","car_model":"S-Class","quantity":6,"seats":7,"price_hour":48,"price_day":271,"color":["Orange","Indigo","Grey","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Cadillac","car_model":"Fleetwood","quantity":6,"seats":6,"price_hour":30,"price_day":293,"color":["White","Orange","Purple","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Volkswagen","car_model":"Corrado","quantity":8,"seats":8,"price_hour":35,"price_day":213,"color":["Grey","Orange","Silver","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Chevrolet","car_model":"Sportvan G30","quantity":6,"seats":2,"price_hour":16,"price_day":144,"color":["Black","Pink","White","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Chevrolet","car_model":"Aveo","quantity":9,"seats":8,"price_hour":31,"price_day":244,"color":["Indigo","Blue","Black","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"GMC","car_model":"1500","quantity":6,"seats":6,"price_hour":18,"price_day":206,"color":["Black","Pink","Orange","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Maserati","car_model":"Quattroporte","quantity":6,"seats":3,"price_hour":19,"price_day":186,"color":["Silver","Blue","Indigo","Pink"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Ford","car_model":"Escort","quantity":7,"seats":3,"price_hour":43,"price_day":211,"color":["Blue","Purple","Pink","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Lexus","car_model":"ES","quantity":7,"seats":7,"price_hour":18,"price_day":145,"color":["White","Purple","Orange","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Chevrolet","car_model":"Impala","quantity":7,"seats":3,"price_hour":32,"price_day":212,"color":["Black","Purple","Indigo","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Dodge","car_model":"D250","quantity":5,"seats":2,"price_hour":46,"price_day":257,"color":["White","Purple","Orange","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Van","car_make":"Jeep","car_model":"Comanche","quantity":6,"seats":2,"price_hour":41,"price_day":252,"color":["Grey","Black","Silver","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Pontiac","car_model":"Sunbird","quantity":5,"seats":5,"price_hour":26,"price_day":169,"color":["Black","Grey","Blue","Indigo"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Nissan","car_model":"GT-R","quantity":5,"seats":5,"price_hour":33,"price_day":232,"color":["White","Indigo","Black","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ford","car_model":"Explorer","quantity":5,"seats":2,"price_hour":35,"price_day":149,"color":["Pink","Orange","White","Black"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Acura","car_model":"MDX","quantity":6,"seats":4,"price_hour":50,"price_day":221,"color":["Purple","Grey","Pink","Blue"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Land Rover","car_model":"Defender Ice Edition","quantity":8,"seats":4,"price_hour":48,"price_day":183,"color":["Silver","Purple","Pink","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Ford","car_model":"Focus","quantity":7,"seats":6,"price_hour":15,"price_day":195,"color":["Pink","Silver","Orange","White"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Truck","car_make":"Dodge","car_model":"Dakota Club","quantity":9,"seats":6,"price_hour":19,"price_day":221,"color":["Blue","Indigo","Pink","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Lexus","car_model":"IS-F","quantity":7,"seats":3,"price_hour":37,"price_day":170,"color":["Pink","Silver","Indigo","Orange"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Hatchback","car_make":"Ford","car_model":"Ranger","quantity":5,"seats":4,"price_hour":43,"price_day":290,"color":["Black","Orange","Grey","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Honda","car_model":"Accord","quantity":9,"seats":7,"price_hour":25,"price_day":143,"color":["Pink","Purple","Black","Grey"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"Sedan","car_make":"Subaru","car_model":"SVX","quantity":5,"seats":4,"price_hour":22,"price_day":167,"color":["Orange","Black","Blue","Purple"]}]}','2020-08-04'),
('{"vehicle":[{"vehicle_type":"SUV","car_make":"Mercury","car_model":"Marquis","quantity":8,"seats":8,"price_hour":34,"price_day":185,"color":["Pink","Purple","Blue","White"]}]}','2020-08-04');
136 rows affected

SELECT e.*
  FROM example e
 CROSS JOIN jsonb_array_elements(jsonTest->'vehicle') j(elm)
 WHERE (j.elm->>'color')::jsonb ? 'Blue'
 


id
jsontest
create_at


1
{"vehicle": [{"color": ["White", "Orange", "Blue", "Indigo"], "seats": 3, "car_make": "Suzuki", "quantity": 9, "car_model": "XL-7", "price_day": 187, "price_hour": 49, "vehicle_type": "Van"}]}
2020-08-04

5
{"vehicle": [{"color": ["Blue", "White", "Grey", "Purple"], "seats": 5, "car_make": "Audi", "quantity": 6, "car_model": "S4", "price_day": 262, "price_hour": 39, "vehicle_type": "Hatchback"}]}
2020-08-04

9
{"vehicle": [{"color": ["Pink", "Blue", "Grey", "Silver"], "seats": 2, "car_make": "Porsche", "quantity": 6, "car_model": "Boxster", "price_day": 198, "price_hour": 16, "vehicle_type": "Sedan"}]}
2020-08-04

10
{"vehicle": [{"color": ["Purple", "Orange", "Blue", "White"], "seats": 4, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Pajero", "price_day": 186, "price_hour": 32, "vehicle_type": "Van"}]}
2020-08-04

15
{"vehicle": [{"color": ["Pink", "Indigo", "Blue", "White"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Escort", "price_day": 157, "price_hour": 28, "vehicle_type": "SUV"}]}
2020-08-04

16
{"vehicle": [{"color": ["Orange", "Grey", "Silver", "Blue"], "seats": 2, "car_make": "Plymouth", "quantity": 6, "car_model": "Colt", "price_day": 226, "price_hour": 29, "vehicle_type": "Sedan"}]}
2020-08-04

17
{"vehicle": [{"color": ["Pink", "Blue", "White", "Black"], "seats": 8, "car_make": "Infiniti", "quantity": 7, "car_model": "FX", "price_day": 242, "price_hour": 29, "vehicle_type": "Hatchback"}]}
2020-08-04

19
{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 7, "car_make": "Cadillac", "quantity": 9, "car_model": "Escalade EXT", "price_day": 151, "price_hour": 50, "vehicle_type": "Hatchback"}]}
2020-08-04

25
{"vehicle": [{"color": ["Silver", "Blue", "Black", "Purple"], "seats": 5, "car_make": "Ford", "quantity": 6, "car_model": "Econoline E350", "price_day": 163, "price_hour": 32, "vehicle_type": "Sedan"}]}
2020-08-04

26
{"vehicle": [{"color": ["Orange", "Blue", "Black", "White"], "seats": 2, "car_make": "Hyundai", "quantity": 6, "car_model": "Sonata", "price_day": 275, "price_hour": 49, "vehicle_type": "Van"}]}
2020-08-04

30
{"vehicle": [{"color": ["Indigo", "Blue", "Pink", "Purple"], "seats": 7, "car_make": "Ford", "quantity": 7, "car_model": "Thunderbird", "price_day": 280, "price_hour": 25, "vehicle_type": "Hatchback"}]}
2020-08-04

32
{"vehicle": [{"color": ["Black", "Silver", "Pink", "Blue"], "seats": 8, "car_make": "Acura", "quantity": 5, "car_model": "CL", "price_day": 180, "price_hour": 33, "vehicle_type": "Van"}]}
2020-08-04

36
{"vehicle": [{"color": ["Black", "Purple", "Blue", "Grey"], "seats": 6, "car_make": "Cadillac", "quantity": 5, "car_model": "CTS-V", "price_day": 289, "price_hour": 18, "vehicle_type": "Hatchback"}]}
2020-08-04

38
{"vehicle": [{"color": ["Blue", "Indigo", "Purple", "Black"], "seats": 6, "car_make": "Mazda", "quantity": 6, "car_model": "B-Series", "price_day": 167, "price_hour": 15, "vehicle_type": "Van"}]}
2020-08-04

39
{"vehicle": [{"color": ["Orange", "White", "Blue", "Purple"], "seats": 2, "car_make": "BMW", "quantity": 7, "car_model": "545", "price_day": 265, "price_hour": 47, "vehicle_type": "Van"}]}
2020-08-04

41
{"vehicle": [{"color": ["Orange", "Blue", "Black", "Pink"], "seats": 7, "car_make": "Dodge", "quantity": 8, "car_model": "Ram Van 2500", "price_day": 186, "price_hour": 46, "vehicle_type": "SUV"}]}
2020-08-04

42
{"vehicle": [{"color": ["Pink", "Indigo", "Purple", "Blue"], "seats": 5, "car_make": "Kia", "quantity": 6, "car_model": "Rondo", "price_day": 248, "price_hour": 19, "vehicle_type": "Hatchback"}]}
2020-08-04

47
{"vehicle": [{"color": ["Orange", "Grey", "Blue", "Indigo"], "seats": 4, "car_make": "Dodge", "quantity": 5, "car_model": "Dakota Club", "price_day": 156, "price_hour": 49, "vehicle_type": "SUV"}]}
2020-08-04

51
{"vehicle": [{"color": ["Black", "Purple", "Blue", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 7, "car_model": "Seville", "price_day": 295, "price_hour": 22, "vehicle_type": "Van"}]}
2020-08-04

52
{"vehicle": [{"color": ["Blue", "Orange", "Indigo", "Grey"], "seats": 7, "car_make": "Pontiac", "quantity": 9, "car_model": "Fiero", "price_day": 152, "price_hour": 46, "vehicle_type": "Hatchback"}]}
2020-08-04

56
{"vehicle": [{"color": ["Blue", "Black", "Purple", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 8, "car_model": "CTS-V", "price_day": 205, "price_hour": 40, "vehicle_type": "Sedan"}]}
2020-08-04

63
{"vehicle": [{"color": ["Black", "Orange", "Grey", "Blue"], "seats": 2, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer", "price_day": 252, "price_hour": 36, "vehicle_type": "Van"}]}
2020-08-04

64
{"vehicle": [{"color": ["Purple", "Black", "Blue", "Orange"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Thunderbird", "price_day": 282, "price_hour": 22, "vehicle_type": "Sedan"}]}
2020-08-04

65
{"vehicle": [{"color": ["Blue", "Purple", "Orange", "Indigo"], "seats": 3, "car_make": "BMW", "quantity": 8, "car_model": "3 Series", "price_day": 180, "price_hour": 32, "vehicle_type": "Hatchback"}]}
2020-08-04

67
{"vehicle": [{"color": ["Blue", "Pink", "Orange", "Purple"], "seats": 3, "car_make": "Dodge", "quantity": 7, "car_model": "Durango", "price_day": 225, "price_hour": 44, "vehicle_type": "Van"}]}
2020-08-04

68
{"vehicle": [{"color": ["White", "Orange", "Blue", "Purple"], "seats": 3, "car_make": "GMC", "quantity": 7, "car_model": "Envoy", "price_day": 192, "price_hour": 21, "vehicle_type": "Van"}]}
2020-08-04

73
{"vehicle": [{"color": ["Purple", "Blue", "Orange", "Grey"], "seats": 6, "car_make": "Audi", "quantity": 9, "car_model": "Q5", "price_day": 249, "price_hour": 17, "vehicle_type": "SUV"}]}
2020-08-04

74
{"vehicle": [{"color": ["Blue", "Purple", "Silver", "Pink"], "seats": 4, "car_make": "Suzuki", "quantity": 8, "car_model": "Kizashi", "price_day": 215, "price_hour": 38, "vehicle_type": "SUV"}]}
2020-08-04

76
{"vehicle": [{"color": ["White", "Blue", "Silver", "Indigo"], "seats": 5, "car_make": "Maserati", "quantity": 8, "car_model": "GranTurismo", "price_day": 258, "price_hour": 50, "vehicle_type": "Van"}]}
2020-08-04

80
{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 6, "car_make": "Saab", "quantity": 7, "car_model": "9-5", "price_day": 228, "price_hour": 16, "vehicle_type": "Sedan"}]}
2020-08-04

81
{"vehicle": [{"color": ["Blue", "Purple", "Indigo", "Grey"], "seats": 6, "car_make": "Toyota", "quantity": 9, "car_model": "Previa", "price_day": 253, "price_hour": 24, "vehicle_type": "Hatchback"}]}
2020-08-04

87
{"vehicle": [{"color": ["Blue", "Black", "Pink", "Grey"], "seats": 6, "car_make": "Hyundai", "quantity": 8, "car_model": "Tucson", "price_day": 256, "price_hour": 27, "vehicle_type": "Hatchback"}]}
2020-08-04

88
{"vehicle": [{"color": ["Blue", "Grey", "Black", "Orange"], "seats": 6, "car_make": "Fillmore", "quantity": 9, "car_model": "Fillmore", "price_day": 253, "price_hour": 39, "vehicle_type": "Hatchback"}]}
2020-08-04

91
{"vehicle": [{"color": ["Blue", "Grey", "Pink", "Indigo"], "seats": 5, "car_make": "Buick", "quantity": 6, "car_model": "Park Avenue", "price_day": 176, "price_hour": 33, "vehicle_type": "Hatchback"}]}
2020-08-04

93
{"vehicle": [{"color": ["Orange", "Blue", "Indigo", "Grey"], "seats": 7, "car_make": "BMW", "quantity": 7, "car_model": "M", "price_day": 224, "price_hour": 18, "vehicle_type": "Truck"}]}
2020-08-04

95
{"vehicle": [{"color": ["Black", "Pink", "Grey", "Blue"], "seats": 2, "car_make": "Honda", "quantity": 5, "car_model": "CR-V", "price_day": 142, "price_hour": 41, "vehicle_type": "Sedan"}]}
2020-08-04

96
{"vehicle": [{"color": ["Blue", "Orange", "Silver", "Black"], "seats": 7, "car_make": "Ford", "quantity": 6, "car_model": "Aspire", "price_day": 237, "price_hour": 48, "vehicle_type": "Hatchback"}]}
2020-08-04

97
{"vehicle": [{"color": ["White", "Blue", "Silver", "Pink"], "seats": 5, "car_make": "Ford", "quantity": 7, "car_model": "Club Wagon", "price_day": 247, "price_hour": 23, "vehicle_type": "Hatchback"}]}
2020-08-04

99
{"vehicle": [{"color": ["Indigo", "Grey", "Blue", "Silver"], "seats": 8, "car_make": "Volkswagen", "quantity": 5, "car_model": "Passat", "price_day": 193, "price_hour": 25, "vehicle_type": "Sedan"}]}
2020-08-04

100
{"vehicle": [{"color": ["Blue", "Pink", "Black", "Grey"], "seats": 8, "car_make": "Aston Martin", "quantity": 8, "car_model": "DBS", "price_day": 140, "price_hour": 34, "vehicle_type": "Van"}]}
2020-08-04

103
{"vehicle": [{"color": ["Purple", "Blue", "Black", "Orange"], "seats": 5, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban", "price_day": 229, "price_hour": 34, "vehicle_type": "Truck"}]}
2020-08-04

105
{"vehicle": [{"color": ["Blue", "Purple", "Black", "Grey"], "seats": 6, "car_make": "Porsche", "quantity": 8, "car_model": "928", "price_day": 152, "price_hour": 35, "vehicle_type": "Truck"}]}
2020-08-04

107
{"vehicle": [{"color": ["Purple", "Blue", "Grey", "Indigo"], "seats": 8, "car_make": "Buick", "quantity": 6, "car_model": "Century", "price_day": 297, "price_hour": 31, "vehicle_type": "Truck"}]}
2020-08-04

108
{"vehicle": [{"color": ["Grey", "Blue", "Pink", "Silver"], "seats": 8, "car_make": "Isuzu", "quantity": 6, "car_model": "Ascender", "price_day": 279, "price_hour": 44, "vehicle_type": "SUV"}]}
2020-08-04

109
{"vehicle": [{"color": ["Purple", "Pink", "Blue", "White"], "seats": 7, "car_make": "Lotus", "quantity": 7, "car_model": "Esprit", "price_day": 147, "price_hour": 16, "vehicle_type": "Truck"}]}
2020-08-04

110
{"vehicle": [{"color": ["White", "Silver", "Blue", "Indigo"], "seats": 3, "car_make": "Infiniti", "quantity": 6, "car_model": "QX", "price_day": 162, "price_hour": 25, "vehicle_type": "Van"}]}
2020-08-04

113
{"vehicle": [{"color": ["Orange", "Indigo", "Grey", "Blue"], "seats": 7, "car_make": "Mercedes-Benz", "quantity": 6, "car_model": "S-Class", "price_day": 271, "price_hour": 48, "vehicle_type": "Hatchback"}]}
2020-08-04

117
{"vehicle": [{"color": ["Indigo", "Blue", "Black", "Orange"], "seats": 8, "car_make": "Chevrolet", "quantity": 9, "car_model": "Aveo", "price_day": 244, "price_hour": 31, "vehicle_type": "Hatchback"}]}
2020-08-04

119
{"vehicle": [{"color": ["Silver", "Blue", "Indigo", "Pink"], "seats": 3, "car_make": "Maserati", "quantity": 6, "car_model": "Quattroporte", "price_day": 186, "price_hour": 19, "vehicle_type": "Truck"}]}
2020-08-04

120
{"vehicle": [{"color": ["Blue", "Purple", "Pink", "Black"], "seats": 3, "car_make": "Ford", "quantity": 7, "car_model": "Escort", "price_day": 211, "price_hour": 43, "vehicle_type": "Sedan"}]}
2020-08-04

125
{"vehicle": [{"color": ["Black", "Grey", "Blue", "Indigo"], "seats": 5, "car_make": "Pontiac", "quantity": 5, "car_model": "Sunbird", "price_day": 169, "price_hour": 26, "vehicle_type": "SUV"}]}
2020-08-04

126
{"vehicle": [{"color": ["White", "Indigo", "Black", "Blue"], "seats": 5, "car_make": "Nissan", "quantity": 5, "car_model": "GT-R", "price_day": 232, "price_hour": 33, "vehicle_type": "Hatchback"}]}
2020-08-04

128
{"vehicle": [{"color": ["Purple", "Grey", "Pink", "Blue"], "seats": 4, "car_make": "Acura", "quantity": 6, "car_model": "MDX", "price_day": 221, "price_hour": 50, "vehicle_type": "Hatchback"}]}
2020-08-04

131
{"vehicle": [{"color": ["Blue", "Indigo", "Pink", "Grey"], "seats": 6, "car_make": "Dodge", "quantity": 9, "car_model": "Dakota Club", "price_day": 221, "price_hour": 19, "vehicle_type": "Truck"}]}
2020-08-04

135
{"vehicle": [{"color": ["Orange", "Black", "Blue", "Purple"], "seats": 4, "car_make": "Subaru", "quantity": 5, "car_model": "SVX", "price_day": 167, "price_hour": 22, "vehicle_type": "Sedan"}]}
2020-08-04

136
{"vehicle": [{"color": ["Pink", "Purple", "Blue", "White"], "seats": 8, "car_make": "Mercury", "quantity": 8, "car_model": "Marquis", "price_day": 185, "price_hour": 34, "vehicle_type": "SUV"}]}
2020-08-04


SELECT e.*
  FROM example e
 CROSS JOIN jsonb_array_elements(jsonTest->'vehicle') j(elm)
 WHERE (j.elm->>'vehicle_type') = 'SUV'


id
jsontest
create_at


7
{"vehicle": [{"color": ["Purple", "Indigo", "Black", "Pink"], "seats": 4, "car_make": "Mercury", "quantity": 9, "car_model": "Topaz", "price_day": 162, "price_hour": 33, "vehicle_type": "SUV"}]}
2020-08-04

12
{"vehicle": [{"color": ["Pink", "Indigo", "Orange", "Black"], "seats": 8, "car_make": "Lexus", "quantity": 8, "car_model": "ES", "price_day": 275, "price_hour": 25, "vehicle_type": "SUV"}]}
2020-08-04

15
{"vehicle": [{"color": ["Pink", "Indigo", "Blue", "White"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Escort", "price_day": 157, "price_hour": 28, "vehicle_type": "SUV"}]}
2020-08-04

18
{"vehicle": [{"color": ["Grey", "Black", "Orange", "White"], "seats": 2, "car_make": "Porsche", "quantity": 9, "car_model": "928", "price_day": 268, "price_hour": 28, "vehicle_type": "SUV"}]}
2020-08-04

20
{"vehicle": [{"color": ["Indigo", "Purple", "Grey", "Black"], "seats": 2, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban 1500", "price_day": 281, "price_hour": 48, "vehicle_type": "SUV"}]}
2020-08-04

29
{"vehicle": [{"color": ["Silver", "White", "Pink", "Orange"], "seats": 5, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer Evolution", "price_day": 182, "price_hour": 17, "vehicle_type": "SUV"}]}
2020-08-04

31
{"vehicle": [{"color": ["White", "Grey", "Silver", "Orange"], "seats": 6, "car_make": "Ferrari", "quantity": 7, "car_model": "California", "price_day": 238, "price_hour": 21, "vehicle_type": "SUV"}]}
2020-08-04

40
{"vehicle": [{"color": ["Grey", "Orange", "Purple", "Pink"], "seats": 8, "car_make": "Mercury", "quantity": 5, "car_model": "Cougar", "price_day": 179, "price_hour": 21, "vehicle_type": "SUV"}]}
2020-08-04

41
{"vehicle": [{"color": ["Orange", "Blue", "Black", "Pink"], "seats": 7, "car_make": "Dodge", "quantity": 8, "car_model": "Ram Van 2500", "price_day": 186, "price_hour": 46, "vehicle_type": "SUV"}]}
2020-08-04

47
{"vehicle": [{"color": ["Orange", "Grey", "Blue", "Indigo"], "seats": 4, "car_make": "Dodge", "quantity": 5, "car_model": "Dakota Club", "price_day": 156, "price_hour": 49, "vehicle_type": "SUV"}]}
2020-08-04

58
{"vehicle": [{"color": ["Grey", "Orange", "Indigo", "Black"], "seats": 5, "car_make": "GMC", "quantity": 7, "car_model": "Sierra Hybrid", "price_day": 246, "price_hour": 48, "vehicle_type": "SUV"}]}
2020-08-04

69
{"vehicle": [{"color": ["Orange", "Black", "Pink", "Silver"], "seats": 7, "car_make": "Spyker", "quantity": 9, "car_model": "C8 Spyder", "price_day": 253, "price_hour": 41, "vehicle_type": "SUV"}]}
2020-08-04

73
{"vehicle": [{"color": ["Purple", "Blue", "Orange", "Grey"], "seats": 6, "car_make": "Audi", "quantity": 9, "car_model": "Q5", "price_day": 249, "price_hour": 17, "vehicle_type": "SUV"}]}
2020-08-04

74
{"vehicle": [{"color": ["Blue", "Purple", "Silver", "Pink"], "seats": 4, "car_make": "Suzuki", "quantity": 8, "car_model": "Kizashi", "price_day": 215, "price_hour": 38, "vehicle_type": "SUV"}]}
2020-08-04

85
{"vehicle": [{"color": ["Indigo", "Orange", "White", "Pink"], "seats": 8, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Lancer Evolution", "price_day": 230, "price_hour": 37, "vehicle_type": "SUV"}]}
2020-08-04

101
{"vehicle": [{"color": ["Black", "Pink", "Indigo", "Grey"], "seats": 8, "car_make": "Mercedes-Benz", "quantity": 7, "car_model": "400SEL", "price_day": 153, "price_hour": 45, "vehicle_type": "SUV"}]}
2020-08-04

102
{"vehicle": [{"color": ["Indigo", "Grey", "Silver", "Orange"], "seats": 2, "car_make": "Buick", "quantity": 6, "car_model": "Coachbuilder", "price_day": 270, "price_hour": 21, "vehicle_type": "SUV"}]}
2020-08-04

108
{"vehicle": [{"color": ["Grey", "Blue", "Pink", "Silver"], "seats": 8, "car_make": "Isuzu", "quantity": 6, "car_model": "Ascender", "price_day": 279, "price_hour": 44, "vehicle_type": "SUV"}]}
2020-08-04

112
{"vehicle": [{"color": ["White", "Indigo", "Orange", "Purple"], "seats": 2, "car_make": "Dodge", "quantity": 5, "car_model": "Durango", "price_day": 298, "price_hour": 24, "vehicle_type": "SUV"}]}
2020-08-04

118
{"vehicle": [{"color": ["Black", "Pink", "Orange", "Purple"], "seats": 6, "car_make": "GMC", "quantity": 6, "car_model": "1500", "price_day": 206, "price_hour": 18, "vehicle_type": "SUV"}]}
2020-08-04

125
{"vehicle": [{"color": ["Black", "Grey", "Blue", "Indigo"], "seats": 5, "car_make": "Pontiac", "quantity": 5, "car_model": "Sunbird", "price_day": 169, "price_hour": 26, "vehicle_type": "SUV"}]}
2020-08-04

127
{"vehicle": [{"color": ["Pink", "Orange", "White", "Black"], "seats": 2, "car_make": "Ford", "quantity": 5, "car_model": "Explorer", "price_day": 149, "price_hour": 35, "vehicle_type": "SUV"}]}
2020-08-04

130
{"vehicle": [{"color": ["Pink", "Silver", "Orange", "White"], "seats": 6, "car_make": "Ford", "quantity": 7, "car_model": "Focus", "price_day": 195, "price_hour": 15, "vehicle_type": "SUV"}]}
2020-08-04

136
{"vehicle": [{"color": ["Pink", "Purple", "Blue", "White"], "seats": 8, "car_make": "Mercury", "quantity": 8, "car_model": "Marquis", "price_day": 185, "price_hour": 34, "vehicle_type": "SUV"}]}
2020-08-04

id	jsontest	create_at
1	{"vehicle": [{"color": ["White", "Orange", "Blue", "Indigo"], "seats": 3, "car_make": "Suzuki", "quantity": 9, "car_model": "XL-7", "price_day": 187, "price_hour": 49, "vehicle_type": "Van"}]}	2020-08-04
5	{"vehicle": [{"color": ["Blue", "White", "Grey", "Purple"], "seats": 5, "car_make": "Audi", "quantity": 6, "car_model": "S4", "price_day": 262, "price_hour": 39, "vehicle_type": "Hatchback"}]}	2020-08-04
9	{"vehicle": [{"color": ["Pink", "Blue", "Grey", "Silver"], "seats": 2, "car_make": "Porsche", "quantity": 6, "car_model": "Boxster", "price_day": 198, "price_hour": 16, "vehicle_type": "Sedan"}]}	2020-08-04
10	{"vehicle": [{"color": ["Purple", "Orange", "Blue", "White"], "seats": 4, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Pajero", "price_day": 186, "price_hour": 32, "vehicle_type": "Van"}]}	2020-08-04
15	{"vehicle": [{"color": ["Pink", "Indigo", "Blue", "White"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Escort", "price_day": 157, "price_hour": 28, "vehicle_type": "SUV"}]}	2020-08-04
16	{"vehicle": [{"color": ["Orange", "Grey", "Silver", "Blue"], "seats": 2, "car_make": "Plymouth", "quantity": 6, "car_model": "Colt", "price_day": 226, "price_hour": 29, "vehicle_type": "Sedan"}]}	2020-08-04
17	{"vehicle": [{"color": ["Pink", "Blue", "White", "Black"], "seats": 8, "car_make": "Infiniti", "quantity": 7, "car_model": "FX", "price_day": 242, "price_hour": 29, "vehicle_type": "Hatchback"}]}	2020-08-04
19	{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 7, "car_make": "Cadillac", "quantity": 9, "car_model": "Escalade EXT", "price_day": 151, "price_hour": 50, "vehicle_type": "Hatchback"}]}	2020-08-04
25	{"vehicle": [{"color": ["Silver", "Blue", "Black", "Purple"], "seats": 5, "car_make": "Ford", "quantity": 6, "car_model": "Econoline E350", "price_day": 163, "price_hour": 32, "vehicle_type": "Sedan"}]}	2020-08-04
26	{"vehicle": [{"color": ["Orange", "Blue", "Black", "White"], "seats": 2, "car_make": "Hyundai", "quantity": 6, "car_model": "Sonata", "price_day": 275, "price_hour": 49, "vehicle_type": "Van"}]}	2020-08-04
30	{"vehicle": [{"color": ["Indigo", "Blue", "Pink", "Purple"], "seats": 7, "car_make": "Ford", "quantity": 7, "car_model": "Thunderbird", "price_day": 280, "price_hour": 25, "vehicle_type": "Hatchback"}]}	2020-08-04
32	{"vehicle": [{"color": ["Black", "Silver", "Pink", "Blue"], "seats": 8, "car_make": "Acura", "quantity": 5, "car_model": "CL", "price_day": 180, "price_hour": 33, "vehicle_type": "Van"}]}	2020-08-04
36	{"vehicle": [{"color": ["Black", "Purple", "Blue", "Grey"], "seats": 6, "car_make": "Cadillac", "quantity": 5, "car_model": "CTS-V", "price_day": 289, "price_hour": 18, "vehicle_type": "Hatchback"}]}	2020-08-04
38	{"vehicle": [{"color": ["Blue", "Indigo", "Purple", "Black"], "seats": 6, "car_make": "Mazda", "quantity": 6, "car_model": "B-Series", "price_day": 167, "price_hour": 15, "vehicle_type": "Van"}]}	2020-08-04
39	{"vehicle": [{"color": ["Orange", "White", "Blue", "Purple"], "seats": 2, "car_make": "BMW", "quantity": 7, "car_model": "545", "price_day": 265, "price_hour": 47, "vehicle_type": "Van"}]}	2020-08-04
41	{"vehicle": [{"color": ["Orange", "Blue", "Black", "Pink"], "seats": 7, "car_make": "Dodge", "quantity": 8, "car_model": "Ram Van 2500", "price_day": 186, "price_hour": 46, "vehicle_type": "SUV"}]}	2020-08-04
42	{"vehicle": [{"color": ["Pink", "Indigo", "Purple", "Blue"], "seats": 5, "car_make": "Kia", "quantity": 6, "car_model": "Rondo", "price_day": 248, "price_hour": 19, "vehicle_type": "Hatchback"}]}	2020-08-04
47	{"vehicle": [{"color": ["Orange", "Grey", "Blue", "Indigo"], "seats": 4, "car_make": "Dodge", "quantity": 5, "car_model": "Dakota Club", "price_day": 156, "price_hour": 49, "vehicle_type": "SUV"}]}	2020-08-04
51	{"vehicle": [{"color": ["Black", "Purple", "Blue", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 7, "car_model": "Seville", "price_day": 295, "price_hour": 22, "vehicle_type": "Van"}]}	2020-08-04
52	{"vehicle": [{"color": ["Blue", "Orange", "Indigo", "Grey"], "seats": 7, "car_make": "Pontiac", "quantity": 9, "car_model": "Fiero", "price_day": 152, "price_hour": 46, "vehicle_type": "Hatchback"}]}	2020-08-04
56	{"vehicle": [{"color": ["Blue", "Black", "Purple", "White"], "seats": 8, "car_make": "Cadillac", "quantity": 8, "car_model": "CTS-V", "price_day": 205, "price_hour": 40, "vehicle_type": "Sedan"}]}	2020-08-04
63	{"vehicle": [{"color": ["Black", "Orange", "Grey", "Blue"], "seats": 2, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer", "price_day": 252, "price_hour": 36, "vehicle_type": "Van"}]}	2020-08-04
64	{"vehicle": [{"color": ["Purple", "Black", "Blue", "Orange"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Thunderbird", "price_day": 282, "price_hour": 22, "vehicle_type": "Sedan"}]}	2020-08-04
65	{"vehicle": [{"color": ["Blue", "Purple", "Orange", "Indigo"], "seats": 3, "car_make": "BMW", "quantity": 8, "car_model": "3 Series", "price_day": 180, "price_hour": 32, "vehicle_type": "Hatchback"}]}	2020-08-04
67	{"vehicle": [{"color": ["Blue", "Pink", "Orange", "Purple"], "seats": 3, "car_make": "Dodge", "quantity": 7, "car_model": "Durango", "price_day": 225, "price_hour": 44, "vehicle_type": "Van"}]}	2020-08-04
68	{"vehicle": [{"color": ["White", "Orange", "Blue", "Purple"], "seats": 3, "car_make": "GMC", "quantity": 7, "car_model": "Envoy", "price_day": 192, "price_hour": 21, "vehicle_type": "Van"}]}	2020-08-04
73	{"vehicle": [{"color": ["Purple", "Blue", "Orange", "Grey"], "seats": 6, "car_make": "Audi", "quantity": 9, "car_model": "Q5", "price_day": 249, "price_hour": 17, "vehicle_type": "SUV"}]}	2020-08-04
74	{"vehicle": [{"color": ["Blue", "Purple", "Silver", "Pink"], "seats": 4, "car_make": "Suzuki", "quantity": 8, "car_model": "Kizashi", "price_day": 215, "price_hour": 38, "vehicle_type": "SUV"}]}	2020-08-04
76	{"vehicle": [{"color": ["White", "Blue", "Silver", "Indigo"], "seats": 5, "car_make": "Maserati", "quantity": 8, "car_model": "GranTurismo", "price_day": 258, "price_hour": 50, "vehicle_type": "Van"}]}	2020-08-04
80	{"vehicle": [{"color": ["Blue", "Pink", "Grey", "White"], "seats": 6, "car_make": "Saab", "quantity": 7, "car_model": "9-5", "price_day": 228, "price_hour": 16, "vehicle_type": "Sedan"}]}	2020-08-04
81	{"vehicle": [{"color": ["Blue", "Purple", "Indigo", "Grey"], "seats": 6, "car_make": "Toyota", "quantity": 9, "car_model": "Previa", "price_day": 253, "price_hour": 24, "vehicle_type": "Hatchback"}]}	2020-08-04
87	{"vehicle": [{"color": ["Blue", "Black", "Pink", "Grey"], "seats": 6, "car_make": "Hyundai", "quantity": 8, "car_model": "Tucson", "price_day": 256, "price_hour": 27, "vehicle_type": "Hatchback"}]}	2020-08-04
88	{"vehicle": [{"color": ["Blue", "Grey", "Black", "Orange"], "seats": 6, "car_make": "Fillmore", "quantity": 9, "car_model": "Fillmore", "price_day": 253, "price_hour": 39, "vehicle_type": "Hatchback"}]}	2020-08-04
91	{"vehicle": [{"color": ["Blue", "Grey", "Pink", "Indigo"], "seats": 5, "car_make": "Buick", "quantity": 6, "car_model": "Park Avenue", "price_day": 176, "price_hour": 33, "vehicle_type": "Hatchback"}]}	2020-08-04
93	{"vehicle": [{"color": ["Orange", "Blue", "Indigo", "Grey"], "seats": 7, "car_make": "BMW", "quantity": 7, "car_model": "M", "price_day": 224, "price_hour": 18, "vehicle_type": "Truck"}]}	2020-08-04
95	{"vehicle": [{"color": ["Black", "Pink", "Grey", "Blue"], "seats": 2, "car_make": "Honda", "quantity": 5, "car_model": "CR-V", "price_day": 142, "price_hour": 41, "vehicle_type": "Sedan"}]}	2020-08-04
96	{"vehicle": [{"color": ["Blue", "Orange", "Silver", "Black"], "seats": 7, "car_make": "Ford", "quantity": 6, "car_model": "Aspire", "price_day": 237, "price_hour": 48, "vehicle_type": "Hatchback"}]}	2020-08-04
97	{"vehicle": [{"color": ["White", "Blue", "Silver", "Pink"], "seats": 5, "car_make": "Ford", "quantity": 7, "car_model": "Club Wagon", "price_day": 247, "price_hour": 23, "vehicle_type": "Hatchback"}]}	2020-08-04
99	{"vehicle": [{"color": ["Indigo", "Grey", "Blue", "Silver"], "seats": 8, "car_make": "Volkswagen", "quantity": 5, "car_model": "Passat", "price_day": 193, "price_hour": 25, "vehicle_type": "Sedan"}]}	2020-08-04
100	{"vehicle": [{"color": ["Blue", "Pink", "Black", "Grey"], "seats": 8, "car_make": "Aston Martin", "quantity": 8, "car_model": "DBS", "price_day": 140, "price_hour": 34, "vehicle_type": "Van"}]}	2020-08-04
103	{"vehicle": [{"color": ["Purple", "Blue", "Black", "Orange"], "seats": 5, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban", "price_day": 229, "price_hour": 34, "vehicle_type": "Truck"}]}	2020-08-04
105	{"vehicle": [{"color": ["Blue", "Purple", "Black", "Grey"], "seats": 6, "car_make": "Porsche", "quantity": 8, "car_model": "928", "price_day": 152, "price_hour": 35, "vehicle_type": "Truck"}]}	2020-08-04
107	{"vehicle": [{"color": ["Purple", "Blue", "Grey", "Indigo"], "seats": 8, "car_make": "Buick", "quantity": 6, "car_model": "Century", "price_day": 297, "price_hour": 31, "vehicle_type": "Truck"}]}	2020-08-04
108	{"vehicle": [{"color": ["Grey", "Blue", "Pink", "Silver"], "seats": 8, "car_make": "Isuzu", "quantity": 6, "car_model": "Ascender", "price_day": 279, "price_hour": 44, "vehicle_type": "SUV"}]}	2020-08-04
109	{"vehicle": [{"color": ["Purple", "Pink", "Blue", "White"], "seats": 7, "car_make": "Lotus", "quantity": 7, "car_model": "Esprit", "price_day": 147, "price_hour": 16, "vehicle_type": "Truck"}]}	2020-08-04
110	{"vehicle": [{"color": ["White", "Silver", "Blue", "Indigo"], "seats": 3, "car_make": "Infiniti", "quantity": 6, "car_model": "QX", "price_day": 162, "price_hour": 25, "vehicle_type": "Van"}]}	2020-08-04
113	{"vehicle": [{"color": ["Orange", "Indigo", "Grey", "Blue"], "seats": 7, "car_make": "Mercedes-Benz", "quantity": 6, "car_model": "S-Class", "price_day": 271, "price_hour": 48, "vehicle_type": "Hatchback"}]}	2020-08-04
117	{"vehicle": [{"color": ["Indigo", "Blue", "Black", "Orange"], "seats": 8, "car_make": "Chevrolet", "quantity": 9, "car_model": "Aveo", "price_day": 244, "price_hour": 31, "vehicle_type": "Hatchback"}]}	2020-08-04
119	{"vehicle": [{"color": ["Silver", "Blue", "Indigo", "Pink"], "seats": 3, "car_make": "Maserati", "quantity": 6, "car_model": "Quattroporte", "price_day": 186, "price_hour": 19, "vehicle_type": "Truck"}]}	2020-08-04
120	{"vehicle": [{"color": ["Blue", "Purple", "Pink", "Black"], "seats": 3, "car_make": "Ford", "quantity": 7, "car_model": "Escort", "price_day": 211, "price_hour": 43, "vehicle_type": "Sedan"}]}	2020-08-04
125	{"vehicle": [{"color": ["Black", "Grey", "Blue", "Indigo"], "seats": 5, "car_make": "Pontiac", "quantity": 5, "car_model": "Sunbird", "price_day": 169, "price_hour": 26, "vehicle_type": "SUV"}]}	2020-08-04
126	{"vehicle": [{"color": ["White", "Indigo", "Black", "Blue"], "seats": 5, "car_make": "Nissan", "quantity": 5, "car_model": "GT-R", "price_day": 232, "price_hour": 33, "vehicle_type": "Hatchback"}]}	2020-08-04
128	{"vehicle": [{"color": ["Purple", "Grey", "Pink", "Blue"], "seats": 4, "car_make": "Acura", "quantity": 6, "car_model": "MDX", "price_day": 221, "price_hour": 50, "vehicle_type": "Hatchback"}]}	2020-08-04
131	{"vehicle": [{"color": ["Blue", "Indigo", "Pink", "Grey"], "seats": 6, "car_make": "Dodge", "quantity": 9, "car_model": "Dakota Club", "price_day": 221, "price_hour": 19, "vehicle_type": "Truck"}]}	2020-08-04
135	{"vehicle": [{"color": ["Orange", "Black", "Blue", "Purple"], "seats": 4, "car_make": "Subaru", "quantity": 5, "car_model": "SVX", "price_day": 167, "price_hour": 22, "vehicle_type": "Sedan"}]}	2020-08-04
136	{"vehicle": [{"color": ["Pink", "Purple", "Blue", "White"], "seats": 8, "car_make": "Mercury", "quantity": 8, "car_model": "Marquis", "price_day": 185, "price_hour": 34, "vehicle_type": "SUV"}]}	2020-08-04

id	jsontest	create_at
7	{"vehicle": [{"color": ["Purple", "Indigo", "Black", "Pink"], "seats": 4, "car_make": "Mercury", "quantity": 9, "car_model": "Topaz", "price_day": 162, "price_hour": 33, "vehicle_type": "SUV"}]}	2020-08-04
12	{"vehicle": [{"color": ["Pink", "Indigo", "Orange", "Black"], "seats": 8, "car_make": "Lexus", "quantity": 8, "car_model": "ES", "price_day": 275, "price_hour": 25, "vehicle_type": "SUV"}]}	2020-08-04
15	{"vehicle": [{"color": ["Pink", "Indigo", "Blue", "White"], "seats": 7, "car_make": "Ford", "quantity": 5, "car_model": "Escort", "price_day": 157, "price_hour": 28, "vehicle_type": "SUV"}]}	2020-08-04
18	{"vehicle": [{"color": ["Grey", "Black", "Orange", "White"], "seats": 2, "car_make": "Porsche", "quantity": 9, "car_model": "928", "price_day": 268, "price_hour": 28, "vehicle_type": "SUV"}]}	2020-08-04
20	{"vehicle": [{"color": ["Indigo", "Purple", "Grey", "Black"], "seats": 2, "car_make": "Chevrolet", "quantity": 5, "car_model": "Suburban 1500", "price_day": 281, "price_hour": 48, "vehicle_type": "SUV"}]}	2020-08-04
29	{"vehicle": [{"color": ["Silver", "White", "Pink", "Orange"], "seats": 5, "car_make": "Mitsubishi", "quantity": 8, "car_model": "Lancer Evolution", "price_day": 182, "price_hour": 17, "vehicle_type": "SUV"}]}	2020-08-04
31	{"vehicle": [{"color": ["White", "Grey", "Silver", "Orange"], "seats": 6, "car_make": "Ferrari", "quantity": 7, "car_model": "California", "price_day": 238, "price_hour": 21, "vehicle_type": "SUV"}]}	2020-08-04
40	{"vehicle": [{"color": ["Grey", "Orange", "Purple", "Pink"], "seats": 8, "car_make": "Mercury", "quantity": 5, "car_model": "Cougar", "price_day": 179, "price_hour": 21, "vehicle_type": "SUV"}]}	2020-08-04
41	{"vehicle": [{"color": ["Orange", "Blue", "Black", "Pink"], "seats": 7, "car_make": "Dodge", "quantity": 8, "car_model": "Ram Van 2500", "price_day": 186, "price_hour": 46, "vehicle_type": "SUV"}]}	2020-08-04
47	{"vehicle": [{"color": ["Orange", "Grey", "Blue", "Indigo"], "seats": 4, "car_make": "Dodge", "quantity": 5, "car_model": "Dakota Club", "price_day": 156, "price_hour": 49, "vehicle_type": "SUV"}]}	2020-08-04
58	{"vehicle": [{"color": ["Grey", "Orange", "Indigo", "Black"], "seats": 5, "car_make": "GMC", "quantity": 7, "car_model": "Sierra Hybrid", "price_day": 246, "price_hour": 48, "vehicle_type": "SUV"}]}	2020-08-04
69	{"vehicle": [{"color": ["Orange", "Black", "Pink", "Silver"], "seats": 7, "car_make": "Spyker", "quantity": 9, "car_model": "C8 Spyder", "price_day": 253, "price_hour": 41, "vehicle_type": "SUV"}]}	2020-08-04
73	{"vehicle": [{"color": ["Purple", "Blue", "Orange", "Grey"], "seats": 6, "car_make": "Audi", "quantity": 9, "car_model": "Q5", "price_day": 249, "price_hour": 17, "vehicle_type": "SUV"}]}	2020-08-04
74	{"vehicle": [{"color": ["Blue", "Purple", "Silver", "Pink"], "seats": 4, "car_make": "Suzuki", "quantity": 8, "car_model": "Kizashi", "price_day": 215, "price_hour": 38, "vehicle_type": "SUV"}]}	2020-08-04
85	{"vehicle": [{"color": ["Indigo", "Orange", "White", "Pink"], "seats": 8, "car_make": "Mitsubishi", "quantity": 6, "car_model": "Lancer Evolution", "price_day": 230, "price_hour": 37, "vehicle_type": "SUV"}]}	2020-08-04
101	{"vehicle": [{"color": ["Black", "Pink", "Indigo", "Grey"], "seats": 8, "car_make": "Mercedes-Benz", "quantity": 7, "car_model": "400SEL", "price_day": 153, "price_hour": 45, "vehicle_type": "SUV"}]}	2020-08-04
102	{"vehicle": [{"color": ["Indigo", "Grey", "Silver", "Orange"], "seats": 2, "car_make": "Buick", "quantity": 6, "car_model": "Coachbuilder", "price_day": 270, "price_hour": 21, "vehicle_type": "SUV"}]}	2020-08-04
108	{"vehicle": [{"color": ["Grey", "Blue", "Pink", "Silver"], "seats": 8, "car_make": "Isuzu", "quantity": 6, "car_model": "Ascender", "price_day": 279, "price_hour": 44, "vehicle_type": "SUV"}]}	2020-08-04
112	{"vehicle": [{"color": ["White", "Indigo", "Orange", "Purple"], "seats": 2, "car_make": "Dodge", "quantity": 5, "car_model": "Durango", "price_day": 298, "price_hour": 24, "vehicle_type": "SUV"}]}	2020-08-04
118	{"vehicle": [{"color": ["Black", "Pink", "Orange", "Purple"], "seats": 6, "car_make": "GMC", "quantity": 6, "car_model": "1500", "price_day": 206, "price_hour": 18, "vehicle_type": "SUV"}]}	2020-08-04
125	{"vehicle": [{"color": ["Black", "Grey", "Blue", "Indigo"], "seats": 5, "car_make": "Pontiac", "quantity": 5, "car_model": "Sunbird", "price_day": 169, "price_hour": 26, "vehicle_type": "SUV"}]}	2020-08-04
127	{"vehicle": [{"color": ["Pink", "Orange", "White", "Black"], "seats": 2, "car_make": "Ford", "quantity": 5, "car_model": "Explorer", "price_day": 149, "price_hour": 35, "vehicle_type": "SUV"}]}	2020-08-04
130	{"vehicle": [{"color": ["Pink", "Silver", "Orange", "White"], "seats": 6, "car_make": "Ford", "quantity": 7, "car_model": "Focus", "price_day": 195, "price_hour": 15, "vehicle_type": "SUV"}]}	2020-08-04
136	{"vehicle": [{"color": ["Pink", "Purple", "Blue", "White"], "seats": 8, "car_make": "Mercury", "quantity": 8, "car_model": "Marquis", "price_day": 185, "price_hour": 34, "vehicle_type": "SUV"}]}	2020-08-04