Write a select statement that returns 3 columns: VendorName BalanceDue (calculated column that displays balance owed...

Transcribed Image Text:

Write a select statement that returns 3 columns:• VendorName BalanceDue (calculated column that displays balance owed on an invoice) • TermsDescription Filter the results to only return rows where the balance owed in less than 10000 and TermsID is equal to 3. Sort the results by Vendor Name and BalanceDue from largest to smallest. Write a select statement that returns 3 columns:• VendorName BalanceDue (calculated column that displays balance owed on an invoice) • TermsDescription Filter the results to only return rows where the balance owed in less than 10000 and TermsID is equal to 3. Sort the results by Vendor Name and BalanceDue from largest to smallest.

Answer rating: 100% (QA)

SELECT VendorsVendorName InvoiceLineltemsAmount InvoicesPaid AS BalanceDue TermsDescription FROM Vendors INNER JOIN Invoices ON VendorsVendorID Invoic... View the full answer