Write SQL queries for the following: (submit the query and a screenshot of the results)

1. Display the maximum total_payment of invoices. (5 Points)

2. List the number of VENDORS in each state and the number should be greater than 5. (20 points)

3. List the vendor_ID, vendor NAME for those who have not payed an invoice. (15 Points)

4. List the vendor_ID, vendor NAME and the number of invoices for each vendor . List only those that have more than 2 invoices. (20 Points)

5. List the invoice_id for the highest invoice value. [Use sub-query. Do not hard-code the value] (20 points)

6. Write a SQL query to create a sequence MYSEQ, that starts from 10 and increment by 5. Display the next value in the sequence. (Submit two queries. One for creating the sequence and the other for displaying the next value.) (20 points)