The function rank that we use in this query computes for each row a nu-
merical rank starting from the content of the window.
The analytical clause used in the previous example indicates that the rows
retrieved by the query are partitioned based on the value of the number of
credits (noc) and, then in each group the rows are ordered according to the
values of the gpa attribute.