如何更改此查询以显示此格式的数据
01-18 2000
01-19 4000
02-18 3000
02-19 1000
这是我的语法,但因为它是联合我不能使用 order by 子句
SELECT DATE_FORMAT(salesdate, "%m-%Y") AS Month, employeeName, SUM(saleAmount)
FROM prevyear
WHERE BDM = 'Jason Hernandez'
GROUP BY DATE_FORMAT(salesdate, "%m-%Y"), employeeName
UNION ALL
SELECT DATE_FORMAT(salesdate, "%m-%Y") AS Month, employeeName, SUM(saleAmount)
FROM curryear
WHERE BDM = 'Jason Hernandez'
GROUP BY DATE_FORMAT(salesdate, "%m-%Y"), employeeName