Question: Given the MS Access database schema located in the link http://faculty.baruch.cuny.edu/rholowczak/classes/3400/assign.html -> Assignment 3 Structured Query Language Assignment -> Download hedge_fund.accdb and answer

Given the MS Access database schema located in the link

http://faculty.baruch.cuny.edu/rholowczak/classes/3400/assign.html -> Assignment 3 "Structured Query Language Assignment" -> Download "hedge_fund.accdb" and answer the following queries by writing out the SQL statements:

1) Show the ClientID, First and last names and date joined of the client that has referred the most other clients.

2) Show the Investment FundID, Fund Name, and Fund Manager of the fund with the largest total allocations.

3) Show the Investment FundID, Fund Name, Fund Manager and Date the fund started, of any funds that have not received any allocations.

4) Find the shortest number of days between when a client makes a deposit and then receives a disbursement.

5)We can calculate the current basis of a fund as the total amount allocated less the total amount disbursed. For each Investment fund, show the FundID, Fund Name, Fund Manager and current basis.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!