我有一组数据,我想显示过去12个月每月的交易,按月份分组和排序。
我的代码当前为:
SELECT
to_char(orderdate, 'MM-YYYY') AS MONTH_AND_YEAR
,SUM(VALUE) AS TOTAL_SALES
,ROUND(AVG(VALUE),2) AS AVERAGE_SALE_VALUE
,MIN(VALUE) AS MINIMUM_SALE_VALUE
,MAX(VALUE) AS MAXIMUM_SALES_VALUE
FROM ORDER_TABLE
WHERE OrderDate >= ADD_MONTHS( TRUNC(SYSDATE), -12 )
GROUP BY to_char(orderdate, 'MM-YYYY')
ORDER BY to_char(orderdate, 'MM-YYYY') DESC;
但是他回来了:
月份和年份
12-2021
12-2020
11-2021
11-2020
10-2021
10-2020
09-2021
09-2020
08-2021
08-2020
07-2020
06-2020
05-2021
05-2020
04-2021
04-2020
03-2021
03-2020
02-2020
01-2021
01-2020
帮助:
最大(订单日期)
最小值(订单日期)
2021-12-01 00:00:00
2020-01-02 00:00:00
谢谢你的帮助和建议