תמחור מוצרים תחרותי

SELECT
  product_view.id, product_view.title, product_view.brand,
  product_view.price_micros, product_view.currency_code,
  price_competitiveness.country_code,
  price_competitiveness.benchmark_price_micros,
  price_competitiveness.benchmark_price_currency_code
FROM PriceCompetitivenessProductView

{
  "results": [
    {
      "productView": {
        "id": "online:en:US:12345",
        "title": "UGG Women's s Classic Mini",
        "brand": "UGG",
        "priceMicros": "124990000"
        "currencyCode": "USD"
      }
      "priceCompetitiveness": {
        "countryCode": "US",
        "benchmarkPriceMicros": "119922291",
        "benchmarkPriceCurrencyCode": "USD"
      }
    },
    {
      "productView": {
        "id": "online:en:US:12346",
        "title": "Nike React Infinity Run Flyknit 2",
        "brand": "Nike",
        "priceMicros": "119990000"
        "currencyCode": "USD"
      }
      "priceCompetitiveness": {
        "countryCode": "US",
        "benchmarkPriceMicros": "173436840",
        "benchmarkPriceCurrencyCode": "USD"
      }
    },
    {
      "productView": {
        "id": "online:en:US:12347",
        "title": "New Balance 327 White Trainers",
        "brand": "New Balance",
        "priceMicros": "84990000"
        "currencyCode": "USD"
      }
      "priceCompetitiveness": {
        "countryCode": "US",
        "benchmarkPriceMicros": "85459050",
        "benchmarkPriceCurrencyCode": "USD"
      }
    }
  ]
}