Plants Company would like to verify that every customer has a zip code in its database. Create a query that lists customers whose zipcode is missing from the database. Show the CustomerID, FirstName, LastName, StreetAddress, City, State, Zip. Sort the data in ascending order by State, then by City. Save the query as Query$1$ Be sure to show the fields in the order requested.$|$

General query tip: Run the query first before you place criteria in the criteria line and explore the data using the drop$-$down on the column header in datasheet view. Notice that State data is represented by the state abbreviation and not the entire state name. This strategy is especially helpful with unfamiliar fields.