SQL查询题目

SQL查询题目

2:select * from student
order by sno desc

1、select * from score where score.grade between 60 and 80

1、select * from score where grade between 60 and 80;
2、select * from student order by sno;
3、select a.name,b.cname,c.grade from Student a,Course b,Score c where a.sno=c.sno and b.cno=c.cno;
4、select a.name,b.cname,c.grade from Studen a,Course b,Score c where b.tno=(select tno from Teacher where name='张旭') and a.sno=c.sno and b.cno=c.cno;
5、select cno from Score where grade>=85;
6、select class from Student where class in (select class from Student where sex='男' group by class having count(*)>=10);
7、select a.name,b.cname from Teacher a,Course b where a.sex='男' and a.tno=b.tno;
8、select name from Student where sex=(select sex from Student where name='李军');
9、select a.sno,b.cno,c.grade from Student a,Course b,Score c where a.sex='男' and b.cname='计算机导论' and a.sno=c.sno and b.cno=c.cno;
10、select a.* from Score a,(select cno,avg(grade) avggrade from Score group by cno) b where a.cno=b.cno and a.grade11、select * from Student where class= (select class from Student where name='李军');
12、select sno avg(grade) from Score group by sno having avg(grade)>=90;
终于完了，写的好辛苦啊……