Pergunta de entrevista da empresa RBC

left join vs inner join which is more efficient