WITH parents AS
  (SELECT uid,
          region,
          full_reg_datetime::date as full_reg_datetime
   FROM analytics.parent_properties
   WHERE full_reg_datetime >= '2025-03-28'
     AND full_reg_datetime < today() - interval '2' DAY),
     actions AS
  (SELECT uid,
          full_reg_datetime,
          count(dt) >= 2 AS flg_2_or_more
   FROM analytics.parent_actions
   JOIN parents USING uid
   GROUP BY 1, 2)
SELECT * FROM actions;