高级sql_4上机答案

1.
use studentDB
update students set sex='女'
select*from students where age>(select age from students where sname='张三')
2.
use studentDB
select sname from students where sno in(select sno from scores where lno='01')
3.
use studentDB
select sname from students where sno in (select sno from scores)
4.
update students set age=age+1
where sno not in (select sno from scores)
5.
select lname from lessons where lno not in (select lno from scores)
6.
if (exists (select * from scores where score>80))
update scores set score=score+2
else
update scores set score=score+1
7.
if (not exists (select * from scores where score>60))
update scores set score=score+3
else
update scores set score=score+1
8.
if ( exists (select * from scores where score>60))
update scores set score=score+0
else
update scores set score=score+2



1.
use libraryDB
select bname from books where pubdate>(select pubdate from books where bno='001')
2.
select rname,department from readers where rno in(select rno from borrows where bno='001')
3.
select
bname from books where bno not in (select bno from borrows)
4.
select rname from readers where rno not in(select rno from borrows)
5.