Please write queries based on the following requirements using Oracle iSQL.

Write the SQL query to create the following tables and input the records in each table. The primary key is underlined and foreign key is made italic. Include a screen shot of each table with all the records in Oracle. Input yourself as a new member to Table "Members". You should make up an appropriate MemberlD and you are free to use a fake address, and phone number etc. but you must use your first and last name. Include a screen shot of Members Table with your information. List the full name and full address of the member who has the highest credit limit. List the full name, title, and department of the employee who handled online transactions. 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. List the member ID and the total number of transactions made by the members whose first name contains letter "R". List the member ID, full name and address of the members who have made a transaction. List the total number of transactions handled by each employee at each location (IN store, IL store, or Online). List the Employee ID and full name of the employees whose salary is above the average. 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