---

sample_sharers AS MATERIALIZED (
    SELECT s.id
    FROM latest_death_info di
    JOIN ourpension.sharer s
      ON s.individual_id = di.individual_id
    JOIN ourpension.contract c
      ON c.id = s.contract_id
    WHERE c.service_type = 'OPS'
      AND EXISTS (
          SELECT 1
          FROM report.dia_param p
          WHERE di.death_date <= p.report_date
      )
    ORDER BY di.individual_id, s.id
    LIMIT 1000
    OFFSET 200
),