MySQL - join , outer join 실습문제풀이

INSERT INTO students (first_name) VALUES 
('Caleb'), ('Samantha'), ('Raj'), ('Carlos'), ('Lisa');

INSERT INTO papers (student_id, title, grade ) VALUES
(1, 'My First Book Report', 60),
(1, 'My Second Book Report', 75),
(2, 'Russian Lit Through The Ages', 94),
(2, 'De Montaigne and The Art of The Essay', 98),
(4, 'Borges and Magical Realism', 89);

위 데이터들을 가지고 문제풀이 하겠습니다.

 

1.

select s.first_name,p.title,p.grade
from students s
join papers p
on s.id = p.student_id
order by p.grade desc;

2.

select s.first_name,p.title,p.grade
from students s
left join papers p
on s.id = p.student_id;