1. A SELECT statement that returns all columns from the Vendors table inner-joined with the invoices table.
2. A SELECT statement that returns four columns:
VendorName From the Vendors table
InvoiceNumber From the Invoices table
InvoiceDate From the Invoices table
Balance InvoiceTotal minus the sum of PaymentTotal and CreditTotal.
the result set should have one row for each invoice with a non-zero balance. Sort the result set by VendorName in ascending order.
3. A SELECT statement that returns three columns:
VendorName From the Vendors table
DefaultAccountNo From the Vendors table
AccountDescription From the GLAccounts table
4. Generate the same result set described in exercise 2, but use the implicit join syntax.