怎么用sql标识人员类型

查询所有学生的姓名和教师的姓名允许重名，并标识人员类型(学生/教师)

SELECT name, type
FROM (
  SELECT name, 'student' AS type FROM students
  UNION ALL
  SELECT name, 'teacher' AS type FROM teachers
) AS people
ORDER BY name;