(Solved) : 1 Write One Select Statement Given Space Beneath Problem Description Answer Query Query 1 Q26491925 . . . .

1.

–Write one SELECT statement in the given space beneath eachproblem

description

–to answer the query. Query 1 requires two SELECTstatements.

–Each clause of SELECT, FROM, WHERE, and ORDER BY is expectedto be coded

on its own

–line and each line is left justified.

–Only one SELECT statement is allowed to be the answer of eachquery. If

you include

Write a SELECT statement that returns four columns:

VendorName From the Vendors table

InvoiceNumber From the Invoices table

InvoiceDate From the Invoices table

Balance Derived from the Invoices table,

i.e., InvoiceTotal minus the sum of PaymentTotal andCreditTotal

The result set should have one row for each invoice with anon-zero balance. Sort the result set by VendorName