Hive sql 初级题 04
(数据在Hive sql 初级题 01)查询所有课程成绩均小于60分的学生的学号、姓名select s.stu_id,s.stu_name
from (select stu_id,sum(if(score > 60, 1, 0)) flagfrom score_infogroup by stu_idhaving flag 0) t1join student_info s on s.stu_id t1.…
2026/6/25 13:41:03