Forum

Write a SQL Query t...
 
Notifications
Clear all

Write a SQL Query to Display Review Comments Given by the customer.


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

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: