Using the following tables:

1.List the full name of members who are not from the state of IN nor IL.

2.List the full name of each member and the full names of the employees who ever

assisted that member on a transaction.

3.List the full name and full address of the member who has the highest credit limit.

4.List the full name, title, and department of the employee who handled online

transactions.

5.List the member ID, full name, and credit limit of each customer whose credit limit is

greater than the average credit limit of all members.

6.List the member ID and the total number of transactions made by the members whose

name (including first name and/or last name) contains letter R.

7.List the member ID, full name and address of the members who have made a

transaction.

8.List the total number of transactions handled by each employee at each location (IN

store, IL store, or Online).

9.List the Employee ID and full name of the employees whose salary is above the average.

10.List the full name and the total number of transactions handled by the full time

employee. Rank your results in descending order on the total number of transactions.

Table: MEMBERS Column Data Type Length Precision Scale Nullable MEMBERID NUMBER 4 0 No MFIRST VARCHAR2 25 No MLAST VARCHAR2 25 No STREET VARCHAR2 64 No CITY VARCHAR2 25 . No STATE VARCHAR2 2 . No ZIPCODE NUMBER 0 No CREDITLIMIT NUMBER 7 2 No GENDER VARCHAR2 - No