Review Comment by Guest in SQL

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.

Review Comment by Guest

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;

Recommended:

Leave a Comment

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

x