SELECT ThreeCharCode,School_Name
FROM schools
WHERE Active = '1'
ORDER BY School_Name