Question:
Review Comment by Guest
The resort manager wants to see the review comments given by the customer. Write a query to display guest name, resort name and review comments and display the result set in ascending order of guest name and resort name.
Code:
Main.sql
select g.name, rs.resortname, rv.comments from guest g join review rv on g.guestid=rv.guestid join resort rs on rs.resortid= rv.resortid order by 1, 2;