Given the MS Access database schema 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.

*The below table is the reference

Client Disbursement Table:

Client Table:

Deposit Table:

Fund Allocation Table:

Investment Funds Table:

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