`select *, update user_level,(select avg(user_total) as avg from user_level) b set user_rank= case when round(user_total/avg)>=1 and round(user_total/avg)<2 then "白金2用户" when round(user_total/avg)>=2 then "1黄金用户"
ELSE "吃瓜" end where user_total>=b.avg`