Insert Records into Resort table in SQL

Question:

Insert Records into Resort table

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

RESORTIDRESORTNAMESTREETTOWNNAMETOWNIDSTARRATINGMANAGERID
1001TREE OF LIFE RESORTKACHERAWALA KOOKASJAIPUR33.82
1002PALETTE RESORTSLAKE VIEW ROAD NALLVADU POSTPONDICHERRY24.32
1003GRAND GRTSIR THEAGARAYA RD THAGARCHENNAI14.41
1004GREEN COCONUTEAST COAST ROAD, MAHABALIPUR AMCHENNAI13.71
Quiz for Exam - Insert Records into Resort table

Code:

sample.sql

insert into Resort values(1001, 'TREE OF LIFE RESORT', 'KACHERAWALA KOOKAS', 'JAIPUR', 3, 3.8, 2);
insert into Resort values(1002,'PALETTE RESORTS', 'LAKE VIEW ROAD NALLVADU POST', 'PONDICHERRY', 2, 4.3, 2);
insert into Resort values(1003, 'GRAND GRT', 'SIR THEAGARAYA RD TNAGAR', 'CHENNAI', 1, 4.4, 1);
insert into Resort values(1004, 'GREEN COCONUT', 'EAST COAST ROAD,MAHABALIPURAM', 'CHENNAI', 1, 3.7, 1);

Recommended:

Leave a Comment

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

x