SELECT product.name, product.unitPrice, product.categories FROM product UNNEST product.categories AS categories WHERE categories ="Appliances" AND product.unitPrice <6.99
结果:
{"results": [ {"categories": ["Appliances" ],"name":"Ball Cap Buddy","unitPrice":5.61 } ]}