محصولات برتر را شناسایی کنید

SELECT
  best_sellers.report_date, best_sellers.report_granularity,
  best_sellers.country_code, best_sellers.category_id,
  best_sellers.rank, best_sellers.previous_rank,
  best_sellers.relative_demand, best_sellers.previous_relative_demand,
  best_sellers.relative_demand_change,
  product_cluster.title, product_cluster.brand, product_cluster.category_l1,
  product_cluster.category_l2, product_cluster.category_l3, 
  product_cluster.variant_gtins, product_cluster.inventory_status, 
  product_cluster.brand_inventory_status
FROM BestSellersProductClusterView
WHERE best_sellers.report_date = '2022-10-10'
  AND best_sellers.report_granularity = 'WEEKLY'
  AND best_sellers.country_code = 'US'
  AND best_sellers.category_id = 166
ORDER BY best_sellers.rank

{
  "results": [
    {
      "bestSellers": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "countryCode": "US",
        "categoryId": "166"
        "rank": "1",
        "previousRank": "1",
        "relativeDemand": "VERY_HIGH",
        "previousRelativeDemand": "VERY_HIGH",
        "relativeDemandChange": "FLAT"
      }
      "productCluster": {
        "title": "Ugg Shoes Ugg Tasman",
        "brand": "UGG",
        "categoryL1": "Apparel & Accessories",
        "categoryL2": "Shoes",
        "categoryL3": "",
        "variantGtins":
            ["00737872992873", "00737872992880", "00737872992866"],
        "inventoryStatus": "NOT_IN_INVENTORY",
        "brandInventoryStatus": "NOT_IN_INVENTORY"
      }
    },
    {
      "bestSellers": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "countryCode": "US",
        "categoryId": "166"
        "rank": "2",
        "previousRank": "8",
        "relativeDemand": "VERY_HIGH",
        "previousRelativeDemand": "HIGH",
        "relativeDemandChange": "RISER"
      }
      "productCluster": {
        "title": "UGG Women's s Classic Mini",
        "brand": "UGG",
        "categoryL1": "Apparel & Accessories",
        "categoryL2": "Shoes",
        "categoryL3": "",
        "variantGtins":
            ["00194715081314", "00194715081246", "00194715081321"],
        "inventoryStatus": "NOT_IN_INVENTORY",
        "brandInventoryStatus": "NOT_IN_INVENTORY"
      }
    },
    {
      "bestSellers": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "countryCode": "US",
        "categoryId": "166"
        "rank": "3",
        "previousRank": "2",
        "relativeDemand": "VERY_HIGH",
        "previousRelativeDemand": "VERY_HIGH",
        "relativeDemandChange": "FLAT"
      }
      "productCluster": {
        "title": "Crocs Classic",
        "brand": "Crocs",
        "categoryL1": "Apparel & Accessories",
        "categoryL2": "Shoes",
        "categoryL3": "",
        "variantGtins":
            ["00887350811209", "00191448903852", "00191448769090"],
        "inventoryStatus": "NOT_IN_INVENTORY",
        "brandInventoryStatus": "OUT_OF_STOCK"
      }
    }
  ]
}