Pergunta de entrevista da empresa Amazon

Difference between outer join/inner join, where/having.