mysql - 如何创建对年份进行分组的查询

Question

我有这个查询:

SELECT Count(tblpeople.PersonID) AS Total, 
     YEAR(CURRENT_TIMESTAMP) - YEAR(tblmembership.MemberSince) AS YearsMember   
FROM tblmembership 
   INNER JOIN tblpeople ON tblmembership.PersonID = tblpeople.PersonID
WHERE 
      tblpeople.MemSTATUS = 'Back from VPM' 
  OR  tblpeople.MemSTATUS = 'Sent To VPM 2' 
  OR  tblpeople.MemSTATUS = 'Sent To VPM 1' 
  OR  tblpeople.MemSTATUS = 'Back from VPM' 
  OR  tblpeople.MemSTATUS = 'Renewal'
  OR  tblpeople.MemSTATUS = 'Active Member'
GROUP BY YearsMember 
HAVING YearsMember
ORDER BY YearsMember

它可以计算人们成为成员(member)的年数。

What has me stumped is the boss wants it broken down by:
0 - 2, 
3 -5, 
6 - 10, 
11 - 20, 
>20

所以每个都很重要。我不知道如何做到这一点，但我确信有办法!

我可以将其导入 Excel 并手动对计数进行分组，但希望一次性完成所有操作。

谢谢

Answer 1

使用 case when 表达式:http://docs.oracle.com/cd/B19306_01/server.102/b14200/expressions004.htm

case when years between 0 and 2 then ... else ...