regression-test/suites/variant_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql

SELECT
    repo_name,
    sum(issue_created) AS c,
    count(distinct actor_login) AS u,
    sum(star) AS stars
FROM
(
    SELECT
        cast(repo["name"] as string) as repo_name,
        CASE WHEN (type = 'IssuesEvent') AND (cast(payload["action"] as string) = 'opened') THEN 1 ELSE 0 END AS issue_created,
        CASE WHEN type = 'WatchEvent' THEN 1 ELSE 0 END AS star,
        CASE WHEN (type = 'IssuesEvent') AND (cast(payload["action"] as string) = 'opened') THEN cast(actor["login"] as string) ELSE NULL END AS actor_login 
    FROM github_events
    WHERE type IN ('IssuesEvent', 'WatchEvent')
) t
GROUP BY repo_name
ORDER BY c DESC, repo_name
LIMIT 50