In SQL!

Uut the product name, category, and manufacturet name of sandals, meakers, and casual shoes manufactured by Buyers Pieks or by. Rodil Fochwear', 1 SELECT * 2 FROM Customer JOIN Sale ON Customer. CustomerID = Sale. CustomerID JOIN SaleItem ON So SaleID = SoleItem. SaleID JoIN Product ON SaleItem. ProductID = Product. ProductID JoIN Manufacturer ON Product. ManufacturerID = Manufacturer. ManufacturerID 3 WHERE (Category = 'sondals') or (Category = 'sneakers') or (Cateogry = 'casuol shoes and (ManufacturerNone = 'Buyers Picks' or 'Rodii Footwear') information. 1 SELECT Product. 2. FROM Customer JoIN Sole OA Customer. CustomerID = Sole. CustomerTD JoIN SoleItem ON Se ,SoleID = SaleIten. SoleID JoIn Product ON SaleItem, Productio = Product. Productic 3 Withe ListPrices'156' row showing the namber of records. What is the average list price of red sneakers? Your query should produce one column named 'Average List. Price' with one nor showing the average list ptice