Aug 13, 2020 3:17 pm
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
Jun 07, 2021 2:43 pm
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;