Review Comment for star rating Resort in SQL

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

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

Related:

Leave a Comment

11 − five =