Question:
Update star-rating in Resort Table
The rating for “TREE OF LIFE RESORT“ has changed. Write a query to change the value of the rating from 3.8 to 4.2 in the “Resort” table.
Code:
sample.sql
update resort set starRating=4.2 where resortName='TREE OF LIFE RESORT';