Aug 13, 2020 3:21 pm
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
Jun 07, 2021 5:58 pm
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;
Apr 12, 2022 4:31 am
Leave a reply
Forum Statistics
10
Forums
174
Topics
321
Posts
0
Online
1,386
Members
Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts
