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