Question d’entretien chez Apple

CASE WHEN question Three tables join