select substring(profile,12,2) as age,count(device_id) as number
from user_submit
group by age 
order by age desc

substring的应用