What is the sql query for my homework
What is the average quoted price, maximum quoted price, and minimum quoted price of all orders? Display the average as ‘Average Quoted Price’, maximum quoted price as ‘Maximum Quoted Price’, and minimum quoted price as ‘Minimum Quoted Price’. Extra decimal places are okay for now. Insert your snip of the query and resultset together here:

The SQL Query for the average quoted price, maximum quoted price, and minimum quoted price of all orders is given below:The SQL QueryDisplay itemcode and descr of those items.Filter Closed and Rejected Quotations.SELECT * FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')Find maximum price of those quotations.SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')Fetch the itemcode of the quoation.SELECT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE= (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed'))Display the details of the fetched item.SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN (SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE = (SELECT MAX(QUOTEDPRICE) MAXI FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')))However,  the following query doesn't show a logical error:SELECT ITEMCODE, DESCR FROM ITEM WHERE ITEMCODE IN (   SELECT DISTINCT ITEMCODE FROM QUOTATION WHERE QUOTEDPRICE =  (    SELECT MAX(QUOTEDPRICE) FROM QUOTATION WHERE QSTATUS IN ('Rejected','Closed')  )   AND QSTATUS IN ('Rejected','Closed') )Read more about SQL here:https://brainly.com/question/27851066#SPJ1