10.05.04 DB 실습

select sname,dept

from student

where exists

          (select *

           from enrol

           where sno = student.sno

                      and cno='c312' and grade='A');

select sname, s.dept

from student s, enrol e, course c

where s.sno=e.sno and c.cno=e.cno

         and cname='자료구조' and grade='A'

 

select sno

from student

where year=1

union

select sno

from enrol

where cno = 'c324'

select sno

from student

where year=1

intersect

select sno

from enrol

where cno = 'c324'

insert

into computer(sno,sname,year)

select sno,sname,year

from student

where sno=3703 and '서정회' and year=3

select *

from computer;