A. Write an SQL statement to undo the Unit Price modification in part O.
B. Do not run your answer to the following question in your actual database! Write the fewest number of DELETE statements possible to remove all the data in your database but leave the table structures intact.
C. Write an SQL statement to create a view called Invoice Summary View that contains INVOICE. Invoice Number, INVOICE. Invoice Date, LINE _ITEM. Line Number, LINE_ ITEM .Product Number, PRODUCT. Product Description and LINE_ ITEM. Unit Price. Run the statement to create the view, and then test the view with an appropriate SQL SELECT statement.
D. Create and test a user-defined function named Last Name First that combines two parameters named First Name and Last Name into a concatenated name field formatted Last Name, First Name (including the comma and space).
E. Write an SQL statement to create a view called Customer Invoice Summary View that contains INVOICE. Invoice Number, INVOICE .Invoice Date, the concatenated customer name using the Last Name First function, CUSTOMER .Email Address, and INVOICE. Total. Run the statement to create the view, and then test the view with an appropriate SQL SELECT statement.