题解 | 推荐内容准确的用户平均评分
select avg(distinct score) avg_score from ( select user_id, hobby_l, score, if(rec_info_l = hobby_l,1,0) 判断 from recommend_tb rt join user_action_tb uat on rt.rec_user = uat.user_id ) a where 判断 = 1
select avg(distinct score) avg_score from ( select user_id, hobby_l, score, if(rec_info_l = hobby_l,1,0) 判断 from recommend_tb rt join user_action_tb uat on rt.rec_user = uat.user_id ) a where 判断 = 1
相关推荐