/*[sqlquery[*/ SELECT
policy_amount.policy_amount_identifier,
policy_amount.policy_amount ,
policy_amount.amount_type_code ,
CASE when policy_amount.amount_type_code = 'Year' then policy_amount.policy_amount/12 end as monthly_policy_amount,
policy_amount.policy_coverage_detail_identifier
FROM demo.acme.policy_amount
JOIN demo.acme.premium ON policy_amount.policy_amount_identifier = premium.policy_amount_identifier
/*]sqlquery]*/