Review Comment by Guest in SQL


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.

Review Comment by Guest



select, 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;


Leave a Comment

Your email address will not be published. Required fields are marked *