Write a SELECT statement that returns three columns:

Write a SELECT statement that returns three columns: VendorID from the Vendors table, VendorName from the vendors table, Name (A concatenation of VendorContactFName and VendorContactLName, with a space in between).

Write a SELECT statement that returns all columns from the Vendors table inner-joined with the Invoices table

Write a SELECT statement that returns four columns: VendorName from the Vendors table, InvoiceNumber from the Invoices table, InvoiceDate from the invoices table, and Balance which is InvoiceTotal minus the sum of PaymentTotal and CreditTotal.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]