8 Write a JOIN query that combines multiple tables. Display only the columns requested. Be sure that your query does not produce duplicate records. Customer Sale Salel SaleDate Customer D Product ProductID ProductName Manufacturer Category Color Price Description Manufacturer Manufacturer ManufacturerName Address City State PostalCode Phone Customer FirstName LastName StreetAddress City State Postal Code Country Phone ProductID GO Item Size Quantity Sale Price List the information contained in the sale table concerning the sales of slippers (whose category is slippers). Categories are not capitalized in the database. Note: Your answer should dynamically include all current columns and any future changes to columns. Open in Advanced Editor Save Answer Test Query 9 Write a JOIN query that combines multiple tables. Display only the columns requested. Be sure that your query does not produce duplicate records. Sale Customer Customer FirstName LastName StreetAddress City State Postal Code Country Phone SaleID Sale Date Customer ProductID Item Size Quantity Sale Price Product Y ProductID ProductName Manufacturer Category Color Price Description Manufacturer 7 Manufacturer ManufacturerName Address City State PostalCode Phone OO List the information in the sales table, plus the productname, category, and color for sales of green sneakers and green sandals. Use the first letters of table names as aliases. Note: Your answer should dynamically include all current columns and any future changes to columns in the sales table. Open in Advanced Editor Save Answer Test Query 10 Write a JOIN query that combines multiple tables. Display only the columns requested. Be sure that your query does not produce duplicate records. Sale Customer Customers FirstName LastName StreetAddress City State PostalCode Country Phone SaleID Sale Data Customer ProductID Item Size Quantity Sale Price Product ProductiD Product Name Manufacturer D Category Color Price Description Manufacturer Manufacturer D ManufacturerName Address City State PostalCode Phone What are the names of manufacturers of heels costing $50 or more? (Use the first letters of table names as aliases.) Only show manufacturer names. 1 Open in Advanced Editor Save Answer Test Query 8 Write a JOIN query that combines multiple tables. Display only the columns requested. Be sure that your query does not produce duplicate records. Customer Sale Salel SaleDate Customer D Product ProductID ProductName Manufacturer Category Color Price Description Manufacturer Manufacturer ManufacturerName Address City State PostalCode Phone Customer FirstName LastName StreetAddress City State Postal Code Country Phone ProductID GO Item Size Quantity Sale Price List the information contained in the sale table concerning the sales of slippers (whose category is slippers). Categories are not capitalized in the database. Note: Your answer should dynamically include all current columns and any future changes to columns. Open in Advanced Editor Save Answer Test Query 9 Write a JOIN query that combines multiple tables. Display only the columns requested. Be sure that your query does not produce duplicate records. Sale Customer Customer FirstName LastName StreetAddress City State Postal Code Country Phone SaleID Sale Date Customer ProductID Item Size Quantity Sale Price Product Y ProductID ProductName Manufacturer Category Color Price Description Manufacturer 7 Manufacturer ManufacturerName Address City State PostalCode Phone OO List the information in the sales table, plus the productname, category, and color for sales of green sneakers and green sandals. Use the first letters of table names as aliases. Note: Your answer should dynamically include all current columns and any future changes to columns in the sales table. Open in Advanced Editor Save Answer Test Query 10 Write a JOIN query that combines multiple tables. Display only the columns requested. Be sure that your query does not produce duplicate records. Sale Customer Customers FirstName LastName StreetAddress City State PostalCode Country Phone SaleID Sale Data Customer ProductID Item Size Quantity Sale Price Product ProductiD Product Name Manufacturer D Category Color Price Description Manufacturer Manufacturer D ManufacturerName Address City State PostalCode Phone What are the names of manufacturers of heels costing $50 or more? (Use the first letters of table names as aliases.) Only show manufacturer names. 1 Open in Advanced Editor Save Answer Test Query