You work in Procurement and are reviewing customer orders. Develop a query so that the output includes the following attributes in this order: the employee last name, the required date of the order, the Order ID, the customer last name, and a column that shows the gross dollar amount of the order named as Gross Order Amount. Restrict the query output to include only orders processed by the employee whose last name is Callahan, and further restrict the query to include only orders placed during August, September, or October of 2012. Sort the output by the "Gross Order Amount" column, with the largest amount listed first. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Employee.LastName, CustOrder.ReqDate, CustOrder.OrderID, Customer.LastName, (Order Product.Order Price Order Product.QtyOrdered) "Gross Order Amount" FROM Employee JOIN CustOrder ON Employee. =CustOrder. JOIN Customer ON CustOrder. =Customer. JOIN Order Product ON CustOrder. =Order Product. WHERE Employee.LastName = "Callahan" CustOrder. Order Date BETWEEN "AND" BY Employee.LastName, CustOrder.ReqDate, CustOrder. OrderID, Customer. LastName BY "Gross Order Amount" You work in Procurement and are reviewing customer orders. Develop a query so that the output includes the following attributes in this order: the employee last name, the required date of the order, the Order ID, the customer last name, and a column that shows the gross dollar amount of the order named as Gross Order Amount. Restrict the query output to include only orders processed by the employee whose last name is Callahan, and further restrict the query to include only orders placed during August, September, or October of 2012. Sort the output by the "Gross Order Amount" column, with the largest amount listed first. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Employee.LastName, CustOrder.ReqDate, CustOrder.OrderID, Customer.LastName, (Order Product.Order Price Order Product.QtyOrdered) "Gross Order Amount" FROM Employee JOIN CustOrder ON Employee. =CustOrder. JOIN Customer ON CustOrder. =Customer. JOIN Order Product ON CustOrder. =Order Product. WHERE Employee.LastName = "Callahan" CustOrder. Order Date BETWEEN "AND" BY Employee.LastName, CustOrder.ReqDate, CustOrder. OrderID, Customer. LastName BY "Gross Order Amount