Write a SQL Query to Display 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 helps.
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 on gst.guestid=rvw.guestid join resort rsrt on rsrt.resortid= rvw.resortid order by 1, 2;