MySQL按 年/季度/月/天分组

按年分组：

  SELECT COUNT(buy_mount),DATE_FORMAT(DAY,'%Y') 
  FROM 
           tianchi_mum_baby_trade_history
  GROUP BY 
           DATE_FORMAT(DAY,'%Y')
  ORDER BY
           DATE_FORMAT(DAY,'%Y');

按季度分组：

SELECT COUNT(buy_mount),SUBSTR(`day`,1,4) ,QUARTER(DAY) 
  FROM 
           tianchi_mum_baby_trade_history
  GROUP BY 
           SUBSTR(`day`,1,4) ,
           QUARTER(DAY)
  ORDER BY
           SUBSTR(`day`,1,4) ,
           QUARTER(DAY);

按月分组：

 SELECT  DATE_FORMAT(`day`, '%Y-%m' ) ,COUNT( buy_mount) 
 FROM
          tianchi_mum_baby_trade_history
 GROUP BY 
          DATE_FORMAT( `day`, '%Y-%m' ) 
 ORDER BY 
          DATE_FORMAT( `day`, '%Y-%m' );

按天分组：

SELECT  DATE_FORMAT( `day`, '%Y-%m-%d' ) ,COUNT(buy_mount)
FROM 
    tianchi_mum_baby_trade_history
GROUP BY 
    DATE_FORMAT( `day`, '%Y-%m-%d' ) 
ORDER BY 
    DATE_FORMAT( `day`, '%Y-%m-%d' );