Question:
Review Comment for all Resort
Write a query to display the resort name , guest name , review comments for all resort. sort the output in ascending order of resort ID.
Code:
Main.sql
select r.resortname, g.name, rv.comments from resort r join review rv on r.resortid=rv.resortid join guest g on g.guestid = rv.guestid order by r.resortid;