Using Query Design, create a query from tblReservations that returns the average room rate, the minimum rate, and the ma
Posted: Fri Jul 01, 2022 9:06 am
Using Query Design, create a query from tblReservations thatreturns the average room rate, the minimum rate, and the maximumrate (in that order) for each DiscountType for the rooms that arecurrently reserved. The DiscountType should be displayed in thefirst column. Rename the rate fields AverageRate, Minimum Rate,and Maximum Rate. Sort the query inDescending order by DiscountType. In Datasheet view, autofit thecolumn widths. Save the queryas qryDiscountTypeStatistics_aStudent. Closethe query.