Review Comment for all Resort in SQL

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.

Review Comment for all Resort

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;

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *

x