34.Shopper - 产品categories列表

Don也还想买一个新的日常咖啡杯。

他看着产品类别的目录是否有一个＂杯子＂类别。

有“杯子”类别吗?运行该查询,看看是否有一个。

SELECT 
    DISTINCT categories
    FROM product
    UNNEST product.categories AS categories

结果：

{
  "results": [
    {
      "categories": "Luggage"
    },
    {
      "categories": "Kitchen & Dining"
    },
    {
      "categories": "Bedding & Bath"
    },
    {
      "categories": "Appliances"
    },
    {
      "categories": "Watches"
    },
    {
      "categories": "Arts, Crafts & Sewing"
    },
    {
      "categories": "Home Improvement"
    },
    {
      "categories": "Lamps & Light Fixtures"
    },
    {
      "categories": "Kitchen & Bath Fixtures"
    },
    {
      "categories": "Hardware"
    },
    {
      "categories": "Building Supplies"
    },
    {
      "categories": "Toys & Games"
    },
    {
      "categories": "Baby"
    },
    {
      "categories": "Video Games for Kids"
    },
    {
      "categories": "Pet Supplies"
    },
    {
      "categories": "Exercise & Fitness"
    },
    {
      "categories": "Outdoor Recreation"
    },
    {
      "categories": "Hunting & Fishing"
    },
    {
      "categories": "Cycling"
    },
    {
      "categories": "Fan Shop"
    },
    {
      "categories": "Sports Collectibles"
    },
    {
      "categories": "Golf"
    },
    {
      "categories": "All Sports & Outdoors"
    }
  ]
}