Question d’entretien chez BOLD

SQL Window Function question , and joins