Question

Write a SELECT statement that returns these four columns:

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;

brainly.com/question/19338967
#SPJ1