select      t.name     ,t.course     ,max(t.score)     ,min(t.score)     ,avg(t.score) from (      select name,course,score     from stdent_score  LATERAL VIEW explode(score) t AS course, score )t
点赞 1

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务