Display Resort based on Star-rating in SQL

Question:

Display Resort based on Star-rating

 Display all the resorts names whose star-rating ranges between 4 and 5. Sort the result set in the ascending order of star rating.

Quiz for Exam - Display Resort based on Star rating

Code:

Main.sql

Select resortName 
from Resort 
where starRating between 4 and 5 
order by starRating;

Recommended:

Leave a Comment

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

x