SQL "difference between" interview questions (part 2)

This is the second part of SQL interview questions.
The questions covered in this video are:
1) Difference between group by vs order by?
2) Difference between join vs sub query?
3) Difference between join vs union?

The part one video can be found here:
https://youtu.be/RZc4QSRRk98

Do check the video. The questions covered in first video are:
1) Difference between where and having?
2) Difference between union and union all?
3) Difference between in and exists?

Thank you for watching!

Видео SQL "difference between" interview questions (part 2) канала Crack Concepts