PwC Interview Question

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