DataBase MYSQL:

Write a SELECT statement that joins the Invoices table to the Vendors table and returns these 4 columns: invoice id vendor_name The vendor_name column Invoice number The invoice_number column from Invoices table Invoice_date The invoice_date column from the Invoices table balance_due The invoice_total column - (the payment_total column+ credit_total The invoice id column column) Use these aliases for the tables: v for Vendors and for Invoices. Return one row for each invoice with non-zero balance