/*[sqlquery[*/ SELECT CAST(policy_amount_identifier as VARCHAR) as policy_amount_identifier, CAST(policy_amount.policy_amount as INTEGER) as policy_amount, CAST(policy_amount.policy_coverage_detail_identifier as VARCHAR) as policy_coverage_detail_identifier
FROM demo.acme.policy_amount
WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium )
/*]sqlquery]*/
/*[sqlquery[*/ SELECT CAST(policy_amount_identifier as VARCHAR) as policy_amount_identifier, CAST(policy_amount.policy_amount as INTEGER) as policy_amount, CAST(policy_amount.policy_coverage_detail_identifier as VARCHAR) as policy_coverage_detail_identifier
FROM demo.acme.policy_amount
WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium )
/*]sqlquery]*/
/*[sqlquery[*/ SELECT CAST(policy_amount_identifier as VARCHAR) as policy_amount_identifier, CAST(policy_amount.policy_amount as INTEGER) as policy_amount, CAST(policy_amount.policy_coverage_detail_identifier as VARCHAR) as policy_coverage_detail_identifier
FROM demo.acme.policy_amount
WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium )
/*]sqlquery]*/
/*[sqlquery[*/ SELECT CAST(policy_amount_identifier as VARCHAR) as policy_amount_identifier, CAST(policy_amount.policy_amount as INTEGER) as policy_amount, CAST(policy_amount.policy_coverage_detail_identifier as VARCHAR) as policy_coverage_detail_identifier
FROM demo.acme.policy_amount
WHERE policy_amount_identifier not in (SELECT policy_amount_identifier FROM demo.acme.premium )
/*]sqlquery]*/