我没有你确切的数据，所以很难验证这一点，但我会做一些类似的事情

SELECT COUNT(*)
FROM (
  SELECT a.*
    , flg
  FROM mydata a
  LEFT OUTER JOIN (
    SELECT store_out, flg
    FROM (
      SELECT store_out
        , cnt
        , 1 AS flg
        , AVG(cnt)         OVER () AS avg_cnt
        , STDDEV_SAMP(cnt) OVER () AS std_cnt
      FROM (
        SELECT store AS store_out
          , COUNT(*) AS cnt
        FROM mydata
        GROUP BY store ) x
      ) y
    WHERE cnt > avt_cnt + std_cnt AND cnt < avg_cnt - std_cnt ) z
  ON a.store = z.store_out ) final
WHERE flg IS NULL

基本上，左键联接子查询并创建一个伪列。该列在主表中不存在，因此在所有flg值都为null的情况下，这些是您想要的存储。希望这有帮助。