subject

/*PRICE: */ INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);
INSERT INTO PRICE VALUES (2, 'New Release', 3.5, 3);
INSERT INTO PRICE VALUES (3, 'Discount', 1.5, 1);
INSERT INTO PRICE VALUES (4, 'Weekly Special', 1, .5);
/*MOVIE:*/
INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2014, 39.95, 'FAMILY', 2);
INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2011, 59.95, 'ACTION', 1);
INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2015, 59.95, 'DRAMA', 2);
INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2014, 29.95, 'COMEDY', 2);
INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2015, 89.95, 'DRAMA', NULL);
INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2005, 25.49, 'DRAMA', 3);
INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2012, 45.49, 'ACTION', 1);
INSERT INTO MOVIE VALUES (1246, 'What He Doesn''t Know', 2013, 58.29, 'COMEDY', 1);
/*VIDEO:*/
INSERT INTO VIDEO VALUES (54321, '18-JUN-15', 1234);
INSERT INTO VIDEO VALUES (54324, '18-JUN-15', 1234);
INSERT INTO VIDEO VALUES (54325, '18-JUN-15', 1234);
INSERT INTO VIDEO VALUES (34341, '22-JAN-14', 1235);
INSERT INTO VIDEO VALUES (34342, '22-JAN-14', 1235);
INSERT INTO VIDEO VALUES (34366, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (34367, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (34368, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (34369, '02-MAR-16', 1236);
INSERT INTO VIDEO VALUES (44397, '21-OCT-15', 1237);
INSERT INTO VIDEO VALUES (59237, '14-FEB-16', 1237);
INSERT INTO VIDEO VALUES (61388, '25-JAN-14', 1239);
INSERT INTO VIDEO VALUES (61353, '28-JAN-13', 1245);
INSERT INTO VIDEO VALUES (61354, '28-JAN-13', 1245);
INSERT INTO VIDEO VALUES (61367, '30-JUL-15’, 1246);
INSERT INTO VIDEO VALUES (61369, '30-JUL-15', 1246);
/*MEMBERSHIP:*/
INSERT INTO MEMBERSHIP VALUES (102, 'TAMI', 'DAWSON', '2632 TAKLI CIRCLE', 'NORENE', 'TN', '37136', 11);
INSERT INTO MEMBERSHIP VALUES (103, 'CURT', 'KNIGHT', '4025 CORNELL COURT', 'FLATGAP', 'KY', '41219', 6);
INSERT INTO MEMBERSHIP VALUES (104, 'JAMAL', 'MELENDEZ', '788 EAST 145TH AVENUE', 'QUEBECK', 'TN', '38579', 0);
INSERT INTO MEMBERSHIP VALUES (105, 'IVA', 'MCCLAIN', '6045 MUSKET BALL CIRCLE', 'SUMMIT', 'KY', '42783', 15);
INSERT INTO MEMBERSHIP VALUES (106, 'MIRANDA', 'PARKS', '4469 MAXWELL PLACE', 'GERMANTOWN', 'TN', '38183', 0);
INSERT INTO MEMBERSHIP VALUES (107, 'ROSARIO', 'ELLIOTT', '7578 DANNER AVENUE', 'COLUMBIA', 'TN', '38402', 5);
INSERT INTO MEMBERSHIP VALUES (108, 'MATTIE', 'GUY', '4390 EVERGREEN STREET', 'LILY', 'KY', '40740', 0);
INSERT INTO MEMBERSHIP VALUES (109, 'CLINT', 'OCHOA', '1711 ELM STREET', 'GREENEVILLE', 'TN', '37745', 10);
INSERT INTO MEMBERSHIP VALUES (110, 'LEWIS', 'ROSALES', '4524 SOUTHWIND CIRCLE', 'COUNCE', 'TN', '38326', 0);
INSERT INTO MEMBERSHIP VALUES (111, 'STACY', 'MANN', '2789 EAST COOK AVENUE', 'MURFREESBORO', 'TN', '37132', 8);
INSERT INTO MEMBERSHIP VALUES (112, 'LUIS', 'TRUJILLO', '7267 MELVIN AVENUE', 'HEISKELL', 'TN', '37754', 3);
INSERT INTO MEMBERSHIP VALUES (113, 'MINNIE', 'GONZALES', '6430 VASILI DRIVE', 'WILLISTON', 'TN', '38076', 0);
/*RENTAL:*/
INSERT INTO RENTAL VALUES (1001, '01-MAR-16', 103);
INSERT INTO RENTAL VALUES (1002, '01-MAR-16', 105);
INSERT INTO RENTAL VALUES (1003, '02-MAR-16', 102);
INSERT INTO RENTAL VALUES (1004, '02-MAR-16', 110);
INSERT INTO RENTAL VALUES (1005, '02-MAR-16', 111);
INSERT INTO RENTAL VALUES (1006, '02-MAR-16', 107);
INSERT INTO RENTAL VALUES (1007, '02-MAR-16', 104);
INSERT INTO RENTAL VALUES (1008, '03-MAR-16', 105);
INSERT INTO RENTAL VALUES (1009, '03-MAR-16', 111);
/*DETAILRENTAL:*/
INSERT INTO DETAILRENTAL VALUES (1001, 34342, 2, '04-MAR-16', '02-MAR-16', NULL);
INSERT INTO DETAILRENTAL VALUES (1001, 34366, 3.5, '04-MAR-16', '02-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1001, 61353, 2, '04-MAR-16', '03-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1002, 59237, 3.5, '04-MAR-16', '04-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1003, 54325, 3.5, '04-MAR-16', '09-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1003, 61369, 2, '06-MAR-16', '09-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1003, 61388, 0, '06-MAR-16', '09-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1004, 34341, 2, '07-MAR-16', '07-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1004, 34367, 3.5, '05-MAR-16', '07-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1004, 44392, 3.5, '05-MAR-16', '07-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1005, 34342, 2, '07-MAR-16', '05-MAR-16', 1);
INSERT INTO DETAILRENTAL VALUES (1005, 44397, 3.5, '05-MAR-16', '05-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1006, 34366, 3.5, '05-MAR-16', '04-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1006, 61367, 2, '07-MAR-16', NULL, 1);
INSERT INTO DETAILRENTAL VALUES (1007, 34368, 3.5, '05-MAR-16', NULL, 3);
INSERT INTO DETAILRENTAL VALUES (1008, 34369, 3.5, '05-MAR-16', '05-MAR-16', 3);
INSERT INTO DETAILRENTAL VALUES (1009, 54324, 3.5, '05-MAR-16', NULL, 3);
/*Write the SQL command to save the rows inserted in Problem 47.*/
COMMIT;

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 23:30
What are some ways to use a range name in a formula? check all that apply. in the defined names group, click use in formula, and then select the desired name. begin typing the name in the formula, select a name from the autocomplete list, and use the arrow keys and tab key to enter the name in the formula. begin typing the formula, and then click and drag with the mouse to select the cells to include in the formula. right-click one of the cells in the range. click formula options, and use the dialog box to add the name.
Answers: 1
question
Computers and Technology, 24.06.2019 05:30
How do i get rid of my member ship for
Answers: 2
question
Computers and Technology, 24.06.2019 12:40
Match the feature to the network architecture. expensive to set up useful for a small organization easy to track files has a central server inexpensive to set up difficult to track files useful for a large organization does not have a central server client- server network peer-to-peer network
Answers: 3
question
Computers and Technology, 25.06.2019 02:00
Feedback is one of the basic elements games have in common true false
Answers: 2
You know the right answer?
/*PRICE: */ INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);
INSERT INTO PRICE VALUES (2, 'New...
Questions
question
English, 22.03.2021 15:50
question
Mathematics, 22.03.2021 15:50
question
Mathematics, 22.03.2021 15:50
question
Mathematics, 22.03.2021 15:50
question
History, 22.03.2021 15:50
Questions on the website: 13722366