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.32Customers Who Purchased Foresters Best Top Coat CUST_FNAME CUST_LNAMESANTANASTILESLUPEHOLLISLISETTEWHITTAKERDEANDRE JAMISONCATHLEEN WHITMANSHERIESTOVERBRYCESHELBYJERMAINEWHITNEYMONROEDARLEENCLINTONTOMMIEJEFFEREYSIDNEYTAMELAKARENSTEPHENIEHOGANSALASHANCOCKWHITFIELDALLISONPARRAAGUIRREPALMERMCBRIDEGARZAGUIDRYLEVINEMCKENZIENICHOLSLANKASEYSHELBYWILSONRENATEMELONIE JIMENEZSOSATHAYERBELLLADDCUST_STREET1292 WEST 70TH PLACE1493 DOLLY MADISON CIRCLE339 NORTHPARK DRIVE1571 HANES STREET1712 NORTHFIELD DRIVE640 MOUNTAIN VIEW DRIVE1860 IMLACH DRIVE486 SUSITNA VIEW COURT1627 SAUNDERS ROAD1259 RHONE STREET272 SCHODDE STREET561 COLLIE HILL WAY1651 VANGUARD DRIVE933 ELCADORE CIRCLE1043 ROCKRIDGE DRIVE772 SHEPPARD DRIVE1873 BAXTER ROAD1534 PALMER COURT1039 DELAWARE PLACE367 LAKEVIEW DRIVE975 WEST 96TH AVENUE1634 RUANE ROAD1127 CUNNINGHAM STREET652 LEWIS STREET848 DOWNEY FINCH LANECUST CITYPhenix CitySnow HillCUST_STATE CUST_ZIP3686736778361973316931057ALALMontgomery ALMiamiFLMarshallville GAParksvilleKYNewburyMAMAMDMEMIMSNCNCNJNYNorth TisburyEllicott CityPhippsburgKalamazooMadisonFranklinvilleArapahoeGlenwoodFair HarborBrooklynNYCincinnati OHWilkes Barre PAPittsburgh PAKinzersPABordeauxLouisvilleSCTNCrystal City VAEast Monkton VT4046401951025682104104567490023913027248285100741811706112524521818763152621753529835377772220205443

Structured Query Language (SQL) can be defined in such a way that it is a standardized programming language used to manage relational databases and perform various operations on the data in them.I assumed the table name from my side.1SELECT DISTINCT 2 CUST_FNAME, 3 CUST_LNAME, 4 CUST_STREET, 5 CUST_CITY, 6 CUST_STATE, 7 CUST_ZIP 8FROM 9 ORDERS 10INNER JOIN 11 ORDER_ITEMS 12ON 13 ORDERS.ORDER_ID = ORDER_ITEMS.ORDER_ID 14WHERE 15 ORDER_ITEM_PRODUCT_NAME = 'Foresters Best Top Coat' 16 AND ORDER_DATE BETWEEN '2021-07-15' AND '2021-07-31' 17ORDER BY 18 CUST_STATE, 19 CUST_LNAME, 20 CUST_FNAME; This query first uses a SELECT DISTINCT statement to make certain that each purchaser's facts are best displayed once. It then joins the ORDERS and ORDER_ITEMS tables to get all the order statistics for the Foresters great emblem top coats that have been purchased between July 15, 2021, and July 31, 2021. eventually, it sorts the output by means of country, closing name, after which first name.Here we defined the query and also provided its explanation