Question d’entretien chez Paramount

Expalin partitions, ranking in SQL?