/*[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]*/