. . . . . . . "/*[sqlquery[*/ SELECT \r\n policy_amount_attached.policy_amount_identifier, \r\n policy_amount_attached.policy_amount, \r\n policy_amount_attached.amount_type_code , \r\n CASE when policy_amount_attached.amount_type_code = 'Year' then policy_amount_attached.policy_amount/12 end as monthly_policy_amount, \r\n policy_amount_attached.policy_coverage_detail_identifier\r\n FROM demo.acme.policy_amount_attached \r\n JOIN demo.acme.premium_attached ON policy_amount_attached.policy_amount_identifier = premium_attached.policy_amount_identifier\n/*]sqlquery]*/" . . . . . . . . . .