insert into dotlrn_departments (department_key, external_url) values (:department_key, :external_url) select 1 from dotlrn_departments where department_key = :department_key select pretty_name, department_key from dotlrn_departments_full order by pretty_name select count(*) from dotlrn_classes where department_key = :department_key delete from dotlrn_departments where department_key = :department_key