select class_key, pretty_name from dotlrn_classes_full order by pretty_name