-- Database schema
| course : Course_ID [ INT ] primary_key , Staring_Date [ TEXT ] , Course [ TEXT ] | teacher : Teacher_ID [ INT ] primary_key , Name [ TEXT ] , Age [ TEXT ] , Hometown [ TEXT ] | course_arrange : Course_ID [ INT ] primary_key course_arrange.Course_ID = course.Course_ID , Teacher_ID [ INT ] course_arrange.Teacher_ID = teacher.Teacher_ID , Grade [ INT ] |
-- -- What are the names of the teachers and the courses they teach in ascending alphabetical order by the name of the teacher?

SELECT T3.Name ,  T2.Course FROM course_arrange AS T1 JOIN course AS T2 ON T1.Course_ID  =  T2.Course_ID JOIN teacher AS T3 ON T1.Teacher_ID  =  T3.Teacher_ID ORDER BY T3.Name;