select *, code as state from states
ORDER BY name


