select device_id,nick_name,char_length(nick_name) as nick_len
from user_submit
where char_length(nick_name)>4
order by device_id desc