[6.0.0-RC2] >>Group remaining as "Others"<< generates an incorrect SQL Query #35815

SELECT
  DATE_TRUNC(creation_date, DAY) AS creation_date,
  destination_table_id AS destination_table_id,
  sum(total_costs) AS SUM_total_costs__c069f
FROM project_id.stg_bigquery_metadata.stg_bigquery_metadata__costs_per_table_per_user
JOIN (
  SELECT
    destination_table_id AS destination_table_id__,
    sum(total_costs) AS mme_inner__
  FROM project_id.stg_bigquery_metadata.stg_bigquery_metadata__costs_per_table_per_user
  WHERE
    creation_date >= CAST('2025-09-25' AS DATE)
    AND creation_date < CAST('2025-10-24' AS DATE)
  GROUP BY
    destination_table_id__
  ORDER BY
    sum(total_costs) DESC
  LIMIT 10
) AS series_limit
  ON destination_table_id = destination_table_id__
WHERE
  creation_date >= CAST('2025-09-25' AS DATE)
  AND creation_date < CAST('2025-10-24' AS DATE)
GROUP BY
  creation_date,
  destination_table_id
ORDER BY
  SUM_total_costs__c069f DESC
LIMIT 10000

SELECT
  DATE_TRUNC(creation_date, DAY) AS creation_date,
  CASE
    WHEN (
      NOT series_limit.destination_table_id__ IS NULL
    )
    THEN destination_table_id
    ELSE 'Others'
  END AS destination_table_id,
  sum(total_costs) AS SUM_total_costs__c069f
FROM project_id.stg_bigquery_metadata.stg_bigquery_metadata__costs_per_table_per_user
LEFT OUTER JOIN (
  SELECT
    destination_table_id AS destination_table_id__,
    sum(total_costs) AS mme_inner__
  FROM project_id.stg_bigquery_metadata.stg_bigquery_metadata__costs_per_table_per_user
  WHERE
    creation_date >= CAST('2025-09-25' AS DATE)
    AND creation_date < CAST('2025-10-24' AS DATE)
  GROUP BY
    destination_table_id__
  ORDER BY
    sum(total_costs) DESC
  LIMIT 10
) AS series_limit
  ON destination_table_id = destination_table_id__
GROUP BY
  creation_date,
  CASE
    WHEN (
      NOT series_limit.destination_table_id__ IS NULL
    )
    THEN destination_table_id
    ELSE 'Others'
  END