Answer to Question #16134 in Databases | SQL | Oracle | MS Access for ITstudentRY

Question

My professor refuses to answer homework questions in any form, and all she does in class is read a pre-made powerpoint that the company gave her. I could really use some help with this one:

Write a SELECT statement that returns four columns: VendorName, InvoiceID, InvoiceSequence, and InvoiceLineItemAmount for each invoice that has more than one line item in the InvoiceLineItems table. (Hint: Use a subquery that tests for InvoiceSequence > 1 )