ive distribution continuous distribution discrete distribution logical functions ranking functions analytic functions Exercises 1. table. The first column, Contact, is the vendor contact name in this format: Write a SELECT statement that returns two columns based on the Vendors column, Phone, is the VendorPhone column without the area code. Only first name followed by last initial (for example, "John S!) The second return rows for those vendors in the 559 area code. Sort the result set by first 2. Write a SELECT statement that returns the InvoiceNumber and balance due for every invoice with a non-zero balance and an Invoice DueDate that's less 3. Modify the search expression for InvoiceDueDate from the solution for exercise 2. Rather than 30 days from today, return invoices due before the last name, then last name. than 30 days from today. day of the current month. 4. Write a summary query WITH CUBE that returns LineItemSum (which is the sum of InvoiceLineItemAmount) grouped by Account (an alias for AccountDescription) and State (an alias for VendorState). Use the CASE and GROUPING function to substitute the literal value "* ALL*" for the summary rows with null values. 5. Add a column to the query described in exercise 2 that uses the RANKO) function to return a column named BalanceRank that ranks the balance due i descending order. Shanol