这回答了最初的问题标记为MySQL。
您不需要只提取月份，而是需要将其与年份结合合并，因为您不希望将不同年份的同一个月的销售额混合在一起，因此使用year_month，然后使用monthname()来获得月份的名称：

select 
  monthname(concat(extract(year_month from sldate), '01')) as month, 
  count(sid) as number_sale 
from sale 
group by month
order by number_sale desc

字符串
参见demo。
结果如下：

| month    | number_sale |
| -------- | ----------- |
| February | 2           |
| January  | 2           |
| March    | 1           |
| June     | 1           |

型

select to_char(sldate,'Month') as Month,count(*) as number_sale from sale group by to_char(sldate,'Month') order by count(*) desc这是更简单的解决方案

SELECT TO_CHAR(SLDATE, 'Month') Month, COUNT(SALEID) NUMBER_SALE FROM Sale GROUP BY TO_CHAR(SLDATE, 'Month') ORDER BY NUMBER_SALE DESC

字符串

select to_char(sldate,'Month') Month, 
 count(to_char(sldate,'Month')) NUMBER_SALE
 from sale  group by (to_char(sldate,'Month')) 
 order by  NUMBER_SALE desc

字符串
1.显示销售的月份和该月份完成的销售数量，按销售额降序排列。

输出

MONTH   NUMBER_SALE
January     2
February    2
March       1
June        1

型

select to_char(sldate,'Month') as month,count(sid) as NUMBER_SALE from sale 
  group by to_char(sldate,'Month') 
order by NUMBER_SALE desc

字符串

检查下面的查询

SELECT TO_CHAR(SLDATE,'Month')"MONTH", COUNT(SID) AS NUMBER_SALE
FROM SALE
GROUP BY TO_CHAR(SLDATE,'Month')
ORDER BY COUNT(SID) DESC

字符串