第一种:常规操作SELECT SUM(ddd) AS count_days, CASEWHEN aa.days >= 1AND aa.days < 3 THEN '1-3'WHEN aa.days >= 3AND