SQL Query Review Co...
Clear all

SQL Query Review Comments Shared by the Guest in SQL

Posts: 17
Topic starter
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
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, 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;



Self Learning Video Tutorials - Software Course

Leave a reply

Author Name

Author Email

Title *

Preview 0 Revisions Saved