Update star rating in Resort Table in SQL

Question:

Insert Records into Resort table

Insert the following records into “Resort ” table based on schema below.

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.

Update star rating in Resort Table in SQL

CODE:

 update resort set starRating=4.2 where resortName='TREE OF LIFE RESORT';

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program

Sharing Is Caring