请显示用户性别、电影名称、评分
select b.gender, c.title, a.ratings
from ratings a
inner join users b
on a.user_id = b.user_id
inner join movies c
on a.movie_id = c.movie_id
limit 5;
请显示用户职业、用户年龄段、电影名称、评分
select b.gender, e.occup_title, d.age_min, d.age_max as age_scope, c.title, a.ratings
from ratings a
inner join users b
on a.user_id = b.user_id
inner join movies c
on a.movie_id = c.movie_id
inner join age_dict d
on b.age = d.age_id
inner join occup_dict e
on b.occupation = e.occup_id
limit 5;
求每部电影平均得分 （电影名称，平均得分）
select c.title, avg(a.ratings) as avg_rating
from ratings a
inner join movies c
on a.movie_id = c.movie_id
group by c.title
limit 10;
求每部电影男的平均分，女的平均分
select c.title, b.gender, avg(a.ratings) as avg_rating
from ratings a
inner join users b
on a.user_id = b.user_id
inner join movies c
on a.movie_id = c.movie_id
group by c.title, b.gender
limit 10;
显示平均分大于4分的电影名称，用子查询
select * from movies
where movie_id in
(select movie_id
from ratings
group by movie_id
having avg(ratings) > 4);
day05 mysql查询语句
最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
- 文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
- 文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
- 文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
