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
Insert Records into Resort table in SQL

CODE:

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);

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

Sharing Is Caring

Leave a Comment