WITH aggUsageIntermediate AS (
    SELECT DISTINCT
        child AS id
    FROM
        stat.appUsageWithAggregated
    WHERE
        dt >= today() - INTERVAL '7' DAY),
filteredChildProperties AS (
    SELECT id, uid
    FROM
        analytics.child_properties
    WHERE
        last_state_datetime >= today() - INTERVAL '7' DAY
),
filteredPermissions AS (
    SELECT DISTINCT
        uid
    FROM
        stat.funnelTrack join filteredChildProperties using uid
    WHERE
        action = 'child_permissions_permission_result'
        AND dt >= '2016-01-01'
        AND FMKIsAndroidChild(deviceType, appVersion)
        AND visitParamExtractString(addJson, 'permission') = 'AppUsageStatistics'
        AND visitParamExtractString(addJson, 'result') = 'Granted'
),
filteredHighlights AS (
    SELECT DISTINCT
        user_id AS id
    FROM
        wimc.statistics_highlights
    WHERE
        ts_created >= today() - INTERVAL '7' DAY
)
SELECT
fp.uid != '' as flg_HasPermissions,
fh.id > 0 as flg_HasHighlights,
aui.id > 0 as flg_HasAppStat,
round(uniqExact(fcp.uid), -1) as users,
users / SUM(users) over () as share
FROM filteredChildProperties fcp
LEFT JOIN filteredPermissions fp on fp.uid = fcp.uid
LEFT JOIN filteredHighlights fh on fh.id = fcp.id
LEFT JOIN aggUsageIntermediate as aui on aui.id = fcp.id
group by 1, 2, 3
ORDER BY flg_HasPermissions, flg_HasAppStat, flg_HasHighlights;