SELECT u.age,avg(r.rate) FROM t_rating r,t_user u where r.userid = u.userid and r.movieid = 2116 GROUP BY u.age;
复制代码
截图：
题目 2.
中等：找出男性评分最高且评分次数超过 50 次的 10 部电影，展示电影名，平均影评分和评分次数
解答：
HQL:
SELECT m.moviename, t.avgrate, t.totalFROM t_movie m, ( SELECT r.movieid, avg(r.rate) AS avgrate, count(r.rate) AS total FROM t_rating r, t_user u WHERE r.userid = u.userid AND u.sex = 'M' GROUP BY r.movieid HAVING count(r.rate)>50) AS tWHERE m.movieid = t.movieidORDER BY t.avgrate DESCLIMIT 10;
京公网安备 11010502039052号
评论