Frage im Vorstellungsgespräch bei RBC

Some basic SQL questions. e.g. What is the difference between left join and right join