select
    substring_index (substring_index (profile, ',', '3'), ',', '-1') age,
    count(device_id) number
from
    user_submit
group by
    1

substring_index的复合函数使用