Display the resortid, name of the resort,booking count and the
r.resortname, count(*) totalbooking, sum(b.totalcharge) as totalamount from resort r inner join booking b on b.resortid = r.resortid group by r.resortid, r.resortname order by r.resortid; Note









