4.Write a SELECT statement that returns four columns: vendor_name, invoice_id, i

Question

4.Write a SELECT statement that returns four columns: vendor_name, invoice_id, invoice_sequence, and line_item_amt for each invoice that has more than one line item in the Invoice_Line_Items table. Hint: Use a subquery that tests for invoice_sequence > 1.

5. Write a SELECT statement that returns a single value that represents the sum of the largest unpaid invoices for each vendor (just one for each vendor). Use an inline view that returns MAX(invoice_total) grouped by vendor_id, filtering for invoices with a balance due.

6. Rewrite exercise 5 so it uses subquery factoring

7. Write a SELECT statement that returns the name, city, and state of each vendor that

Explanation / Answer

Please rate it: 4) select vendor_name,invoice_id,invoice_sequence,line_item_amt from Invoice_Line_Items where invoice_sequence In ( select invoice_sequencce from Invoice_Line_Items where invoice_sequence>1 5) select sum(MAX(invoice_total) from ( select vendor_id,Max(invoice_total) from Invoice_Line_Items group by vendor_id

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.