Prompt: You work in the Procurement Department, and you need a list of select items carried for sale by COB 204 Company and details about the supplier and current stock balance. Develop a query that...

Extracted text: Prompt: You work in the Procurement Department, and you need a list of select items carried for sale by COB 204 Company and details about the supplier and current stock balance. Develop a query that will produce output with the following attributes in this order: product name, supplier name, and the quantity of product in stock. Restrict the query to include only those products supplied by a supplier whose company name starts with the letter E. Additionally, restrict the query to only those products that currently have a quantity in stock that is greater than or equal to 50. Finally, sort the query output alphabetically by the product name. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Product.ProdName, Supplier.CompanyName, Product. FROM Product Supplier ON Product. |=Supplier. WHERE Supplier. AND Product. 50 ORDER BY Product.ProdName; Query Result Count (enter number only, ex. 12): Result: rows