Additional Sample Data for Customer Table CustomerID CustomerName CustomerAddressID 1 Western Supply Company 1 2 Nick Harper 3 3 Alice Harper 3 4 Abacus Consulting 4 Additional Sample Data for the Address Table AddressID Street City State Zip Code 1 2400 Broadway Drive Missoula MT 59802 2 320 21st Street Billings MT 59101 3 439 Skyline Blvd Denver CO 80002 4 56 Park Avenue New York NY 10001 4. Construct and execute a sql query to count the number of customers in each state. The list should be ordered by the number of customers in descending order then by state code in ascending order 7. Construct and execute a SQL query to list the state and zip code in a single column. The list should not contain any duplicate records and should be sorted in descending alphabetical order