题解 | 推荐内容准确的用户平均评分
select round(avg(t.score),3) as avg_score from( select distinct t2.score as score from recommend_tb as t1 inner join user_action_tb as t2 on t1.rec_user = t2.user_id and t1.rec_info_l = t2.hobby_l ) as t;
select round(avg(t.score),3) as avg_score from( select distinct t2.score as score from recommend_tb as t1 inner join user_action_tb as t2 on t1.rec_user = t2.user_id and t1.rec_info_l = t2.hobby_l ) as t;
相关推荐