Display the review with resort ID in SQL

Question:

Display the review with resort ID

Write a query to display the resort id and it’s review if available. Sort the result based on resort id and it’s review.  

Quiz for Exam - Display the review with resort ID

Code:

Main.sql

select resortid, comments 
from review 
where comments>'0' 
order by resortid, comments;

Recommended:

Leave a Comment

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