Forum

The Resort Manager ...
 
Notifications
Clear all

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


Rahul Updhyay
Posts: 17
Topic starter
(@rahul)
Active Member
Joined: 1 year 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.

1 Reply
KV Kumar
Posts: 27
Admin
(@vinodkrsetty)
Member
Joined: 2 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
Share: