select device_id,
substring_index(blog_url,"/",-1) as user_name
from user_submit