select dotlrn_terms.term_name || ' ' || dotlrn_terms.term_year as term, dotlrn_terms.term_id from dotlrn_terms order by dotlrn_terms.start_date