Listed are the needed columns from each table. vendors table columns: vendor_id

Question

Listed are the needed columns from each table.

vendors table columns:

vendor_id

vendor_name

invoices table columns:

invoice_id

vendor_id

invoice_total

payment_total

credit_total

****(invoice_total - payment_total - credit_total) = balance due ****

Create a view named open_items_summary that returns one summary row for each vendor that contains invoices with unpaid balance dues. Each row should include vendor_name, open_item_count (the number of invoices with a balance due), and open_item_total (the total of the balance due amounts), and the rows should be sorted by the open item totals in descending sequence. Then, run the script to create the view, and use SQL Developer to review the data that it returns.

Explanation / Answer

Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed.

So you need to add

GROUP BY VENDOR_NAME

before the,

ORDER_BY OPEN_ITEM_TOTAL DESC

and than it should work

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

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