برندهای برتر را شناسایی کنید

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, brand.name
FROM BestSellersBrandView
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"
      }
      "brand": {
        "name": "Nike",
      }
    },
    {
      "bestSellers": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "countryCode": "US",
        "categoryId": "166"
        "rank": "2",
        "previousRank": "2",
        "relativeDemand": "HIGH",
        "previousRelativeDemand": "HIGH",
        "relativeDemandChange": "FLAT"
      }
      "brand": {
        "name": "SHEIN"
      }
    },
    {
      "bestSellers": {
        "reportDate": "2022-10-10",
        "reportGranularity": "WEEKLY",
        "countryCode": "US",
        "categoryId": "166"
        "rank": "3",
        "previousRank": "4",
        "relativeDemand": "HIGH",
        "previousRelativeDemand": "HIGH",
        "relativeDemandChange": "FLAT"
      }
      "brand": {
        "name": "adidas"
      }
    }
  ]
}