1 HP would like to clean up the customer addresses in their database and verify that every customer has a zip code. They would like your help in starting with the customers who live in Bloomington, Indiana; the home of their alma mater. Create a query that lists customers with missing zip codes. List the CustomerID, LastName, FirstNaJne, StreetAddress, City, State, and Zip. Sort the information in ascending order by LastName, then FiIstName. Save the query as Queryl. 5. The company representative from VISA just called and reported that credit card number 4283541418276099 was stolen and used to make a river trip reservation. They need your help in identifying the customer who would do such a dastardly deed. Create a query listing this customer's CustomerID, Name, Birthdate, and Telephone number. The Name eld should be a concatenation of the rst and last names (i.e., john Brown]. Select only the customer who is responsible for making the reservation. Save this query as Quer2. 6. Somehow there have been some underage children booked for some river trips. Write a query that identies all the children who are younger than the minimum age at the time of departure. List their FirstName, LastName, and Age, the Minimunmge required for the trip, the RiverName, and the DepartureDate. The Age eld refers to the age of the customer on the day of departure. Calculate the difference between the Birthdate and the DepaItuI'eDate; then divide the difference by 365. Use the "t" symbol instead of \"I" for the division. This will result in the largest number of years without any decimal values (whole number of years). Compare this value with the minimum age in the selection criteria. The minimum age varies with each river trip. Sort in ascending order by DepartureDate, and save your query as QuerS