In this assignment, you will be inserting data in the following tables: CUSTOMER, ORDERS, PART, AND ORDER_LINEYou 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.1) 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_NUMCUSTOMER_NAMESTREETCITYSTATEZIPBALANCECREDIT_LIMITREP_NUM14820282353566540835462655242060865687357253584220The 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)2) The ORDERS Table (15 points)ORDER_NUMORDER_DATECUSTOMER_NUM216082007-10-20148216102007-10-20356216132007-10-21408216142007-10-21282216172007-10-23608 Using SQL, write a query to insert this data in the ORDERS table 3) The PART Table (15 points)PART_NUMDESCRIPTIONCLASSWAREHOUSEON_HANDPRICEAT94Iron50HW324.95BV06Home Gym45SG2794.95CD52Microwave Oven32AP1165.00DL71Cordless Drill21HW3129.95DR93Gas Range8AP2495.00DW11Washer12AP3399.99FD21Stand Mixer22HW3159.95KL62Dryer12AP1349.45KT03Dishwasher8AP3595.00KV29Treadmill9SG21390.00 Using SQL, write a query to insert this data in the PART table 4) The ORDER_LINE Table (15 points)ORDER_NUMPART_NUMNUM_ORDEREDQUOTED_PRICE21608AT941121.9521610DR931495.0021610DW111399.9921613KL624329.9521614KT032595.0021617BV062794.9521617CD524150.00Using SQL, write a query to insert this data in the ORDER_LINE table