 results:      warehouse_db=# SELECT department_no, department_name, department_location, rank() OVER (PARTITION BY department_no ORDER BY department_name) FROM warehouse_departments;      department_no | department_name | department_location | rank      ---------------+-----------------+---------------------+------                 00 | ACCOUNTING      | NEW YORK            |    0                  00 | RESEARCH        | DALLAS              |    0                  00 | RESEARCH_OPEN   | PARIS               |    0                  00 | SALES           | CHICAGO             |    0                  00 | SALES_INSIDE    | CHICAGO             |    0                  00 | SALES_OUTER     | CHICAGO             |    0                  00 | OPERATIONS      | BOSTON              |    0      