using query design, create a query from tblreservations that returns the average room rate, the minimum rate, and the maximum rate (in that order) for each discounttype for the rooms that are currently reserved. the discounttype should be displayed in the first column. rename the rate fields average rate, minimum rate, and maximum rate. sort the query in descending order by discounttype. in datasheet view, autofit the column widths. save the query as qrydiscounttypestatistics astudent. close the query.using query design, create a query from tblreservations that returns the average room rate, the minimum rate, and the maximum rate (in that order) for each discounttype for the rooms that are currently reserved. the discounttype should be displayed in the first column. rename the rate fields average rate, minimum rate, and maximum rate. sort the query in descending order by discounttype. in datasheet view, autofit the column widths. save the query as qrydiscounttypestatistics astudent. close the query.