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.
SQL Code: Review Comment for all Resort Solution
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:
- Review Comments Shared by Guest in SQL
- Maximum amount paid by Guest in SQL
- pointofinterest locations in each Town in SQL
- Payments made by Guest in SQL
- Fetch Resort Details in SQL
- Review Comment for star rating Resort in SQL
- Resort that charges the highest in SQL
- Cities having Summer Temperature More than Jaipur in SQL
- PointOfInterest Locations in Chennai in SQL
- Resort with Least Capacity in SQL
- Guest who paid highest charges in SQL
- Guest details and Total Charges paid in SQL
- Create View_BMS in SQL
