先看代码:
strSQL = "select b.TeacherName,sum(case b.Satisfaction when 'A' then 1 else 0 end) as best," strSQL = "select b.TeacherName,sum(