Question d’entretien chez Amazon

SQL pseudo code asked on Use of SQL windows function