Problem
A. List the full name of members who are not from the state of IN nor IL.
B. List the full name of each member and the full names of the employees' who ever assisted that member on a transaction.
C. List the full name and full address of the member who has the highest credit limit.
D. List the full name, title, and department of the employee who handled online transactions.
E. 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
F. 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".
G. List the member ID, full name and address of the members who have made a transaction.
H. List the total number of transactions handled by each employee at each location (IN store, IL store, or Online).
I. List the Employee ID and full name of the employees whose salary is above the average.
J. 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.