如何把这4条sql语句组合成一条?

Question

SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 0 AND 18

SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 19 AND 30

SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW()) BETWEEN 31 AND 45

SELECT birthday age, COUNT(*)VALUE FROM t_member WHERE TIMESTAMPDIFF(YEAR,birthday,NOW())>45

Answer 1

between and 是包含边界的，从这些语句的条件来看，最终的返回其实就是 TIMESTAMPDIFF(YEAR,birthday,NOW()) 取值区间是 [0,正无穷），统一为一条SQL 条件为

WHERE TIMESTAMPDIFF(YEAR,birthday,NOW())>=0