Forum

The Resort Manager ...
 
Share:
Notifications
Clear all

The Resort Manager Wants to See the Review Comments Given by the Customer.


Posts: 17
Topic starter
(@rahul)
Active Member
Joined: 5 years ago

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.

 
2 Replies
Posts: 27
Admin
(@vinodkrsetty)
Eminent Member
Joined: 6 years ago

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
on gst.guestid=rvw.guestid
join resort rsrt
on rsrt.resortid= rvw.resortid
order by 1, 2;

Reply
1 Reply
 VK
Admin
(@vinodkrsetty5895)
Joined: 5 years ago

Active Member
Posts: 18

Let me know in case of any queries.

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: