Apple interview question

CASE WHEN question Three tables join