Question d’entretien chez Chamberlain Group

How SQL process the logic?