select count(*),count(全评人数)=(select * from t where 选课门数=评教门数),count(未评教门数)=(select * from t where 评教门数='0'),count(未全评人数)=(select * from t where
评教门数<>'0')
from tablename as t
评教门数<>'0')
from tablename as t
评教门数<>'0')
from tablename as t
FROM TABLE
不知道写的对不对!