Question d’entretien chez Ocado Technology

construct a join between 3 tables with some constraints