I basically trying to get the risk analysis of my investment within each investment plan (say P1 and P2_.
I like to know what is my total amount of investment for each plan in each risk category.
For Plan P2, my investment is mainly in two seperate category (2 and 3). The category 2 have only 1 investment, it totals to 20, Category 3 have two investment, it totals up to 70.

Let me know if that make sense.

I like to create a stored procedure given the Plan code, I will provide the risk analysis of the investment within the plan

A Plan have one or more investment
Each investment is one of the fund in #fund
Each fund is associated with certain risk defined in the Risk field '1, 2 or 3'
Label of the Risk is defined in the #Risk table

Featured Post

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.