Insert Records into Resort table in SQL

Question:

Insert Records into Resort table

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

RESORTID RESORTNAME STREET TOWNNAME TOWNID STARRATING MANAGERID
1001 TREE OF LIFE RESORT KACHERAWALA KOOKAS JAIPUR 3 3.8 2
1002 PALETTE RESORTS LAKE VIEW ROAD NALLVADU POST PONDICHERRY 2 4.3 2
1003 GRAND GRT SIR THEAGARAYA RD THAGAR CHENNAI 1 4.4 1
1004 GREEN COCONUT EAST COAST ROAD, MAHABALIPUR AM CHENNAI 1 3.7 1

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

Leave a Comment

Scroll to Top