题解 | #用户昵称超长的用户#

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