SQL Hands-on Problem Guest wants to display Resort Id, Name and Comments of the resort based on it's star rating. Comments of the resort displays as follows If rating is between 5.0 to 4.5 then...

Extracted text: SQL Hands-on Problem Guest wants to display Resort Id, Name and Comments of the resort based on it's star rating. Comments of the resort displays as follows If rating is between 5.0 to 4.5 then display the comments as 'Excellent Resort If rating is between 4.4 to 4.0 then display the comments as Very Good Resort else display 'Good Resort' . Give alias name to this result as CcOMMENTS. Sort the result based on resort id. RESORT MANAGEMENT SYSTEM Pointofinterest Town Manager townlD townname Number Varchar(30) varchar(30) varchar(30) PK Number varchar(30) varchar(30) varchar(20) varchar(15) pointiD Number manageriD PK PK describe Varchar(30) opentime varchar(10) name state address closetime varchar(10) Number longitude latitude %3 varchar(30) city phone summertemp Number FK towniD Number Number wintertemp sealevel Resort Guest Review PK resortiD Number PK guestID Number FK,PK guestID Number Number resortName varchar(30) varchar(30) varchar(30) + varchar(20) name FK,PK resortiD %23 street varchar(30) address dateofreview Date varchar(30) townname country email varchar(30) comments varchar(150) FK townid Number varchar(15) starRating Number phone %23 FK manageriD Number Booking HAS PK bookingiD FK guestid Number CabinCost Number FK.PK resortiD Number FK resortiD Number FK.PK cabiniD Number FK cabiniD Number Cabin PK startdate Date fromdate Date FK.PK resortID Number todate enddate Date PK Date adultCount Number PK cabiniD Number rate Number Number varchar(30) + childCount describe petcount Number cabintype varchar(10) totalcharge Number bedroomcount Number sleepcapacity Number