select department_key, pretty_name from dotlrn_departments_full order by pretty_name, department_key