Write a create view statement that defines a view named invoicebasic that returns three columns: vendorname, invoicenumber, and invoicetotal. then, write a select statement that returns all of the columns in the view, sorted by vendorname, where the first letter of the vendor name is n, o, or p.