The Resort Manager Wants to See the Review Comments Given by the Customer.
The resort manager wants to see the review comments given by the customer.
Write a query to display the guest name, resort name, and review comments and display the result set in ascending order of guest name and resort name.
I hope the below query will help.
Query: The resort manager wants to see the review comments given by the customer.
select gst.name, rsrt.resortname, rvw.comments
from guest gst join review rvw
join resort rsrt
on rsrt.resortid= rvw.resortid
order by 1, 2;