Untitled query #56722

SQL

WITH seImpressions AS (
    SELECT
        dt,
        wiki,
        str_to_map(event.action_data, ";", "=") AS action_data
    FROM event.homepagemodule
    WHERE
        year=2021
        AND month=6
        AND day=25
        AND event.action='impression'
        AND event.module='suggested-edits'
),

taskCountData AS (
    SELECT
        wiki,
        action_data['topics'] AS topics,
        action_data['taskCount'] AS task_count_num,
        CASE
            WHEN action_data['taskCount'] == 0 THEN '0'
            ELSE '>1'
        END AS task_count_human
    FROM seImpressions
    WHERE
        action_data['topics'] != ''
)

SELECT
    wiki,
    task_count_human,
    COUNT(*)
FROM taskCountData
GROUP BY wiki, task_count_human
ORDER BY wiki, task_count_human
SQL

Checking query status...
