sql按年、季度、月统计实现

#按年统计
SELECT SUM(browseNum) AS browseNum, COUNT(*) AS sheets FROM sbsm_count_picture GROUP BY DATE_FORMAT(DATE, '%Y');
#按月统计
SELECT SUM(browseNum) AS browseNum,SUM(downloadNum) AS downloadNum,SUM(telBrowseNum) AS telBrowseNum,DATE_FORMAT(DATE, '%Y-%m'),
SUM(telDownloadNum) AS telDownloadNum,
COUNT(*) AS sheets FROM sbsm_count_picture GROUP BY DATE_FORMAT(DATE, '%Y-%m');
#按季度统计
SELECT SUM(browseNum) AS browseNum,SUM(downloadNum) AS downloadNum,SUM(telBrowseNum) AS telBrowseNum,
CONCAT(DATE_FORMAT(DATE, '%Y'),FLOOR((DATE_FORMAT(DATE, '%m')+2)/3)) AS jidu,
SUM(telDownloadNum) AS telDownloadNum,
COUNT(*) AS sheets FROM sbsm_count_picture GROUP BY CONCAT(DATE_FORMAT(DATE, '%Y'),FLOOR((DATE_FORMAT(DATE, '%m')+2)/3));