text11. 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 columnsin the view, sorted by VendorName, where the first letter of the vendor name is N, O, or P (8 marks)…. Show moreEngineering & Technology Computer ScienceThis question was created fromDBMS430 Lab 1-3.doc

Order your essay today and save 20% with the discount code ESSAYHELP