select s.name from student s inner join depart d on s.depart_number = d.depart_number where d.depart_name = '건축학과';
select p.p_name from professor p inner join student s on p.depart_number = s.depart_number where s.name = '차태 원';
select p.p_name from professor p inner join depart d on p.depart_number = d.depart_number where d.depart_name = '언어교육학과';
select d.depart_name, p.p_name from student s inner join depart d on s.depart_number = d.depart_number inner join professor p on d.depart_number = p.depart_number where s.name = '김향기';
select p.p_number, m_value from student s inner join depart d on s.depart_number = d.depart_number inner join professor p on d.depart_number = p.depart_number where s.name = '박성웅';
select d.depart_name, d.b_value from student s inner join depart d on s.depart_number = d.depart_number where s.name = '주지훈';
select name from student where address = (select address from student where name = '하정우');
select name from student where grade = (select grade from student where name = '차태원');
select name from student where address = (select address from student where name = '강동원') and grade != (select grade from student where name = '강동원');
select name, depart_number from student where address = (select address from student where name = '송강호') and grade > (select grade from student where name = '송강호');
select p.p_name from student s inner join professor p on s.depart_number = p.depart_number where address = (select address from student where name = '이정재');
select d.depart_name from student s inner join depart d on s.depart_number = d.depart_number where s.grade = (select grade from student where name = '송강호');
select p.p_name, p.p_number, d.depart_name from student s inner join depart d on s.depart_number = d.depart_number inner join professor p on p.depart_number = d.depart_number where grade = (select grade from student where name = '박성웅');
select d.depart_name, d.m_value, d.b_value from student s inner join depart d on s.depart_number = d.depart_number where grade > (select grade from student where name = '황정민');