Question: Task 1 7 : List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain

Task 17: List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain an invoice line for Wild Bird Food (25lb).
SELECT I.INVOICE_NUM, I.INVOICE_DATE
FROM INVOICES I
INNER JOIN CUSTOMER C
ON I.CUST_ID = C.CUST_ID
INNER JOIN INVOICE_LINE L
ON I.INVOICE_NUM = L.INVOICE_NUM
INNER JOIN ITEM T
ON L.ITEM_ID = T.ITEM_ID
WHERE T.DESCRIPTION <> "Wild Bird Food (25 lb)"
AND (C.FIRST_NAME = "James" AND C.LAST_NAME = "Gonzalez");

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!