Exercise 2 The Fibonacci numbers are the sequence of numbers F₁, F2, F3, ... where: • F₁ = F₂ = 1 • F=Fn-1 + Fn-2 The Fibonacci numbers for n = 1, 2, ..., 8 are 1, 1, 2, 3, 5, 8, 13, 21. Use the function design recipe to develop a function named fib. The function header (with missing type annotations) is: fib(n). Parameter n is a positive integer. The function returns the n'th Fibonacci number. For example, fib(1) returns 1 and fib(6) returns 8. Your function must have exactly one loop. Your solution must Your function definition must have type annotations and a complete docstring. Use the Python shell to test fib.

Task 1: List the owner number, the owner's first name as FIRST and the owner's last name as LAST for all owners. The first name should appear in uppercase letters and the last name should appear in lowercase letters.

Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)

9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor. Return 3 Columns: The vendor id from the Invoices table. The balance due (invoice_total-payment_total-credit_total) for each invoice in the invoices table with a balance greater than 0. The total balance due for all vendors in the Invoices table. Modify the column that contains the balance due for each vendor so it contains a cumulative total by balance due.