Write a query to display the first name, last name, street, city, state, and zip code of any customer who purchased a Foresters Best brand top coat between July 15, 2021, and July 31, 2021. If a customer purchased more than one such product, display the customer’s information only once in the output. Sort the output by state, last name, and then first name (Figure P7.32).

Figure P7.32 Customers Who Purchased Foresters Best Top Coat CUST_FNAME CUST_LNAME SANTANA STILES LUPE HOLLIS LISETTE DEANDRE CATHLEEN SHERIE BRYCE SHELBY JERMAINE WHITNEY MONROE DARLEEN CLINTON TOMMIE JEFFEREY SIDNEY TAMELA KAREN STEPHENIE LAN KASEY SHELBY WILSON RENATE MELONIE WHITTAKER JAMISON WHITMAN STOVER HOGAN SALAS HANCOCK WHITFIELD ALLISON PARRA AGUIRRE PALMER MCBRIDE GARZA GUIDRY LEVINE MCKENZIE NICHOLS SOSA THAYER BELL LADD JIMENEZ CUST_STREET 1292 WEST 70TH PLACE 1493 DOLLY MADISON CIRCLE 339 NORTHPARK DRIVE 1571 HANES STREET 1712 NORTHFIELD DRIVE 640 MOUNTAIN VIEW DRIVE 1860 IMLACH DRIVE 486 SUSITNA VIEW COURT 1627 SAUNDERS ROAD 1259 RHONE STREET 272 SCHODDE STREET 561 COLLIE HILL WAY 1651 VANGUARD DRIVE 933 ELCADORE CIRCLE 1043 ROCKRIDGE DRIVE 772 SHEPPARD DRIVE 1873 BAXTER ROAD 1534 PALMER COURT 1039 DELAWARE PLACE 367 LAKEVIEW DRIVE 975 WEST 96TH AVENUE 1634 RUANE ROAD 1127 CUNNINGHAM STREET 652 LEWIS STREET 848 DOWNEY FINCH LANE CUST CITY CUST_STATE CUST_ZIP Phenix City Snow Hill AL AL Montgomery AL Miami FL GA Marshallville Parksville Newbury KY MA North Tisbury MA Ellicott City MD Phippsburg ME Kalamazoo MI Madison MS Franklinville NC Arapahoe NC Glenwood NJ Fair Harbor NY NY OH Brooklyn Cincinnati Wilkes Barre Pittsburgh Kinzers Bordeaux Louisville Crystal City East Monkton VT 5111875 PA PA PA SC TN VA 36867 36778 36197 33169 31057 40464 01951 02568 21041 04567 49002 39130 27248 28510 07418 11706 11252 45218 18763 15262 17535 29835 37777 22202 05443