The addresses in this table are in a very strange format. We actually need them broken out into street address, city, state, and zip code, but currently it's pretty unusable.
Write a query to break out this column into street, city, state, and zip_code with those names exactly.