1. a. Write a view named InvoiceBasic that displays three columns: VendorName, InvoiceNumber, and InvoiceTotal.b. Then, write a SELECT query that shows all the columns in the view, sorted by VendorName, where the first letter of the vendor name is N, O, or P.

2. a. Write an updatable view named VendorAddress that displays the VendorID, both address columns, and the city, state, and zip code columns for all vendors.b. Write a SELECT query to show the result where VendorID = 4c. Write an UPDATE statement to change the address so that VendorAddress2 contains the Ste 260 instead of it being part of VendorAddress1 columns. Keep it simple.d. Re-run the query you wrote in b to see if the update has been made.