Forum

SQL Query Review Co...
 
Notifications
Clear all

SQL Query Review Comments Shared by the Guest in SQL


Rahul Updhyay
Posts: 17
Topic starter
(@rahul)
Active Member
Joined: 1 year ago

Display the review comments shared by the guest. Write a query to display the resort name, guest name, and guest comment. give alias name to guest name as GUEST NAME. Sort the result based on Resort name and guest name.

 
1 Reply
SQL Admin
Posts: 6
Admin
(@sql-admin)
Member
Joined: 1 year ago

Review comments shared by the Guest SQL

Can you check the below and let me know. 

select rsrt.resortname, g.name as "GUEST NAME", rvr.comments
from guest gst join review rvr
        on rvr.guestid=gst.guestid join resort rsrt
        on rvr.resortid=rsrt.resortid
order by 1, 2;

 

Reply
Share: