SELECT
    region,
    visitParamExtractString(addJson, 'permission') AS permission,
    visitParamExtractString(addJson, 'result') AS result,
    CASE
        WHEN deviceType = 2 AND appVersion % 2 = 0 THEN 'iOS_Parent'
        WHEN deviceType = 1 AND appVersion % 2 = 1 THEN 'Android_Parent'
        WHEN deviceType = 2 AND appVersion % 2 = 1 THEN 'iOS_Child'
        WHEN deviceType = 1 AND appVersion % 2 = 0 THEN 'Android_Child'
        ELSE 'Unknown'
    END AS platform,
    uniqCombined(uid) AS users
FROM
    stat.funnelTrack
WHERE
    dt >= yesterday() - interval '7 day'
    AND action = 'child_permissions_permission_result'
    AND FMKIsAndroidChild(deviceType, appVersion)
    -- AND permission IN ('AllowContacts', 'CallService')
GROUP BY
    1,2,3,4
ORDER BY 1,2,3,4;