WINDOW FUNCTIONS

Window function performs a calculation across a set of rows related to the current row The result is calculated per row, but the calculation itself can look at other rows around it. Window function has over() which turns a normal aggregate function into a window function. in this example you are able to see the average total amount compared to each room type . determines the sequence rows are…