"Math","English","Science"]]David[["Science"]]需求2:如果本身表就是踩坑1的,表名是 temp,对字符串类型的courses展开,变成一行数据是每一个同学和一个科目...select name,coursefrom ( select name ,array_agg(courses) as courses from student group...数据是学生和课程组合起来的。...Science","Math, Science"]Emma["Math","English","Science","Math, English,Science"]David["Science"]需求8:如何排序呢...select t1.name,array_sort(t1.courses) as coursesfrom( select name,array_agg(courses) as courses