Review Comment for star rating Resort in SQL

Question:

Review Comment for star rating Resort

Write a query to display resort id and review comments of all resort which has star rating above 4.2. sort the output in ascending order of resort id.

Review Comment for star rating Resort

Code:

Main.sql

select r.resortid, rv.comments from Resort r join review rv 
on r.resortid=rv.resortid where r.starRating > 4.2
order by 1;

Recommended:

1 thought on “Review Comment for star rating Resort in SQL”

Leave a Comment

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

x