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

SQL Code: Review Comment for star rating Resort Solution

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

2 × 2 =