regression-test/suites/github_events_p2/sql/starsFromHeavyGithubUsers1.sql - doris - Git at Google

 SELECT
     repo_name,
     count()
 FROM github_events
 WHERE (event_type = 'WatchEvent') AND (actor_login IN
 (
     SELECT actor_login
     FROM github_events
     WHERE (event_type = 'PullRequestEvent') AND (action = 'opened')
 ))
 GROUP BY repo_name
 ORDER BY count() DESC
 LIMIT 50
	SELECT
	repo_name,
	count()
	FROM github_events
	WHERE (event_type = 'WatchEvent') AND (actor_login IN
	(
	SELECT actor_login
	FROM github_events
	WHERE (event_type = 'PullRequestEvent') AND (action = 'opened')
	))
	GROUP BY repo_name
	ORDER BY count() DESC
	LIMIT 50