Hi,

I am working on SQL in Oracle APEX database system. I am stuck on question 1 and question 4. I was wondering if you can just show the answer. I have tried several different ways and still appear to get an error message. Below are the questions.

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

Not Completed stuck

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

Completed

3.Generate a list of product description, product price, vendor name, vendor contact, vendor area code, and vendor phone number for products with the invoice date after 17-Jan-2012

Completed

4.Find the number of customers in each area code (Use Group by)

Not Completed

5.List the number of products in the inventory supplied by each vendor. Limit the list to products whose price average less than $10. (Use Group by and Having)

Completed