1.
SELECT * from stu inner join score on stu.id = score.stu_id;
2.
select * from stu left join score on stu.id = score.stu_id
3.
select * from stu right join score on stu.id = score.stu_id
4.
select * from stu left join score on stu.id = score.stu_id where score.stu_id is null
5.
select * from stu right join score on stu.id = score.stu_id where stu.id is null
6.
select * from stu left join score on stu.id = score.stu_id UNION select * from stu right join score on stu.id = score.stu_id
7.
select * from stu left join score on stu.id = score.stu_id where score.stu_id is null union select * from stu right join score on stu.id = score.stu_id where stu.id is null