【正确答案】1)SELECT DISTICT DEPARTMENT FROMTEACHER;
2)SELECT* FROM STUDENT WHERE CLASS=‘95031’OR SEX=‘女’；
3)SELECT* FROM SCORE ORDER BY CNOASC，DEGREE DESC;
4)SELECT COUNT(*) FROM STUDENTWHERE CLASS=‘95031’：
5)SELECT CNO, AVG(DEGREE) FROM SCORE WHERE CNO like‘3%’ GROUP BY CNO HAV-ING COUNT(*)＞5；
6)SELECT SNO FROM SCORE GROUP BY SNOMIN(DEGREE＞70 AND MAX(DEGREE)＜90;
7)SELECT X.CNO,X.SNO,X.DEGREE FROMSCORE X,SCORE Y WHERE X.CNO=‘3-105’ANDX. CNO=Y.CNO AND Y.SNO=‘109’ANDX.DEGREE＞Y.DEGREE：
8)SELECT A.SNO,A.DEGREE,A.CNO FROMSCORE A, SCORE B WHERE A.SNO=B.SNO ANDA.DEGREE＜B.DEGREE：
9)SEIECT SNO, SNAME,BIRTHDAY FROMSTUDENT WHERE YEAR(BIRTHDAY)=(SELECTYEAR(BIRTHDAY)FROM STUDENT WHERE SNO=“108”)：
10)SELECT CNO, SNO, DEGREE FROM SCORE WHERE CNO=(SELECT X.CNO FROM COURSEX, TEACHER Y WHERE X.TNO=Y.TNO ANDY．TNAME=‘张三’)。

【答案解析】[解析] 主要考查了SQL的数据查询功能、数据定义功能和数据操纵功能。这类问题主要是考查对SE-LECT FROM WHERE语句的掌握。