Five-year premium projection
AIA's actuarial team wants a quick 5-year premium projection, assuming each policy's premium compounds annually at its own escalation_rate.
From the policies table, return policy_no and projected_premium, where projected_premium is annual_premium compounded annually for 5 years at escalation_rate, rounded to 2 decimal places.
Schema
▸policies
| policy_no | TEXT |
| annual_premium | NUMERIC |
| escalation_rate | NUMERIC |
Basic
The example input, expected output, and walkthrough for this question unlock with a Basic plan.
Basic
The reference solution and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime