1. Write a SELECT statement that returns all columns from the Vendors table inner-joined with the Invoices table. 2. Write a SELECT statement that returns four columns: 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. Write a SELECT statement that returns three columns: The result set should have one row for each vendor, with the account number and account description for that vendor's default account number. Sort the result set by AccountDescription, then by VendorName. 4. Generate the same result set described in exercise 2 , but use the implicit join syntax