用SQL语句表达下列操作:1. 查找TAN老师所授课程的课程号和课程名。

设教学数据库有三个基本表

S(SNO, SNAME, SEX, AGE, SDEPT)

C(CNO, CNAME, CDEPT, CREDIT, TNAME)

SC(SNO, CNO, GRADE)

其中SNO为学号，SNAME为学生姓名，AGE为年龄，SEX为性别，SDEPT为学生所在系，CNO为课程号，CNAME为课程名，CDEPT为开课系，CREDIT为学分，TNAME为授课老师姓名，GRADE为成绩。试用SQL语句表达下列操作：

1. 查找TAN老师所授课程的课程号和课程名。

2. 查找TAN、WANG和ZHANG三位老师所授的课程名称及学分。

3. 求男同学的学号、姓名、年龄，并按年龄降序排列。

4. 查找年龄大于20岁的学生的学号和姓名。

5. 求选修了“高等数学”的学生学号和姓名。

6. 求选修了课程码为“0001”的课程的学生姓名。

7. 求和王鹏同学所在系相同的学生的学号，姓名和年龄。

8. 查找至少选修了TAN老师所授课程中一门课程的学生姓名。

9. 查找ZENG同学不学的课程的课程号。

10. 求课程号和选修该课程所对应的人数。

create table student
(sno CHAr(12) NOT NULL UNIQUE,
sname CHAr(20),
ssex CHAr(2),
sage INT,
sdept CHAr(15));

create table course
(cno char(8) NOT NULL UNIQUE,
cname char(4),
cdept char(18),
credit char(2),
cname char(4));

create table sc
(sno char(12) NOT NULL UNIQUE,
cno char(4),
grade char(4));

insert
into student
values('01','王鹏','男 ','20','MA')

insert
into student
values('02','ZENG','男','21','IS')

insert
into student
values('03','汪洋','男','19','CS')

insert
into course
values('1','数学','cs','2','TAN')

insert
into course
values('2','物理','cs','3','WANG')

insert
into course
values('3','计算机','ma','2','ZHANG')

insert
into sc
values('01','1','88')

insert
into sc
values('02','2','98')

insert
into sc
values('03','3','78')

Select cno,cname
From course
where Tname ='TAN';

select cname,credit
From course
WHERe Tname=TAN,WANG,ZHANG;

SELECt sno,sname,sage
From student
order by age desc

SELECt sno,sname
FROM student
WHERe student.age>20;

SELECt sno,sname
FROM student
WHERe sno IN
(select sno
from sc
where cno IN
(select cno
from course
cname='高等数学';

SELECt sname
FROM student
WHERe sno IN
(select sno
from sc
where cno='0001');

select sno,sname,sage
from student
where SDEPT in
(select SDEPT
from course
where sname='王鹏');

select sname
from sc
where s.sno=sc.sno and cno=ANY
(select cno
from course
where tname='TAN');

select cno
from course
where not exists
(select *
from student
where sno=sc.sno
and student.sname='ZENG');

select cno,count(sno)
from sc
GROUP BY CNO

这每个问题需要10分