Use SQL to create the following reports. In order to fit the output on the page set line size to 100 and the page size to 50. Generate a script file named customer_report.sql that displays the name, street, city, state, and zip code for each customer. Concatenate the city, state and zip code for each customer into a single expression. Insert a comma between the city and state data. Execute this script file. Copy the customer_report.sql file to the customer_report2.sql file. Create a view within this customer_report2.sql script file. This view named customer_report should display the attributes displayed in item #1 above. The columns names should be CUST_NAME, CUST_STREET_ADDRESS, and CUST_CITY_STATE_ZIP. This script should display the contents of this view. Execute this script file to create and display this view. Develop the customer_report_format.sql script file that removes old headings and creates the column headings in the customer_report view to CUSTOMER NAME, CUSTOMER ADDRESS, and CUSTOMER CITY/STATE/ZIP. Be sure to place the word CUSTOMER on the first line and the remaining words are displayed on the second line. Be sure that the script file displays all the data in the customer_report view. Execute this script file. Copy the customer_report_format.sql file to the customer_report_format2.sql file. Change the customer_report_format2.sql script file so that the format of the CUSTOMER_NAME column is 35 characters wide. Execute the script file. Generate a representative_report.sql script file. Be sure that this script file contains therepresentative_report view that displays the sales representative full name as first name, space, and last name (named REP_NAME), his/her total commission (named REP_COMM), and his/her commission rate (named REP_RATE). The sales representative name should be displayed as last name, comma, space, and first name. Include a statement to display the view. Execute this script file to create and display the view. Develop a script file named representative_report_format.sql that formats the data from the representative_report view. The total commission should appear as currency and the commission rate should appear with two decimal places and a leading zero in front of the decimal point. Modify the column headings so that Sales Rep. and Name are on separate lines, Total and Commission are on separate lines, and Commission and Rate are on separate lines. The final command should display the complete view. Execute this script file.