SELECT
  month,
  inStock,
  COUNT(*) KolPlitok
FROM (
  SELECT
    month,
    dr.name_ru zapchast,
    type_id,
    COUNT (DISTINCT clientId) clients,
    LEAST(12, MAX(in_stock)) inStock
  FROM (
    SELECT
      LPAD(_TABLE_SUFFIX, 6) month,
      clientId,
      (SELECT value FROM UNNEST(customGroups) WHERE index = 3) AS zapchast,
      SPLIT(page.pagePath, "/")[SAFE_OFFSET(3)] type_id,
      IFNULL((SELECT SUM(IF(productVariant="in_stock",1,0)) FROM UNNEST(product)), 0) in_stock
    FROM
      `dokdbroker.OWOXBI_Streaming.streaming_*`
    WHERE true
      AND _TABLE_SUFFIX BETWEEN "20180401" AND "20180431"
      AND type = "pageview"
      AND (SELECT value FROM UNNEST(customGroups) WHERE index = 1) = "inside"
      AND (SELECT value FROM UNNEST(customGroups) WHERE index = 2) = "15"
      AND STARTS_WITH(page.pagepath, "/doc/car")
  ) s
    LEFT JOIN download.dok_razdel dr ON SAFE_CAST(s.zapchast as int64) = dr.id
  WHERE
    zapchast NOT IN ("20", "501", "521", "398")
  GROUP BY
    dr.name_ru, type_id, month
  HAVING
    clients >= 3
)
GROUP BY
  month, inStock