²éѯ°à¼¶Öм°¸ñ£¬Ò»°ã£¬ÓÅÐãµÄÈËÊýµÄsqlÓï¾ä

select a.ClassName,a.CourseName,sum(²»¼°¸ñ) as ²»¼°¸ñ,sum(²î) as ²î,sum(ÖеÈ) as ÖеÈ,sum(ºÃ) as ºÃ ,sum(²»¼°¸ñ)+sum(²î)+sum(ÖеÈ)+sum(ºÃ) as °à¼¶×ÜÈËÊý from (select StudentID,ClassName,CourseName,1 as ²»¼°¸ñ,0 as ²î,0 as ÖеÈ,0 as ºÃ from StudentScore where ScoreRemark='fail' union all
select StudentID,ClassName,CourseName,0 as ²»¼°¸ñ,1 as ²î,0 as ÖеÈ,0 as ºÃ from StudentScore where ScoreRemark='low' union all
select StudentID,ClassName,CourseName,0 as ²»¼°¸ñ,0 as ²î,1 as ÖеÈ,0 as ºÃ from StudentScore where ScoreRemark='medium' union all 
select StudentID,ClassName,CourseName,0 as ²»¼°¸ñ,0 as ²î,0 as ÖеÈ,1 as ºÃ from StudentScore where ScoreRemark='good'  )a group by ClassName,CourseName
      ÔÚÕâÀïÐèҪעÒâµÄÊÇÒª¸øijЩ×ֶμӱðÃûÒÔʾÇø±ð£¡