我正在配置单元中执行自联接，并对联接条件中包含的窗口进行聚合（百分比），但遇到以下错误-
第一个
代码如下所示-

SELECT
      a.id
    , a.date
    , a.groups
    , a.items
    , PERCENTILE_APPROX(b.quantity, 0.75) AS rolling_percent_75
  FROM (
    SELECT
      DISTINCT
      id
    , date
    , groups
    , items
    FROM
      table1) AS a
  LEFT OUTER JOIN
    table1 AS b
  ON
        a.id         = b.id
    AND a.groups     = b.groups
    AND a.items      = b.items
    AND b.date      >= DATE_FORMAT(DATE_ADD(DATE_PARSE(a.date, 'yyyyMMdd'), -10, 'yyyyMMdd'))   
    AND b.date      <= a.date   
  GROUP BY
    1, 2, 3, 4
  ORDER BY
    1, 2, 3, 4

如何解决这些错误？