생년월일로 연령대별 회원수 쿼리

생년월일을 이용하여 10~60대까지 연령대별로 몇명인지 쿼리하기 (BIRTH=YYYYMMDD) 1. select sum(if(date_format(now(),'%Y')-substring(BIRTH,1,4) between 10 and 19 , 1, 0)) as age_10, sum(if(date_format(now(),'%Y')-substring(BIRTH,1,4) between 20 and 29 , 1, 0)) as age_20, sum(if(date_format(now(),'%Y')-substring(BIRTH,1,4) between 30 and 39 , 1, 0)) as age_30, sum(if(date_format(now(),'%Y')-substring(BIRTH,1,4) between 40 and 49 , 1, 0)) as age_40, sum(if(date_format(now(),'%Y')-substring(BIRTH,1,4) between 50 and 59 , 1, 0)...