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.
Code:
Main.sql
select resortid, comments from review where comments>'0' order by resortid, comments;