Hive sql 初级题 05
查询平均成绩大于85的所有学生的学号、姓名和平均成绩select
student_info.stu_id,stu_name,avg(score) avg
from student_info left join score_info on score_info.stu_idstudent_info.stu_id
group by student_info.stu_id,stu_name having avg>85;查询学生的选课情况&am…
2026/7/9 2:10:51