Question:
Review Comments Shared by Guest
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 set based on Resort name and Guest Name.
Code:
Main.sql
select rs.resortname, g.name as "GUEST NAME", r.comments
from guest g join review r
on r.guestid=g.guestid join resort rs
on r.resortid=rs.resortid
order by 1, 2;