create view states
as select ST, full_name from common.dbo.states