$6\mathrm{.}2$s Join Queries on full Redcat DB $($MS SQL Server$)$ For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed. Product Manufacturer $9$ Manufacturer Manufacturerfiame Address$1$ Address$2$ City Customer Customer FirstName LastName StreetAddress City State Postal Code Country Phone Product D Product Name Manufacturer Composition ListPrice Gender Category Color Description State PostalCode Phone Fax Contact URL Saleltem $8$ Productio $8$ Item Size $8$ Sale Quantity Sale Price Inventoryltem $8$ ProductID $3$ tem Size atyOnHand $*$ Purchaseltem y Products $*$ Item Size Purchase Quantity PurchasePrice ItemSize ItemSize $1$ Purchase Sale $7$ Salelo SaleDate Customer Tax Shipping $11$ Employee Employeeld FirstName Last Name Address $8$ Purchase Purchase Date Employeeld ExpectedDeliveryDate Manufacturers Shipping SalaryEmployee $8$ Employeeld Salary $1$ WageEmployee $7$ Employee Wage MaxHours State ZIP Phone Manager $55$N Email Address Hire Date $8$ Which employees made purchase orders $($purchases$)$ from the manufacturer named Timberland? Show first and last names only. $11$ Open in Advanced Editor Save Answer Test Query $9$ Which employees purchased sneakers $($made purchases$)$ from the manufacturer named Timberland? Show first and last employee names only. $1$ Open in Advanced Editor Save Answer Test Query