(Solved) : Write Select Statement Returns Four Columns Vendorname Invoicenumber Invoicedate Balanced Q29224428 . . .
This is from Murach’s MySQL 2nd Edititon (pages 146-147)
. Write a SELECT statement that returns these four columns: vendor_name invoice_number invoice_date balance_due The vendor name column from the Vendors table The invoice_number column from the Invoices table The invoice_date column from the Invoices table The invoice total column minus the payment_total and credit_total columns from the Invoices table Use these aliases for the tables: v for Vendors and i for Invoices. Return one row for each invoice with a non-zero balance. This should return 11 rows. Sort the result set by vendor_name in ascending order. Show transcribed image text
Expert Answer
Answer to Write Select Statement Returns Four Columns Vendorname Invoicenumber Invoicedate Balanced Q29224428 . . .
OR