In SQL

1.Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the employee lastname and the first initial of the first name. The second column, Phone, is the homephone without the area code. Only return rows for those employees in the 206 area code, sort the results by the last name.

2.Write a SELECT statement, using the invoices table,that returns the invoicenumber and balance due to every invoice with a non-zero balance and an InvoiceDueDate thats less than 30 days from today.

3.Modify the search expression for invoiceduedate from the solution in exercise 2. Rather than 30 days from today, return invoices due before the last day of the current month.

4.Add a column to the query described in question 2 that uses the RANK() function to return a column named BalanceRank that ranks the balance due in descending order.

I cant attach a photo of the schema because chegg claims the questions is to long then....?????