Given the MS Access database schema located in the following link: http://faculty.baruch.cuny.edu/rholowczak/classes/3400/assign3/cis3400_assignment3_sql_Fall2018.pdf

Download the "hedge_fund.accdb" file 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) 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.

Show me the picture of results as well. Thank you

* The table structure are the followings:

-Client Disbursements:

-Clients:

- Deposits:

Fund Allocations:

Investment Funds:

FundAllocations ClientDisbursements Data Type Field Name DisbursementID DisbursementDate DisbursementAmou DestinationBankAccount Short Text ClientID FundID AutoNumber Date/Time Number nt FundAllocations ClientDisbursements Data Type Field Name DisbursementID DisbursementDate DisbursementAmou DestinationBankAccount Short Text ClientID FundID AutoNumber Date/Time Number nt