一条SQL实现根据某个字段按月份/年份统计数据

需求：按照VALID_TIME统计每个月内的数据。(时间戳类型)

SELECT (FROM_UNIXTIME(VALID_TIME/1000,'%Y-%m')) AS m, count(SALEORDER_NO)
FROM T_SALEORDER
GROUP BY m

如果按照年份统计，则改为：

SELECT (FROM_UNIXTIME(VALID_TIME/1000,'%Y')) AS m, count(SALEORDER_NO)
FROM T_SALEORDER
GROUP BY m

其余同理。

正常时间类型：

SELECT (DATE_FORMAT(VALID_TIME/1000,'%Y-%m')) AS m, count(SALEORDER_NO)
FROM T_SALEORDER
GROUP BY m