select r.resort_id,
        r.resort_name,
        r.resort_street_address,
        r.resort_pcode,
        t.town_name,
        t.town_state,
        b.booking_charge AS totalbookingcharge
from resort r
join booking b on r.resort_id = b.resort_id
join town t on t.town_id = r.town_id
where booking_charge>(select avg(booking_charge) from booking)
GROUP BY
r.resort_id,r.resort_name,r.resort_street_address,r.resort_pcode,t.town_name,t.town_state,b.booking_charge;