SQL Databases A) (10 rows) Write the query that returns records 11-20 from the Vendors table when sorted by VendorName

B) (? rows) Write the query that doesn NOT use a JOIN that returns all columns from the GLAccounts table where the AccountNo is not used as a default in the Vendors table

C) (? rows) Write the same query using a JOIN statement

D) (10 rows) Return all Invoices that have not been soft deleted and have an outstanding balance. Include all items on each invoice. Return the InvoiceID, InvoiceNumber, the item's description, the account number of the item, the amount of the item and the balance for the entire invoice. Sort the list by InvoiceNumber. Use correlation names for your tables

E) (4 rows) Write a query that returns the VendorName, the sum of: InvoiceTotal, PaymentTotal, and balance. Also include the number of invoices for that vendor (DO NOT include soft deleted invoices). Only display vendors that have more than 5 invoices that have not been given a credit