select user_grade,round(count(user_grade)/sum(count(user_grade))over(),2) as ratio from( select case when f_date<date_sub(max_date,interval 6 day) and r_date between date_sub(max_date,interval 6 day) and max_date then '忠实用户' when f_date between date_sub(max_date,interval 6 day...
