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