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