Forum

SQL Query Review Co...
 
Share:
Notifications
Clear all

SQL Query Review Comments Shared by the Guest in SQL


Posts: 17
Topic starter
(@rahul)
Active Member
Joined: 4 years 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
Posts: 10
Admin
(@sql-admin)
Active Member
Joined: 4 years 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

Self Learning Video Tutorials - Software Course

Leave a reply

Author Name

Author Email

Title *

Preview 0 Revisions Saved
Share: