All Questions
Growing Fund
00:00:00
Parts
Part 1
A multi-billion dollar hedge fund has many subsidiary funds that each have their own investment thesis. Certain investors like to allocate their capital to specific funds based on their opinion on the efficacy of the fund's investment thesis.
Using the tables below, for each fund find the largest percent change in the month over month number of investors that the fund acquired in 2023. Output the fund's name, month with the largest percent increase, previous month's number of investors, current month's number of investors, and the percent change. Order the resulting data by the percent change in investors in descending order and then the fund's name in ascending order.
Guidelines
- For January, the percent change in how many investors the fund acquired should be null.
- If a fund has two months with an identical percent change in the number of investors, choose the percent increase that corresponds to the earlier month.
- Round the percent change to two decimals.
Example Output
fund_name | month | curr_mon_investor_cnt | prev_mon_investor_cnt | perc_change |
---|---|---|---|---|
Alpha Fund | Feb | 13 | 4 | 225% |
Beta Fund | Mar | 73 | 62 | 17.74% |
Delta Fund | Dec | 44 | 42 | 4.76% |
Input Tables
funds
Column Name | Data Type |
---|---|
fund_id | bigint |
fund_name | text |
fund_manager_name | text |
fund_established_dt | datetime |
fund_investors
Column Name | Data Type |
---|---|
investor_id | bigint |
fund_id | bigint |
initial_investment_amt | float |
initial_investment_dt | datetime |