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