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.
SQL Code: Review Comments Shared by Guest Solution
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;Related:
- 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 all Resort 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
