Please help with my SQL!!

Please answer the following questions by using the chart.

Display a list of invoice number, invoice customer code, customer last name, and customer first name.

Display a list of invoice number, product code, product description, lint units, and line price.

Generate a list of vendors who do not provide products.

Generate a list of product description, product price, vendor name, vendor contact, vendor are code, and vendor phone number for products with the invoice date after 15-Jan-2014

List the customer last name, invoice number, invoice date, and product description for all invoices for customer 10014.

Find all product with the price greater than or equal to the average product price. (use subquery)

List all products with a total quantity sold greater than the average quantity sold.