Question
You need to show me the screenshot of your query that was executed successfully, and of the data that was inserted in each table as
You need to show me the screenshot of your query that was executed successfully, and of the data that was inserted in each table as explained in class.
- The CUSTOMER Table (5 points)
Below is the table CUSTOMER containing some empty cells (these cells are left empty intentionally to ease your task on this problem?)
CUSTOMER_NUM | CUSTOMER_NAME | STREET | CITY | STATE | ZIP | BALANCE | CREDIT_LIMIT | REP_NUM |
148 |
|
|
|
|
|
|
| 20 |
282 |
|
|
|
|
|
|
| 35 |
356 |
|
|
|
|
|
|
| 65 |
408 |
|
|
|
|
|
|
| 35 |
462 |
|
|
|
|
|
|
| 65 |
524 |
|
|
|
|
|
|
| 20 |
608 |
|
|
|
|
|
|
| 65 |
687 |
|
|
|
|
|
|
| 35 |
725 |
|
|
|
|
|
|
| 35 |
842 |
|
|
|
|
|
|
| 20 |
The following data has been retrieved from the CUSTOMER table above. The data is organized in the same order as the attributes in the CUSTOMER table, that is for each record, the first data point belongs to CUSTOMER_NUM, the second belongs to CUSTOMER_NAME, the third one to STREET, .., and so on until the last one which belongs to REP_NUM.
(148,'Al''s Appliance and Sport, 2837 Greenway, Fillmore, FL, 33336, 6550.00, 7500.00, 20);
('282','Brookings Direct','3827 Devon','Grove','FL','33321',431.50,10000.00,'35');
('356','Ferguson''s','382 Wildwood','Northfield','FL','33146', 5785.00, 7500.00,'65');
(408, The Everything Shop, 1828 Raven, Crystal','FL','33503', 5285.25, 5000.00,'35');
('462','Bargains Galore','3829 Central','Grove','FL','33321',3412.00,10000.00,'65');
('524','Kline''s','838 Ridgeland', Fillmore, 'FL', 33336, 12762.00, 15000.00, 20);
(608, 'Johnson's Department Store','372 Oxford','Sheldon','FL','33553',2106.00,10000.00,'65');
('687','Lee''s Sport and Appliance','282Evergreen','Altonville','FL','32543', 2851.00, 5000.00,'35');
('725','Deerfield''s Four Seasons', 282 Columbia, 'Sheldon', 'FL', 33553,248.00,7500.00,'35');
('842','All Season','28 Lakeview','Grove','FL','33321',8221.00,7500.00,'20');
Using SQL, write a query to insert the data above in the CUSTOMER table (see the video on the class example)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started