sdf

1．

SELECT * FROM uDept

2.

SELECT did, dname FROM uDept

3.

SELECT tid, tname, tsexy FROM uTeacher WHERE tsexy='女'

4.

SELECT * FROM uTeacher WHERE did = 'CS'

5.

SELECT * FROM uTeacher WHERE did = 'CS' or did = 'IT'

6.

SELECT tname, tsexy, tprof, did FROM uTeacher WHERE tprof='教授' and tsexy='女'

8.

SELECT tname, tbdate FROM uTeacher WHERE 2009-year(tbdate) <=30

9.

SELECT tname, tsexy, tbdate, tele FROM uTeacher WHERE month(tbdate) = 5

10.

SELECT * FROM uTeacher WHERE substring(tname,1,1)='李'

 

11.

SELECT sid FROM uSC WHERE cid=1

12.

SELECT sid, cid FROM uSC WHERE cid=1 or cid=3

13.

SELECT cid FROM uSC WHERE sid=012005001

14.

SELECT cid FROM uSC WHERE sid=012005001

15.

 SELECT sid,cid, score2 AS score FROM uSC WHERE score2<60

20.

SELECT room FROM uJobTable WHERE week=4

21.

SELECT tid FROM uJobTable WHERE week=4

22.

SELECT * FROM uJobTable WHERE room='NB222'

23.

SELECT room,tid,week,timeseg FROM uJobTable WHERE cid=1

24.

SELECT room,tid,week,timeseg FROM uJobTable WHERE tid=02004

29.

SELECT Cname FROM uCourse WHERE did='CS'

30.

SELECT Cname, credit  FROM uCourse WHERE credit>3

32.

SELECT *  FROM uStudent WHERE Ssexy='男'

33.

SELECT *  FROM uStudent WHERE gid='01'

34.

SELECT *  FROM uStudent WHERE gid='03' and Ssexy='女'

35.

SELECT Sid, Sname, gid, stele  FROM uStudent WHERE Sname='刘山'

36.

SELECT Sid, Sname, gid  FROM uStudent WHERE Ssexy='女'

45.

SELECT gname, gyear FROM uGrade WHERE did='CS'

46.

SELECT * FROM uGrade WHERE gyear=2008