Review Comment for all Resort in SQL

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
Review Comment for all Resort

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;

Related:

Leave a Comment

one × three =