SELECT user_grade, round(count(uid)/(select count(distinct uid) from tb_user_log),2) ratio FROM (SELECT uid, (CASE WHEN DATEDIFF(DATE((SELECT MAX(in_time) FROM tb_user_log)),date(max(in_time)))<=6 AND DATEDIFF(DATE((SELECT MAX(in_time) FROM tb_user_log)),date(min(in_time)...