In SQL,

3. Write a SELECT statement that returns these columns from the Vendors table: - The vendor name column - The vendor name column in all capital letters - The vendor phone column - A column that displays the last 4 digits of each phone number When you get that working right, add the Columns that follow to the result set. This is more difficult because these columns require the use of functions within functions. - The vendor_phone column with the parts of the number separated by dots. Ex. 555.555.5555 - A column that displays the second word in each vendor_name if there is one, and blanks if there isnt.

4. Write a SELECT statement that returns these columns from the Invoices table: - The invoice_number column - The invoice_date column - The invoice_date column plus 30 days - The payment_date column - A column named DAYS_TO_PAY that shows the number of days between the invoice date and the payment date - The number of the invoice_date's month - The four-digit year of the invoice date When you have this working, add a WHERE clause that retrieves just the invoices for the month of May based on the invoice date, not the number of the invoice month.