-- SELECT 2603422
====Output: ptoassigneend_us_clean1ptoassigneend_us_identify1====
This table stores records that meet all the requirements above: zip with 5-4 or 5 digits, state not null or not spaces, and city in ptoasigneend_us_citylist.
SQL Code:
CREATE TABLE ptoassigneend_us_clean1 ptoassigneend_us_identify1 AS
SELECT *
FROM ptoassigneend_us_temp