Manufacturer Customer Product { ManufacturerID { CustomerID { ProductID ManufacturerName Address? FirstName ProductName Address ?

view of the Customers from New York who have purchases at least $200 of product (not including tax or shipping). Name your view FavNYCustomer. Include all Customer table columns. 

(Hint: You will need to use subqueries inside of subqueries to solve this problem)

ManufacturerCustomerProduct{ ManufacturerID{ CustomerID{ ProductIDManufacturerNameAddress?FirstNameProductNameAddress ?LastNameManufacturer![CityStreetAddressComposition*StateCityListPricePostalCodeStateGenderPhonePostalcodeCategoryFaxCountry*ColorContactPhoneDescriptionURLSalEltemInventory itemPurchasEltEm\} ProductID{ ProductIc{ ProductI[{" ItemSize{ ItemSize{ ItemSize\} SalelD*CityonHand{` Furchase![Quantity*QuantitySalePriceItemSize*PurchasePriceSale{ ItemSize{ SalElDPurchaseSale DateCustomer![*$ Furchase![TaxEmployEEFurchase DateShipping$ Employee![Employee![*FirstNameExpected Delivery DateLastNameManufacturer! [ *Salary EmployEEAddressShipping{ Employee! [_ itySalaryStateZIPWageEmployEEPhoneManager! [{ Employee ! [WageEmailAddressMaxHoursHire Date