IF(us.state IN ('WA','OR','CA','ID','NV','AZ','UT','MT','WY','CO','NM','TX','OK','KS','NE','SD','ND'),'AZ',IF(us.state IN ('MN','IA','MO','IL','WI','MI','IN','KY','OH'),'IN',IF(us.state IN ('AR','TN','LA','MS','AL'),'TN',IF(us.state IN ('WV','VA','NC','SC','GA','FL'),'SC',IF(us.state IN ('ME','NH','VT','MA','RI','CT','NJ','PA','NY','DE','MD','DC'),'PA',us.state)))))
Comments