Pergunta de entrevista da empresa PwC

Mostly basic. Explain inner join, outer join, Case in SQl