human 我的表结构STCD 主键 国家统一测站编码TM数据接受日期DRP 接收时间雨量值我现在想月之和并显示单日最大值给我sql语句我的日期格式是这样的yyyy-mm-dd hhmm00000;; AI SELECT DATE_FORMATTM Y-m AS 月份 MAXDRP AS 单日最大值 SUMDRP AS 月之和FROM STCDWHERE TM BETWEEN 开

AI: '

SELECT CONVERT(VARCHAR(7), TM, 120) AS [月份], MAX(DRP) AS [单日最大值], SUM(DRP) AS [月之和] FROM STCD WHERE TM BETWEEN '开始日期' AND '结束日期' GROUP BY CONVERT(VARCHAR(7), TM, 120)';