SQL-Mini-Project-Make-Theme

SQL-Mini-Project-Make-Theme

SQL을 학습하면서 Outer join이 이해되지 않았습니다. 그래서 팀원 한명과 함께 문제를 만들어보면 이해가 되지 않을까라는 생각에 문제를 만들어 봤습니다.

Outer join was not understood while learning SQL. So I thought it would be understandable if I made a problem with one of my team members.

Student table

Professor table

Question1

Question2

Question1 Answer

select s.name, snumber, sdepartment, p.name 
from student s, professor p 
where s.pnumber = p.pnumber(+);

Question2 Answer

select s.name, p.name, s.pnumber 
from student s, professor p
where s.pnumber = p.pnumber(+);