subquery

select name, (select dname from department where STUDENT.DEPTNO1 =DEPARTMENT.DEPTNO) from student where deptno1 = (select deptno1 from Student where '이윤나'=name)