摘要： select c.student_id,c.chinese_name, sum(a.absence) absence_total,sum(a.credit) get_course_total,sum(a.coursecredit) reg_course_total ,(select credit from sm_grade_credit where grade=11)from sm_course_student a,sm_courses b,sm_students c where a.course_id=b.courseid and a.student_id=c.student_id and 阅读全文