Question

Write a SELECT statement that returns these four columns:
vendor name -
invoice number
i11voice date
balance due
The vendor_name column from the Vendors table
The invoice number column from the Invoices table
The invoice date coltrmn 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.

Answer 1

A SELECT command pulls zero or more rows from one or more database tables or views. SELECT is the most often used data manipulation language (DML) command in most applications. See the statement required below.

What is the SELECT Statement that gives the above results?

SELECT VendorName, InvoiceNumber, InvoiceDate,

InvoiceTotal - PaymentTotal - CreditTotal AS Balance

FROM Vendors JOIN Invoices

ON Vendors.VendorID = Invoices.VendorID

WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0

ORDER BY VendorName;

Learn more about SELECT Statements at;

https://brainly.com/question/19338967
#SPJ1