查询全体学生的姓名及其出生年份 （数据库）

1:select name,age from student;2:select major_num from student where major='计算机专业';3:select*from student where age>19;4:select name,ID from stduent where major='.';5:select name,age from student where sex='男' or age>19
6:select name,ID,sex from student where name like '王%'
7:select name,ID,sex from student where name NOT like '王%'
8:select name,ID,sex from student where name NOT like '_佳%'
9:select name,age,major where age like[18-25]
10:select name,age,major where age NOT like[18-25]
11:select*from student where name=(select major from student
where name='王涛')
12:select ID,name from student where major_id=001
13:select ID,name from student where major_id<>001
14:select*from student where zhuanyechengji>80
15:select ID,score from student where major_id=001
Order by score DESC
16:select*from student order by age DESC,major
17:
18:select count(*)from student
19:select count(*)from student where EXISTS(select scroe from
student)
20:
21:
22:
其他几道没有把握.就不放出来了