Hi Community, Finally I found the beast mode to achieve this calculation it goes like this, MAX(`Capacity`) OVER (PARTITION BY `property_id`) I used the group by tile in Table B to sum the Capacity and Total bookings of table B to get the sum of Capacity and Total bookings based on the property ID. Then left joined the…