6.2s 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. Customer CustomerID FirstName LastName StreetAddress City State PostalCode Country Phone Manufacturer ManufacturerID ManufacturerName Address Address2 City State PostalCode Phone Fax Contact URL Product ProductID ProductName ManufacturerlD Composition ListPrice Gender Category Color Description Saleltem Inventoryltem Purchaseltem ProductID ProductID 1ProductID ItemSize SalelD Quantity SalePrice QtyOnHand Purchase!D Quantity PurchasePrice ItemSize ItemSize Sale SalelD SaleDate CustomerID Purchase PurchaselD PurchaseDate EmployeelD ExpectedDeliveryDate ManufacturerlD Shipping Employee Y EmployeeID | ax Shipping FirstName LastName Address City State SalaryEmployee EmployeelD Salary WageEmployee EmployeelD Wage MaxHours Phone ManagerlD SSN EmailAddress HireDate