Question:
Guest who paid highest charges
Write a query to display the guestid and guest name who was charged highest amount in the resort. Sort the output on the guestid.
Code:
Main.sql
select g.guestid, g.name
from guest g left join booking b
on b.guestid=g.guestid
where b.totalcharge=(select max(totalcharge) from booking)
order by 1;