select device_id,
substring_index(blog_url,'/',-1)
from user_submit
#group by device_id

有聚合函数的情况下才需要group by