不能将列alias添加到group by子句中;使用原始列名或整个表达式：

SELECT 
       -- these are non-aggregated columns (or expressions) which should be
       -- part of the GROUP BY clause:
         p.project_name,
         CASE
            WHEN :p42_date_ranges = 'Monthly'
            THEN
               TO_CHAR (b.date_sys, 'Month')
            WHEN :p42_date_ranges = 'Daily'
            THEN
               TO_CHAR (b.date_sys, 'MM/DD/YYYY')
            WHEN :p42_date_ranges = 'Weekly'
            THEN
               TO_CHAR (TRUNC (b.date_sys, 'IW'), 'MM/DD/YYYY')
         END AS my_date,
         CASE
            WHEN :p42_date_ranges = 'Monthly' THEN TRUNC (b.date_sys, 'MM')
            WHEN :p42_date_ranges = 'Daily' THEN TRUNC (b.date_sys)
            WHEN :p42_date_ranges = 'Weekly' THEN TRUNC (b.date_sys, 'IW')
         END AS dates_,
       --
       -- aggregates
         COUNT (DISTINCT i.id) AS count_of_ingested,
         SUM (hrc.highlighted_count) AS count_of_highlighted,
         SUM (hrc.redacted_count) AS count_of_redacted
    FROM customer c
         INNER JOIN project p ON c.id = p.id_customer
         INNER JOIN batch b ON p.id = b.id_project
         LEFT OUTER JOIN ingested i ON b.id = i.id_batch
         LEFT OUTER JOIN
         (SELECT hc.id AS id_ingested, highlighted_count, redacted_count
            FROM (  SELECT i.id, COUNT (DISTINCT h.id) AS highlighted_count
                      FROM ingested i
                           LEFT OUTER JOIN highlighted h ON i.id = h.id_ingested
                  GROUP BY i.id) hc
                 JOIN
                 (  SELECT i.id, COUNT (DISTINCT r.id) AS redacted_count
                      FROM ingested i
                           LEFT OUTER JOIN redacted r ON i.id = r.id_ingested
                  GROUP BY i.id) rc
                    ON hc.id = rc.id) hrc
            ON i.id = hrc.id_ingested
   WHERE b.date_sys BETWEEN TO_DATE ( :p42_start_date)
                        AND TO_DATE ( :p42_end_date)

和group by子句：

GROUP BY p.project_name,
         CASE
            WHEN :p42_date_ranges = 'Monthly'
            THEN
               TO_CHAR (b.date_sys, 'Month')
            WHEN :p42_date_ranges = 'Daily'
            THEN
               TO_CHAR (b.date_sys, 'MM/DD/YYYY')
            WHEN :p42_date_ranges = 'Weekly'
            THEN
               TO_CHAR (TRUNC (b.date_sys, 'IW'), 'MM/DD/YYYY')
         END,   -- AS my_date,
         CASE
            WHEN :p42_date_ranges = 'Monthly' THEN TRUNC (b.date_sys, 'MM')
            WHEN :p42_date_ranges = 'Daily' THEN TRUNC (b.date_sys)
            WHEN :p42_date_ranges = 'Weekly' THEN TRUNC (b.date_sys, 'IW')
         END;   -- AS dates_