Given the MS Access database schema located in the file http://faculty.baruch.cuny.edu/rholowczak/classes/3400/assign3/hedge_fund.accdb, answer the following queries by writing out the SQL statements:

1) Show the names and home states of any clients living in New Jersey who have invested in the MidCap

Technology fund.

2) Show the ClientID, First and last names and date joined for clients who have deposited more than $60,000

and allocated the funds into a Growth fund.

3) Show the ClientID, First and last names and date joined and the total amount each client has deposited.

4) Show the FundID and names of fund managers who manage Commodities investment funds.

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

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

7) Show the Investment FundID, Fund Name, Fund Manager and Date the fund started, of any funds that have

not received any allocations.

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

Extra Credit

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.