Q$1.$ Use the AP database for this question. Write a SQL query to display the InvoiceNumber as Inv$\_$Number and the InvoiceTotal as Inv$\_$Total for those invoices that have an InvoiceTotal greater than or equal to $200$ but less than or equal to $8,000.$

Q$2.$ Use the AP database for this question. Write a SQL query that displays all columns from the Vendors table inner$-$joined with the Invoices table. Be sure there is one unique record for each VendorID and order the result set by VendorName

Q$3.$ Use the AP database for this question. Write a SQL query that displays VendorID, VendorName, InvoiceNumber, InvoiceDate and Balance with Balance being the InvoiceTotal minus the sum of the PaymentTotal and CreditTotal. The result set should have one row for each invoice with a balance above zero. Sort the results by Balance with the largest Balance at the top of the list.

Q$4.$ Use the AP database for this question. Write a SQL query that displays AccountNo and AccountDescription from the GLAccounts table. The result set should have one row for each account number that has never been used. Sort on AccountNo. Hint: Use an outer join to the InvoiceLineItems table.

Q$5.$ Use the AP database for this question. Use the UNION operator to display the VendorName and VendorState. If the Vendor is in California, the VendorState value should be $$CA$$; otherwise the VendorState value should be $$Outside CA$.$ Sort on VendorName.

Q$6.$ Use the AP database for this question. Write a SQL query to display VendorName and PaymentSum with PaymentSum being the sum of the PaymentTotal column. Group the result set by VendorName and return only $10$ rows, corresponding to the $10$ vendors who$$ve been paid the most $.$

Q$7.$ Use the AP database for this question. Write a SQL query that displays the AccountNo and the total amount invoiced for each AccountNo as LineItemSum. Use the WITH ROLLUP operator to include a grand total row.