SELECT first_name, last_name, school, hire_date
FROM teachers
ORDER BY school ASC, hire_date DESC;