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.

. 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 . 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.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *