Pregunta de entrevista de PwC

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