child_id_per_parent

SELECT
    uid,
    count(*) AS children_id,
    countIf(json_data.3 = 'approved') AS children_id_approved
FROM
    analytics.parent_properties
ARRAY JOIN
    children AS json_data
WHERE last_active_datetime >= today() - interval '7' day
and is_full_register
GROUP BY 1