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, 2013, and July 31, 2013. 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 firstname.

Transcribed Image Text:

CUST FNAME CUST LNAME CUST STREET CUST CITY | CUST STATE! CUST ZIP SANTANA 1292 WEST 70TH PLACE STILES WHITTAKER 339 NORTHPARK DRIVE JAMISON Phenix City Montgomery AL Marshallle GA AL AL 1493 DOLLY MADISON CIRCLE Snow Hill 36778 36197 33169 31057 ISETTE DEANDRE CATHLEEN WHITMAN 1712 NORTHFIELD DRIVE SHERIE BRYCE SHELBY ERMAINE HANCOCK 1627 SAUNDERS ROAD WHITNEY MONROE DARLEEN P CLINTON TOMMIE 1571 HANES STREET STOVER HOGAN SALAS 640 MOUNTAIN MEW DRVE Parksville 1860 IMLACH DRVE 486 SUSITNA VIEW COURT Ky MA 01951 North Tisbury MA Ellicott City MD Phippsburg ME Kalamazoo MI 21041 04567 49002 39130 27248 WHITFIELD ALLISON PARRA AGUIRRE PALMER MCBRIDE GARZA GUIDRY LEVINE 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 Franklinville NC Arapahoe Glenwood Fair Harbor NY Brooklyn Cincinnati Wilkes Bae PA PittsburghPA SIDNEY TAMELA KAREN STEPHENIE MCKENZIE1059 DELAWARE PLACE LAN KASEY SHELBYTHAYER 07418 11706 11252 45218 18763 NICHOLS SOSA 367 LAKEVIEW DRIVE 975 WEST 96TH AVENUE Kinzes PA 1634 RUANE ROAD 1127 CUNNINGHAM STREET Louisville TN 652 LEWIS STREET 848 DOWNEY FINCH LANE 17535 29835 Bordeaux SC WİLSON RENATE MELONIE BELL Crystal City VA East Monkton VT 22202 05443 JIMENEZ