The SUM(revenue) AS total_revenue part calculates the total revenue generated by each property in each city. The GROUP BY property_name, city clause ensures that the calculation is done for each unique combination of property name and city, grouping the results accordingly.

Realization% by Booking Platforms Line Chart: Shows how efficiently each booking platform realizes revenue compared to expected revenue over time. ADR by Booking Platforms Clustered Column Chart: Compares the average rate at which rooms are booked per day for different booking platforms.

A week-on-week trend line chart shows the changes in a metric from one week to the next over a period of time. Each data point on the chart represents the value of the metric for a specific week, and the line connects these data points to show the trend over time. This type of chart is useful for identifying short-term trends and patterns, such as weekly fluctuations in revenue, occupancy rates, or other key performance indicators.