您可以用途：

SELECT TO_CHAR(TRUNC(creation_date, 'Q'), 'YYYY') AS year,
       TO_CHAR(TRUNC(creation_date, 'Q'), 'Q') AS quarter,
       COUNT(item_code) AS total_items
FROM   table_name
WHERE  creation_date >= LAST_DAY(TRUNC(creation_date))
GROUP BY TRUNC(creation_date, 'Q')

其中，对于示例数据：

CREATE TABLE table_name (item_code, Creation_date, location, Item_type) AS
SELECT 1, DATE '2023-01-01', 'x', 'y' FROM DUAL UNION ALL
SELECT 1, DATE '2023-01-31' + INTERVAL '1' HOUR, 'x', 'y' FROM DUAL UNION ALL
SELECT 1, DATE '2023-02-01' + INTERVAL '1' HOUR, 'x', 'y' FROM DUAL UNION ALL
SELECT 1, DATE '2023-02-28' + INTERVAL '1' HOUR, 'x', 'y' FROM DUAL UNION ALL
SELECT 1, DATE '2023-04-28' + INTERVAL '1' HOUR, 'x', 'y' FROM DUAL UNION ALL
SELECT 1, DATE '2023-04-30' + INTERVAL '1' HOUR, 'x', 'y' FROM DUAL UNION ALL
SELECT 1, DATE '2023-04-30' + INTERVAL '2' HOUR, 'x', 'y' FROM DUAL;

输出：
| 年份|季度|总计_项目|
| --------------|--------------|--------------|
| 二零二三年|1|第二章|
| 二零二三年|第二章|第二章|
fiddle