You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2022/09/25 15:46:23 UTC
[doris] branch master updated: [enhancement](test) add github events cases to p2 (#12696)
This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 60556070bb [enhancement](test) add github events cases to p2 (#12696)
60556070bb is described below
commit 60556070bbc932e74cab59d1b7499398b7b0378d
Author: Yongqiang YANG <98...@users.noreply.github.com>
AuthorDate: Sun Sep 25 23:46:15 2022 +0800
[enhancement](test) add github events cases to p2 (#12696)
---
.../sql/affinityByIssuesAndPRs1.out | 52 ++++++++
.../sql/affinityByIssuesAndPRs2.out | 52 ++++++++
.../data/github_events_p2/sql/countingStar1.out | 4 +
.../data/github_events_p2/sql/countingStar2.out | 4 +
.../data/github_events_p2/sql/countingStar3.out | 4 +
.../sql/distributionOfRepositoriesByStarCount.out | 9 ++
.../data/github_events_p2/sql/githubRoulette.out | 53 ++++++++
...heListOfTopRepositoriesChangedOverTheYears1.out | 53 ++++++++
...heListOfTopRepositoriesChangedOverTheYears2.out | 53 ++++++++
...heListOfTopRepositoriesChangedOverTheYears3.out | 53 ++++++++
...heListOfTopRepositoriesChangedOverTheYears4.out | 53 ++++++++
...heListOfTopRepositoriesChangedOverTheYears5.out | 53 ++++++++
...heListOfTopRepositoriesChangedOverTheYears6.out | 53 ++++++++
.../howHasTheTotalNumberOfStarsChangedOverTime.out | 13 ++
.../sql/issuesWithTheMostComments1.out | 4 +
.../sql/issuesWithTheMostComments2.out | 53 ++++++++
.../sql/issuesWithTheMostComments3.out | 53 ++++++++
.../sql/issuesWithTheMostComments4.out | 53 ++++++++
.../sql/issuesWithTheMostComments5.out | 53 ++++++++
.../sql/issuesWithTheMostComments7.out | 53 ++++++++
.../sql/issuesWithTheMostComments8.out | 53 ++++++++
.../sql/mostForkedRepositories.out | 53 ++++++++
.../sql/organizationsByTheNumberOfRepositories.out | 52 ++++++++
.../sql/organizationsByTheNumberOfStars.out | 53 ++++++++
.../sql/proportionsBetweenStarsAndForks1.out | 53 ++++++++
.../sql/proportionsBetweenStarsAndForks2.out | 53 ++++++++
.../sql/proportionsBetweenStarsAndForks3.out | 53 ++++++++
.../sql/proportionsBetweenStarsAndForks4.out | 4 +
.../sql/proportionsBetweenStarsAndForks5.out | 4 +
.../sql/repositoriesByAmountOfModifiedCode.out | 53 ++++++++
.../sql/repositoriesByTheNumberOfPushes.out | 53 ++++++++
...epositoriesWithClickhouse_related_comments1.out | 52 ++++++++
...epositoriesWithClickhouse_related_comments2.out | 52 ++++++++
.../repositoriesWithDoris_related_comments1.out | 52 ++++++++
.../repositoriesWithDoris_related_comments2.out | 52 ++++++++
.../sql/repositoriesWithTheHighestGrowthYoY.out | 53 ++++++++
.../repositoriesWithTheMaximumAmountOfIssues1.out | 53 ++++++++
.../repositoriesWithTheMaximumAmountOfIssues2.out | 53 ++++++++
.../repositoriesWithTheMaximumAmountOfIssues3.out | 53 ++++++++
.../repositoriesWithTheMaximumAmountOfIssues4.out | 53 ++++++++
...sitoriesWithTheMaximumAmountOfPullRequests1.out | 53 ++++++++
...sitoriesWithTheMaximumAmountOfPullRequests2.out | 53 ++++++++
...esWithTheMaximumNumberOfAcceptedInvitations.out | 53 ++++++++
.../repositoriesWithTheWorstStagnation_order.out | 53 ++++++++
.../sql/repositoryAffinityList1.out | 53 ++++++++
.../sql/starsFromHeavyGithubUsers1.out | 53 ++++++++
.../sql/starsFromHeavyGithubUsers2.out | 53 ++++++++
.../sql/theLongestRepositoryNames1.out | 53 ++++++++
.../sql/theLongestRepositoryNames2.out | 53 ++++++++
.../sql/theMostToughCodeReviews.out | 52 ++++++++
.../sql/theTotalNumberOfUsersOnGithub1.out | 4 +
.../sql/theTotalNumberOfUsersOnGithub2.out | 4 +
.../sql/theTotalNumberOfUsersOnGithub3.out | 4 +
.../sql/theTotalNumberOfUsersOnGithub4.out | 4 +
.../sql/topRepositoriesByStars.out | 53 ++++++++
.../sql/whatIsTheBestDayOfTheWeekToCatchAStar.out | 10 ++
.../sql/whoAreAllThosePeopleGivingStars1.out | 53 ++++++++
.../sql/whoAreAllThosePeopleGivingStars2.out | 4 +
.../sql/whoAreAllThosePeopleGivingStars3.out | 53 ++++++++
.../suites/github_events_p2/ddl/github_events.sql | 88 +++++++++++++
.../suites/github_events_p2/load.groovy | 139 +++++++++++++++++++++
.../sql/affinityByIssuesAndPRs1.sql | 14 +++
.../sql/affinityByIssuesAndPRs2.sql | 14 +++
.../sql/authorsWithTheMostPushes.sql | 9 ++
.../suites/github_events_p2/sql/countingStar1.sql | 1 +
.../suites/github_events_p2/sql/countingStar2.sql | 1 +
.../suites/github_events_p2/sql/countingStar3.sql | 1 +
.../sql/distributionOfRepositoriesByStarCount.sql | 14 +++
.../sql/findingFriendsThroughCountingStars.sql | 31 +++++
.../suites/github_events_p2/sql/githubRoulette.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears1.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears2.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears3.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears4.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears5.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears6.sql | 1 +
...heListOfTopRepositoriesChangedOverTheYears7.sql | 28 +++++
.../howHasTheTotalNumberOfStarsChangedOverTime.sql | 1 +
.../sql/issuesWithTheMostComments1.sql | 1 +
.../sql/issuesWithTheMostComments2.sql | 1 +
.../sql/issuesWithTheMostComments3.sql | 17 +++
.../sql/issuesWithTheMostComments4.sql | 9 ++
.../sql/issuesWithTheMostComments5.sql | 9 ++
.../sql/issuesWithTheMostComments6.sql | 11 ++
.../sql/issuesWithTheMostComments7.sql | 9 ++
.../sql/issuesWithTheMostComments8.sql | 12 ++
.../sql/mostForkedRepositories.sql | 1 +
.../sql/mostPopularCommentsOnGithub.sql | 1 +
.../sql/organizationsByTheNumberOfRepositories.sql | 14 +++
.../sql/organizationsByTheNumberOfStars.sql | 8 ++
.../sql/organizationsByTheSizeOfCommunity.sql | 23 ++++
.../sql/proportionsBetweenStarsAndForks1.sql | 17 +++
.../sql/proportionsBetweenStarsAndForks2.sql | 18 +++
.../sql/proportionsBetweenStarsAndForks3.sql | 18 +++
.../sql/proportionsBetweenStarsAndForks4.sql | 13 ++
.../sql/proportionsBetweenStarsAndForks5.sql | 21 ++++
.../sql/repositoriesByAmountOfModifiedCode.sql | 12 ++
.../sql/repositoriesByTheNumberOfPushes.sql | 17 +++
...epositoriesWithClickhouse_related_comments1.sql | 1 +
...epositoriesWithClickhouse_related_comments2.sql | 17 +++
.../repositoriesWithDoris_related_comments1.sql | 1 +
.../repositoriesWithDoris_related_comments2.sql | 17 +++
.../sql/repositoriesWithTheHighestGrowthYoY.sql | 20 +++
.../repositoriesWithTheMaximumAmountOfIssues1.sql | 1 +
.../repositoriesWithTheMaximumAmountOfIssues2.sql | 18 +++
.../repositoriesWithTheMaximumAmountOfIssues3.sql | 19 +++
.../repositoriesWithTheMaximumAmountOfIssues4.sql | 18 +++
...sitoriesWithTheMaximumAmountOfPullRequests1.sql | 1 +
...sitoriesWithTheMaximumAmountOfPullRequests2.sql | 1 +
...esWithTheMaximumNumberOfAcceptedInvitations.sql | 17 +++
...sitoriesWithTheMostPeopleWhoHavePushAccess1.sql | 13 ++
...sitoriesWithTheMostPeopleWhoHavePushAccess2.sql | 13 ++
...sitoriesWithTheMostPeopleWhoHavePushAccess3.sql | 16 +++
.../repositoriesWithTheMostStarsOverOneDay1.sql | 25 ++++
.../repositoriesWithTheMostStarsOverOneDay2.sql | 25 ++++
.../repositoriesWithTheMostStarsOverOneDay3.sql | 1 +
...repositoriesWithTheMostSteadyGrowthOverTime.sql | 20 +++
.../repositoriesWithTheWorstStagnation_order.sql | 20 +++
.../sql/repositoryAffinityList1.sql | 13 ++
.../sql/repositoryAffinityList2.sql | 23 ++++
.../sql/starsFromHeavyGithubUsers1.sql | 13 ++
.../sql/starsFromHeavyGithubUsers2.sql | 15 +++
.../sql/theLongestRepositoryNames1.sql | 1 +
.../sql/theLongestRepositoryNames2.sql | 1 +
.../sql/theMostToughCodeReviews.sql | 10 ++
.../sql/theTotalNumberOfRepositoriesOnGithub.sql | 1 +
.../sql/theTotalNumberOfUsersOnGithub1.sql | 1 +
.../sql/theTotalNumberOfUsersOnGithub2.sql | 1 +
.../sql/theTotalNumberOfUsersOnGithub3.sql | 1 +
.../sql/theTotalNumberOfUsersOnGithub4.sql | 1 +
.../suites/github_events_p2/sql/topLabels1.sql | 9 ++
.../suites/github_events_p2/sql/topLabels2.sql | 9 ++
.../suites/github_events_p2/sql/topLabels3.sql | 14 +++
.../sql/topRepositoriesByStars.sql | 1 +
.../sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql | 1 +
.../sql/whoAreAllThosePeopleGivingStars1.sql | 1 +
.../sql/whoAreAllThosePeopleGivingStars2.sql | 1 +
.../sql/whoAreAllThosePeopleGivingStars3.sql | 13 ++
138 files changed, 3427 insertions(+)
diff --git a/regression-test/data/github_events_p2/sql/affinityByIssuesAndPRs1.out b/regression-test/data/github_events_p2/sql/affinityByIssuesAndPRs1.out
new file mode 100644
index 0000000000..5990d34b11
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/affinityByIssuesAndPRs1.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !affinityByIssuesAndPRs1 --
+Homebrew/homebrew-core 33 15
+pocoproject/poco 28 14
+saltstack/salt 38 13
+apache/flink 54 12
+ansible/ansible 42 12
+grafana/grafana 87 10
+helm/charts 35 10
+avelino/awesome-go 33 10
+NixOS/nixpkgs 208 9
+getredash/redash 20 9
+facebook/rocksdb 18 9
+apache/spark 18 9
+kubernetes/kubernetes 17 9
+Vertamedia/chproxy 30 8
+django/django 24 8
+python/cpython 18 8
+hashicorp/consul 9 8
+apache/incubator-doris 68 7
+iovisor/bcc 36 7
+grafana/grafana-plugin-repository 35 7
+caskroom/homebrew-cask 32 7
+DefinitelyTyped/DefinitelyTyped 26 7
+catboost/catboost 13 7
+aio-libs/aiohttp 515 6
+ant-design/ant-design 236 6
+Shopify/sarama 25 6
+nodejs/node 14 6
+grpc/grpc 11 6
+tomchristie/django-rest-framework 8 6
+edenhill/librdkafka 8 6
+antirez/redis 7 6
+monicahq/monica 1318 5
+pinterest/secor 1074 5
+the-benchmarker/web-frameworks 1035 5
+Homebrew/brew 627 5
+getsentry/sentry 209 5
+golangci/golangci-lint 134 5
+pingcap/tidb 100 5
+VictoriaMetrics/VictoriaMetrics 99 5
+yandex/graphouse 74 5
+apache/incubator-dolphinscheduler 51 5
+TechEmpower/FrameworkBenchmarks 39 5
+prometheus/client_java 25 5
+greenplum-db/gpdb 22 5
+yiisoft/yii2 17 5
+apache/zookeeper 15 5
+ceph/ceph 14 5
+symfony/symfony 13 5
+apache/airflow 13 5
+php/php-src 12 5
diff --git a/regression-test/data/github_events_p2/sql/affinityByIssuesAndPRs2.out b/regression-test/data/github_events_p2/sql/affinityByIssuesAndPRs2.out
new file mode 100644
index 0000000000..4eff10d275
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/affinityByIssuesAndPRs2.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !affinityByIssuesAndPRs2 --
+grafana/grafana 224 68
+golang/go 186 54
+apache/incubator-superset 124 36
+kubernetes/kubernetes 98 34
+elastic/elasticsearch 66 30
+ansible/ansible 53 30
+pingcap/tidb 122 24
+docker/docker 58 23
+Microsoft/vscode 39 23
+travis-ci/travis-ci 32 23
+prestodb/presto 97 22
+prometheus/prometheus 50 22
+sysown/proxysql 43 21
+Vertamedia/chproxy 31 21
+VictoriaMetrics/VictoriaMetrics 75 20
+metabase/metabase 56 20
+telegramdesktop/tdesktop 85 19
+getredash/redash 48 18
+tabixio/tabix 39 18
+edenhill/librdkafka 36 18
+influxdata/influxdb 30 17
+saltstack/salt 71 16
+apache/incubator-dolphinscheduler 39 16
+alibaba/druid 32 16
+rust-lang/rust 32 16
+tensorflow/tensorflow 32 16
+pypa/pip 16 16
+timberio/vector 178 15
+druid-io/druid 83 15
+yiisoft/yii2 43 15
+minio/minio 31 15
+pandas-dev/pandas 26 15
+elastic/logstash 21 15
+kubernetes/ingress-nginx 21 15
+prestosql/presto 89 14
+rancher/rancher 64 14
+apache/incubator-doris 41 14
+grpc/grpc 30 14
+antirez/redis 18 14
+containous/traefik 18 14
+elastic/kibana 17 14
+gitlabhq/gitlabhq 17 14
+rails/rails 36 13
+hashicorp/consul 27 13
+helm/charts 26 13
+systemd/systemd 25 13
+go-gitea/gitea 21 13
+nodejs/node 20 13
+alibaba/DataX 15 13
+getsentry/sentry 207 12
diff --git a/regression-test/data/github_events_p2/sql/countingStar1.out b/regression-test/data/github_events_p2/sql/countingStar1.out
new file mode 100644
index 0000000000..6b28c4c9cb
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/countingStar1.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !countingStar1 --
+232118474
+
diff --git a/regression-test/data/github_events_p2/sql/countingStar2.out b/regression-test/data/github_events_p2/sql/countingStar2.out
new file mode 100644
index 0000000000..6f90f14fda
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/countingStar2.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !countingStar2 --
+started 232118474
+
diff --git a/regression-test/data/github_events_p2/sql/countingStar3.out b/regression-test/data/github_events_p2/sql/countingStar3.out
new file mode 100644
index 0000000000..015acc096d
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/countingStar3.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !countingStar3 --
+14359
+
diff --git a/regression-test/data/github_events_p2/sql/distributionOfRepositoriesByStarCount.out b/regression-test/data/github_events_p2/sql/distributionOfRepositoriesByStarCount.out
new file mode 100644
index 0000000000..7c89c18d78
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/distributionOfRepositoriesByStarCount.out
@@ -0,0 +1,9 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !distributionOfRepositoriesByStarCount --
+1.0 15038158
+10.0 1194376
+100.0 211933
+1000.0 28944
+10000.0 1847
+100000.0 20
+
diff --git a/regression-test/data/github_events_p2/sql/githubRoulette.out b/regression-test/data/github_events_p2/sql/githubRoulette.out
new file mode 100644
index 0000000000..592a9bff69
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/githubRoulette.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !githubRoulette --
+ezmobius/super-nginx
+joearms/SEBG
+jdriscoll/django-imagekit
+wincent/Command-T
+acdha/NativeImaging
+mislav/will_paginate
+facebook/php-sdk
+cakephp/cakephp
+pixelmatrix/mapkey
+sebastianbergmann/phpunit
+phpbb/phpbb
+pieter/gitx
+openid/php-openid
+getify/LABjs
+erlang/otp
+opichals/osx-pkg-dmg
+scala/scala
+blueimp/jQuery-File-Upload
+intridea/authbuttons
+nitrogen/nitrogen
+cldwalker/boson
+jsmestad/sinatra_warden
+webpy/webpy
+edavis10/redmine
+Shougo/unite.vim
+ezmobius/super-nginx
+carlhuda/janus
+remy/nodemon
+joyent/node
+paulirish/html5-boilerplate
+philtr/TextMate-Themes
+revans/bash-it
+amatsuda/kaminari
+Arachnid/netboot.me
+cracell/s3bear
+ezmobius/super-nginx
+thoughtbot/paperclip
+scalatra/scalatra
+chilicat/JsChilicat
+PaulKinlan/WebIntents
+jnicklas/carrierwave
+joewalnes/webbit
+zurb/reveal
+emacsmirror/ess
+headjs/headjs
+greim/smallfsm
+joearms/SEBG
+patrickomatic/django-url-imaging
+olivernn/davis.js
+KuraFire/runloop
+
diff --git a/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
new file mode 100644
index 0000000000..1e156ecbed
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !howHasTheListOfTopRepositoriesChangedOverTheYears1 --
+FreeCodeCamp/FreeCodeCamp 38485
+facebook/react-native 25888
+apple/swift 25834
+sindresorhus/awesome 24420
+facebook/react 22977
+jlevy/the-art-of-command-line 22105
+NARKOZ/hacker-scripts 20450
+twbs/bootstrap 19775
+google/material-design-lite 17904
+airbnb/javascript 17586
+nvbn/thefuck 17168
+vhf/free-programming-books 16923
+getify/You-Dont-Know-JS 16404
+atom/electron 16174
+tensorflow/tensorflow 16009
+FreeCodeCamp/freecodecamp 15321
+nylas/N1 14927
+angular/angular.js 14824
+atom/atom 13737
+mbostock/d3 13497
+Dogfalo/materialize 13150
+ripienaar/free-for-dev 12847
+torvalds/linux 12455
+robbyrussell/oh-my-zsh 12281
+github/gitignore 11358
+bevacqua/dragula 11060
+meteor/meteor 10963
+FortAwesome/Font-Awesome 10849
+docker/docker 10845
+daneden/animate.css 10732
+zenorocha/clipboard.js 10471
+0xAX/linux-insides 10459
+typicode/json-server 10247
+wasabeef/awesome-android-ui 10187
+babel/babel 10147
+h5bp/Front-end-Developer-Interview-Questions 10011
+prakhar1989/awesome-courses 9947
+lukehoban/es6features 9890
+driftyco/ionic 9771
+gorhill/uBlock 9761
+minimaxir/big-list-of-naughty-strings 9550
+Semantic-Org/Semantic-UI 9546
+Microsoft/vscode 9489
+alex/what-happens-when 9479
+vinta/awesome-python 9304
+golang/go 9254
+phanan/htaccess 9240
+nwjs/nw.js 9203
+johnpapa/angular-styleguide 9129
+google/material-design-icons 9099
+
diff --git a/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
new file mode 100644
index 0000000000..be22241ba7
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !howHasTheListOfTopRepositoriesChangedOverTheYears2 --
+FreeCodeCamp/FreeCodeCamp 182203
+jwasham/google-interview-university 31522
+vhf/free-programming-books 28870
+vuejs/vue 28831
+tensorflow/tensorflow 28282
+facebook/react 26046
+getify/You-Dont-Know-JS 24975
+sindresorhus/awesome 24829
+chrislgarry/Apollo-11 23483
+yarnpkg/yarn 21518
+facebook/react-native 19779
+twbs/bootstrap 19396
+airbnb/javascript 19064
+joshbuchea/HEAD 18439
+facebookincubator/create-react-app 18191
+firehol/netdata 17908
+robbyrussell/oh-my-zsh 17364
+FallibleInc/security-guide-for-developers 15901
+open-guides/og-aws 15620
+github/gitignore 15205
+electron/electron 15138
+googlesamples/android-architecture 14647
+torvalds/linux 14434
+getlantern/lantern 14189
+reactjs/redux 13997
+nodejs/node 13602
+Microsoft/vscode 13284
+angular/angular 13204
+apple/swift 13060
+ParsePlatform/parse-server 12837
+braydie/HowToBeAProgrammer 12574
+docker/docker 12482
+atom/atom 12468
+webpack/webpack 12186
+ZuzooVn/machine-learning-for-software-engineers 11916
+jgthms/bulma 11685
+vinta/awesome-python 11626
+angular/angular.js 11446
+golang/go 11337
+toddmotto/public-apis 11266
+ReactiveX/RxJava 11244
+daneden/animate.css 11109
+naptha/tesseract.js 10955
+tensorflow/models 10874
+josephmisiti/awesome-machine-learning 10546
+FortAwesome/Font-Awesome 10496
+juliangarnier/anime 10462
+AHAAAAAAA/PokemonGo-Map 10448
+Microsoft/TypeScript 10340
+caesar0301/awesome-public-datasets 10333
+
diff --git a/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
new file mode 100644
index 0000000000..99be5c1f2c
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !howHasTheListOfTopRepositoriesChangedOverTheYears3 --
+freeCodeCamp/freeCodeCamp 90989
+tensorflow/tensorflow 49278
+vuejs/vue 48185
+facebook/react 34524
+mr-mig/every-programmer-should-know 30991
+kamranahmedse/developer-roadmap 30497
+sindresorhus/awesome 29084
+getify/You-Dont-Know-JS 28902
+thedaviddias/Front-End-Checklist 24745
+facebookincubator/create-react-app 24479
+Microsoft/vscode 23504
+donnemartin/system-design-primer 22584
+GoogleChrome/puppeteer 22408
+airbnb/javascript 22119
+sdmg15/Best-websites-a-programmer-should-visit 21764
+jwasham/coding-interview-university 21395
+twbs/bootstrap 21157
+toddmotto/public-apis 20881
+kamranahmedse/design-patterns-for-humans 19420
+robbyrussell/oh-my-zsh 19325
+airbnb/lottie-android 18700
+facebook/react-native 18696
+vuejs/awesome-vue 18499
+tipsy/github-profile-summary 17847
+FreeCodeCampChina/freecodecamp.cn 17794
+electron/electron 17490
+kdn251/interviews 17471
+ryanmcdermott/clean-code-javascript 17433
+mzabriskie/axios 17414
+vinta/awesome-python 17254
+torvalds/linux 17200
+tensorflow/models 17066
+nodejs/node 17062
+github/gitignore 16873
+python/cpython 16627
+yangshun/tech-interview-handbook 16388
+ElemeFE/element 16320
+bailicangdu/vue2-elm 16249
+d3/d3 16167
+Hack-with-Github/Awesome-Hacking 16153
+golang/go 16096
+k88hudson/git-flight-rules 15950
+webpack/webpack 15869
+mbeaudru/modern-js-cheatsheet 15321
+EbookFoundation/free-programming-books 15319
+angular/angular 14392
+prettier/prettier 14344
+vhf/free-programming-books 14304
+JetBrains/kotlin 14210
+parcel-bundler/parcel 14190
+
diff --git a/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
new file mode 100644
index 0000000000..a12832dad7
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !howHasTheListOfTopRepositoriesChangedOverTheYears4 --
+vuejs/vue 51515
+trekhleb/javascript-algorithms 39249
+facebook/react 38817
+flutter/flutter 38357
+danistefanovic/build-your-own-x 37815
+tensorflow/tensorflow 36976
+kamranahmedse/developer-roadmap 35278
+x64dbg/x64dbg 32381
+donnemartin/system-design-primer 31384
+CyC2018/Interview-Notebook 29941
+kelseyhightower/nocode 26326
+Microsoft/vscode 26211
+xingshaocheng/architect-awesome 25750
+sindresorhus/awesome 24977
+ry/deno 22798
+getify/You-Dont-Know-JS 22014
+tensorflow/models 21511
+GoogleChrome/puppeteer 21137
+leonardomso/33-js-concepts 21033
+facebook/create-react-app 20300
+axios/axios 20102
+houshanren/hangzhou_house_knowledge 19227
+ant-design/ant-design 19162
+facebookresearch/Detectron 18611
+jwasham/coding-interview-university 18255
+robbyrussell/oh-my-zsh 18254
+EbookFoundation/free-programming-books 18127
+github/gitignore 17872
+airbnb/javascript 17616
+justjavac/free-programming-books-zh_CN 17293
+PanJiaChen/vue-element-admin 17256
+yangshun/front-end-interview-handbook 17138
+vinta/awesome-python 16797
+golang/go 16424
+facebook/react-native 16039
+torvalds/linux 15936
+TheAlgorithms/Python 15914
+tabler/tabler 15849
+kubernetes/kubernetes 15800
+Avik-Jain/100-Days-Of-ML-Code 15777
+iluwatar/java-design-patterns 15370
+parcel-bundler/parcel 15257
+Meituan-Dianping/mpvue 15017
+storybooks/storybook 14835
+dawnlabs/carbon 14807
+toddmotto/public-apis 14781
+electron/electron 14750
+shadowsocks/shadowsocks-windows 14619
+kdn251/interviews 14586
+scutan90/DeepLearning-500-questions 14497
+
diff --git a/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
new file mode 100644
index 0000000000..d8a9ac6b3d
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !howHasTheListOfTopRepositoriesChangedOverTheYears5 --
+996icu/996.ICU 344825
+jackfrued/Python-100-Days 76845
+M4cs/BabySploit 71013
+Snailclimb/JavaGuide 53444
+TheAlgorithms/Python 48859
+CyC2018/CS-Notes 46609
+MisterBooo/LeetCodeAnimation 41526
+vuejs/vue 39159
+flutter/flutter 38733
+doocs/advanced-java 35338
+microsoft/Terminal 34359
+jlevy/the-art-of-command-line 30852
+kamranahmedse/developer-roadmap 30842
+facebook/react 29040
+donnemartin/system-design-primer 27042
+tensorflow/tensorflow 27032
+macrozheng/mall 26520
+testerSunshine/12306 26414
+sindresorhus/awesome 26286
+azl397985856/leetcode 25765
+jwasham/coding-interview-university 25556
+PanJiaChen/vue-element-admin 25101
+0voice/interview_internal_reference 24557
+lib-pku/libpku 23015
+getify/You-Dont-Know-JS 22647
+EbookFoundation/free-programming-books 21884
+microsoft/terminal 21878
+scutan90/DeepLearning-500-questions 21784
+deepfakes/faceswap 21237
+sveltejs/svelte 20969
+torvalds/linux 20455
+vinta/awesome-python 20217
+justjavac/free-programming-books-zh_CN 20137
+30-seconds/30-seconds-of-code 19784
+formulahendry/955.WLB 19772
+NationalSecurityAgency/ghidra 19651
+robbyrussell/oh-my-zsh 19602
+imhuay/Algorithm_Interview_Notes-Chinese 19508
+trekhleb/javascript-algorithms 19460
+LisaDziuba/Awesome-Design-Tools 19142
+freeCodeCamp/freeCodeCamp 18955
+golang/go 18842
+alibaba/flutter-go 18382
+ziishaned/learn-regex 18352
+github/gitignore 18228
+danistefanovic/build-your-own-x 18155
+Advanced-Frontend/Daily-Interview-Question 17797
+ossu/computer-science 17794
+dcloudio/uni-app 17759
+codercom/code-server 17702
+
diff --git a/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
new file mode 100644
index 0000000000..9dace59c32
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !howHasTheListOfTopRepositoriesChangedOverTheYears6 --
+labuladong/fucking-algorithm 77568
+jwasham/coding-interview-university 54591
+kamranahmedse/developer-roadmap 50944
+donnemartin/system-design-primer 37384
+EbookFoundation/free-programming-books 36686
+public-apis/public-apis 36405
+TheAlgorithms/Python 33837
+CyC2018/CS-Notes 33517
+danistefanovic/build-your-own-x 33283
+microsoft/PowerToys 33137
+denoland/deno 31550
+flutter/flutter 31320
+Snailclimb/JavaGuide 31103
+trekhleb/javascript-algorithms 30803
+sindresorhus/awesome 28424
+florinpop17/app-ideas 27989
+vuejs/vue 27458
+jackfrued/Python-100-Days 26699
+CSSEGISandData/COVID-19 26659
+ytdl-org/youtube-dl 26475
+facebook/react 24122
+bradtraversy/design-resources-for-developers 23170
+geekxh/hello-algorithm 22650
+ohmyzsh/ohmyzsh 21705
+microsoft/vscode 21607
+cli/cli 21541
+torvalds/linux 20547
+github/gitignore 19863
+getify/You-Dont-Know-JS 19778
+goldbergyoni/nodebestpractices 19452
+huggingface/transformers 19214
+microsoft/playwright 18751
+ossu/computer-science 18621
+Genymobile/scrcpy 18538
+macrozheng/mall 18335
+tiangolo/fastapi 17962
+gothinkster/realworld 17696
+AobingJava/JavaFamily 17495
+PanJiaChen/vue-element-admin 17330
+microsoft/terminal 16719
+willmcgugan/rich 16627
+evanw/esbuild 16621
+jlevy/the-art-of-command-line 16351
+tensorflow/tensorflow 16104
+angular/angular 15762
+kon9chunkit/GitHub-Chinese-Top-Charts 15738
+freeCodeCamp/freeCodeCamp 15701
+MisterBooo/LeetCodeAnimation 15686
+azl397985856/leetcode 15352
+anuraghazra/github-readme-stats 15193
+
diff --git a/regression-test/data/github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out b/regression-test/data/github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
new file mode 100644
index 0000000000..6a2243acd2
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.out
@@ -0,0 +1,13 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !howHasTheTotalNumberOfStarsChangedOverTime --
+2011 1831742
+2012 4048676
+2013 7432800
+2014 11952935
+2015 18994833
+2016 26166310
+2017 32640040
+2018 37068153
+2019 46118187
+2020 45864798
+
diff --git a/regression-test/data/github_events_p2/sql/issuesWithTheMostComments1.out b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments1.out
new file mode 100644
index 0000000000..044a39acd9
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments1.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !issuesWithTheMostComments1 --
+218460262
+
diff --git a/regression-test/data/github_events_p2/sql/issuesWithTheMostComments2.out b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments2.out
new file mode 100644
index 0000000000..0ef0de31b6
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments2.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !issuesWithTheMostComments2 --
+kubernetes/kubernetes 1450081
+apache/spark 790480
+rust-lang/rust 502960
+cms-sw/cmssw 478607
+google-test/signcla-probe-repo 477302
+openshift/origin 445639
+brianchandotcom/liferay-portal 392474
+NixOS/nixpkgs 349733
+elastic/kibana 330168
+ansible/ansible 312424
+everypolitician/everypolitician-data 293714
+flutter/flutter 291260
+owncloud/core 283295
+istio/istio 272426
+Microsoft/vscode 267468
+nodejs/node 258525
+tensorflow/tensorflow 255957
+MicrosoftDocs/azure-docs 245829
+JuliaLang/julia 229092
+golang/go 222317
+cockroachdb/cockroach 222305
+tgstation/tgstation 221465
+joomla/joomla-cms 218215
+servo/servo 213924
+dotnet/corefx 205892
+angular/angular 200608
+magento/magento2 198987
+saltstack/salt 196898
+docker/docker 194622
+facebook/react-native 188756
+dotnet/roslyn 187150
+apple/swift 175983
+elastic/elasticsearch 175442
+symfony/symfony 171438
+rails/rails 170580
+godotengine/godot 168950
+Automattic/wp-calypso 165136
+openshift/release 164215
+DefinitelyTyped/DefinitelyTyped 164071
+odoo/odoo 163858
+edx/edx-platform 157913
+pytorch/pytorch 151349
+microsoft/vscode 151038
+bitcoin/bitcoin 146471
+MarlinFirmware/Marlin 146463
+ManageIQ/manageiq 145739
+scikit-learn/scikit-learn 140762
+ceph/ceph 138518
+CleverRaven/Cataclysm-DDA 138073
+openshift/console 135628
+
diff --git a/regression-test/data/github_events_p2/sql/issuesWithTheMostComments3.out b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments3.out
new file mode 100644
index 0000000000..ac05755725
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments3.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !issuesWithTheMostComments3 --
+kubernetes/kubernetes 1450081 84926 17.07
+apache/spark 790480 26868 29.42
+rust-lang/rust 502960 58464 8.6
+cms-sw/cmssw 478607 25416 18.83
+google-test/signcla-probe-repo 477302 352281 1.35
+openshift/origin 445639 24421 18.25
+brianchandotcom/liferay-portal 392474 75549 5.19
+NixOS/nixpkgs 349733 74658 4.68
+elastic/kibana 330168 74871 4.41
+ansible/ansible 312424 56428 5.54
+everypolitician/everypolitician-data 293714 161361 1.82
+flutter/flutter 291260 62236 4.68
+owncloud/core 283295 26167 10.83
+istio/istio 272426 26903 10.13
+Microsoft/vscode 267468 64724 4.13
+nodejs/node 258525 33085 7.81
+tensorflow/tensorflow 255957 39964 6.4
+MicrosoftDocs/azure-docs 245829 64346 3.82
+JuliaLang/julia 229092 24823 9.23
+golang/go 222317 33491 6.64
+cockroachdb/cockroach 222305 49166 4.52
+tgstation/tgstation 221465 29711 7.45
+joomla/joomla-cms 218215 25276 8.63
+servo/servo 213924 21934 9.75
+dotnet/corefx 205892 34315 6.0
+angular/angular 200608 38680 5.19
+magento/magento2 198987 29518 6.74
+saltstack/salt 196898 30613 6.43
+docker/docker 194622 23236 8.38
+facebook/react-native 188756 28972 6.52
+dotnet/roslyn 187150 37405 5.0
+apple/swift 175983 32754 5.37
+elastic/elasticsearch 175442 51588 3.4
+symfony/symfony 171438 25420 6.74
+rails/rails 170580 22179 7.69
+godotengine/godot 168950 35601 4.75
+Automattic/wp-calypso 165136 43411 3.8
+openshift/release 164215 13736 11.96
+DefinitelyTyped/DefinitelyTyped 164071 39051 4.2
+odoo/odoo 163858 49072 3.34
+edx/edx-platform 157913 18112 8.72
+pytorch/pytorch 151349 38739 3.91
+microsoft/vscode 151038 39050 3.87
+bitcoin/bitcoin 146471 14580 10.05
+MarlinFirmware/Marlin 146463 14891 9.84
+ManageIQ/manageiq 145739 19212 7.59
+scikit-learn/scikit-learn 140762 14127 9.96
+ceph/ceph 138518 29380 4.71
+CleverRaven/Cataclysm-DDA 138073 22839 6.05
+openshift/console 135628 7204 18.83
+
diff --git a/regression-test/data/github_events_p2/sql/issuesWithTheMostComments4.out b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments4.out
new file mode 100644
index 0000000000..c70fc2796b
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments4.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !issuesWithTheMostComments4 --
+sauron-demo/sauron 1 21297
+gafusion/regression_notifications 1 15677
+odoo-mergebot-testing-org/repo 1 13315
+zeit-github-test/github-utils-test 1 9260
+odoo-mergebot-testing-org/proj 1 7681
+tphongio/elasticbox-plugin 1 6167
+openshift/oc 270 5917
+openfoodfacts/openfoodfacts-server 3767 5098
+codecov/ci-repo 4 5078
+openshift/cluster-resource-override-admission-operator 29 4562
+odoo-mergebot-testing-org/proj 2 4296
+ingvagabund/kubernetes 58 4136
+garethjevans/jenkins-cwp-quickstart01 1 4122
+Kitware/CDash 80 4005
+odoo-mergebot-testing-org/proj 3 3767
+cockpit-project/cockpit 7636 3330
+fuszenecker/CSharpDemo 5 3329
+openshift/tektoncd-pipeline-operator 494 3303
+xbrianlee/liferay-portal 369 3201
+D00Med/farlands 77 3183
+getlantern/forum 313 3123
+openshift/origin 18826 3067
+githubschool/open-enrollment-classes-introduction-to-github 927 3005
+gitalk/gitalk 1 2783
+MarshalX/yandex-music-api 339 2712
+MicrosoftDocs/E2E_MicrosoftDocs_Dynamic 1 2675
+OpenKore/openkore 628 2574
+MR-M3/Idksomething 1 2557
+D00Med/farlands 108 2554
+theapache64/movie-monk-commenter 1 2546
+openshift/ovn-kubernetes 159 2534
+openshift/template-service-broker-operator 62 2533
+sofae/pyscript 1 2518
+jaecSolutions/Unito-dev 10 2512
+oskosk/node-wms-client 2 2510
+Nexus-Mods/Vortex 6634 2509
+jaecSolutions/Unito-dev 6 2504
+alistairjcbrown/mock-repo 7 2504
+didiladi/mac-build-test 8 2504
+jaecSolutions/Unito-dev 9 2502
+openfoodfacts/openfoodfacts-server 4410 2502
+threejsworker/threejsworker 12 2500
+mesosphere-mergebot/mergebot-test-dcos 309 2500
+openshift/odo 2346 2500
+googleapis/google-cloud-go 3111 2499
+cockpit-project/cockpit 3455 2499
+jlord/patchwork 4542 2499
+jlord/patchwork 6762 2499
+cockpit-project/cockpit 7635 2499
+PennyDreadfulMTG/perf-reports 52349 2498
+
diff --git a/regression-test/data/github_events_p2/sql/issuesWithTheMostComments5.out b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments5.out
new file mode 100644
index 0000000000..cf48f5f2c5
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments5.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !issuesWithTheMostComments5 --
+openshift/oc 270 5917
+openfoodfacts/openfoodfacts-server 3767 5098
+openshift/cluster-resource-override-admission-operator 29 4562
+ingvagabund/kubernetes 58 4136
+Kitware/CDash 80 4005
+cockpit-project/cockpit 7636 3330
+openshift/tektoncd-pipeline-operator 494 3303
+xbrianlee/liferay-portal 369 3201
+D00Med/farlands 77 3183
+getlantern/forum 313 3123
+openshift/origin 18826 3067
+githubschool/open-enrollment-classes-introduction-to-github 927 3005
+MarshalX/yandex-music-api 339 2712
+OpenKore/openkore 628 2574
+D00Med/farlands 108 2554
+openshift/ovn-kubernetes 159 2534
+openshift/template-service-broker-operator 62 2533
+Nexus-Mods/Vortex 6634 2509
+openfoodfacts/openfoodfacts-server 4410 2502
+mesosphere-mergebot/mergebot-test-dcos 309 2500
+openshift/odo 2346 2500
+threejsworker/threejsworker 12 2500
+cockpit-project/cockpit 3455 2499
+cockpit-project/cockpit 7635 2499
+googleapis/google-cloud-go 3111 2499
+jlord/patchwork 4542 2499
+jlord/patchwork 6762 2499
+PennyDreadfulMTG/perf-reports 52349 2498
+PennyDreadfulMTG/perf-reports 50472 2497
+jlord/patchwork 8914 2496
+wildfly/wildfly 8947 2495
+PennyDreadfulMTG/perf-reports 53234 2494
+PennyDreadfulMTG/perf-reports 50762 2491
+RedisDesktop/rdm-debug-symbols 63 2491
+allencloud/daoker 48 2491
+PennyDreadfulMTG/perf-reports 50189 2488
+tannakartikey/currents 29 2487
+kubernetes/kubernetes 33388 2485
+puneet-tm/wirelessone-support 147 2483
+ros-infrastructure/roswiki 139 2483
+sauron-demo/sauron-demo 190 2482
+tannakartikey/currents 25 2482
+tannakartikey/currents 33 2482
+vitech-team/mood-feed-frontend 50 2480
+tannakartikey/currents 31 2479
+Zeroshi/Docs 1370 2475
+puneet-tm/wirelessone-support 137 2473
+PennyDreadfulMTG/perf-reports 53515 2468
+PennyDreadfulMTG/perf-reports 42826 2444
+yegor256/cactoos 486 2426
+
diff --git a/regression-test/data/github_events_p2/sql/issuesWithTheMostComments7.out b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments7.out
new file mode 100644
index 0000000000..82af4700d5
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments7.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !issuesWithTheMostComments7 --
+dcos/dcos 99251 16
+NREL/EnergyPlus 74922 41
+miabot/galleries.csv 52634 2
+siggetest/githubtest 52171 1
+bambootest-bot/githubtest 46876 1
+mozilla/rust 33708 82
+TrinityCore/TrinityCore 24386 1550
+kubernetes/kubernetes 21406 268
+xamarin/xamarin-macios 18893 28
+w4ctech/front-end-rss 17979 1
+rust-lang/rust 16160 238
+zeit-github-test/github-e2e-tests-dev 15344 3
+JuliaLang/julia 14932 262
+NREL/OpenStudio 14375 32
+bvcms/bvcms 13748 12
+mozilla-mobile/android-components 13675 10
+NixOS/nixpkgs 12854 672
+mangosR2/mangos 10585 194
+servo/servo 10283 76
+jirikuncar/invenio 9687 17
+rails/rails 9514 2383
+department-of-veterans-affairs/va.gov-cms 9211 10
+Wikia/app 9118 95
+coala-analyzer/coala 8878 30
+discourse/discourse 8625 331
+PaddlePaddle/Paddle 8623 30
+zeit-github-test/github-e2e-tests-dev-alias-v2-without-alias 8517 3
+zeit-github-test/github-e2e-tests-dev-alias-v2-with-alias 8504 3
+JetBrains/kotlin 8488 153
+zeit-github-test/github-e2e-test-dev-forked-repo 8364 3
+pantheon-systems/documentation 8001 38
+zeit-github-test/github-e2e-test-dev-domain-issues 7704 3
+theowenyoung/theowenyoung.github.io 7610 3
+odoo-dev/odoo 7528 210
+zeit-github-test/github-utils-test 7477 1
+mono/MonoGame 7394 64
+Hack23/cia 7099 3
+stellar/stellar-core 7098 26
+mozilla/servo 6962 26
+xbmc/xbmc 6836 416
+stdlib-js/stdlib 6782 5
+MyEtherWallet/MyEtherWallet 6583 20
+cle-event-calendar/cle-event-calendar.github.io 6104 1
+advancedtelematic/rvi_sota_server 6028 6
+ceph/ceph 5804 208
+mono/CppSharp 5790 20
+pachoclo/corona-tracker 5443 3
+xwiki/xwiki-platform 5144 43
+SthephanShinkufag/Dollchan-Extension-Tools 4977 33
+netty/netty 4759 156
+
diff --git a/regression-test/data/github_events_p2/sql/issuesWithTheMostComments8.out b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments8.out
new file mode 100644
index 0000000000..e4dffc4093
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/issuesWithTheMostComments8.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !issuesWithTheMostComments8 --
+https://github.com/nixxquality/WebMConverter/commit/c1ac0baac06fa7175677a4a1bf65860a84708d67 467 156
+https://github.com/torvalds/linux/commit/8a104f8b5867c682d994ffa7a74093c54469c11f 410 181
+https://github.com/SEI-ATL/select-best-player/commit/fdc6e0e073fa30acf2041ca0b1c9fecd662d88c8 408 31
+https://github.com/goagent/goagent/commit/e492ed0283f5cde7cf71d7ac47429f64aa48cd13 378 346
+https://github.com/apple/swift/commit/18844bc65229786b96b89a9fc7739c0fc897905e 345 331
+https://github.com/shadowsocks/shadowsocks/commit/938bba32a4008bdde9c064dda6a0597987ddef54 309 258
+https://github.com/mosh-hamedani/vidly-mvc-5/commit/b727a26e1b4b88abe84a8b48208fec537db2ed43 283 157
+https://github.com/hklcf/myTV-api/commit/375fa7520455b53fad622c0149a473ebee048e15 272 26
+https://github.com/NecronomiconCoding/NecroBot/commit/26e57d9feac57ab372ac466ef6cd66218faa475c 262 75
+https://github.com/zhaohmng/-21-/commit/0cc2b2a546ad51fb360ba800c67b057ea3270869 249 187
+https://github.com/mlouielu/cn_constitution_2018/commit/646c76a573ad49414e708c091393ddb7c437f286 245 181
+https://github.com/kohsuke/sandbox-ant/commit/8ae38db0ea5837313ab5f39d43a6f73de3bd9000 233 65
+https://github.com/iride2020/iRide-Token/commit/8f810b3700a24de0ee4f945ef84be7b2f1605610 228 183
+https://github.com/MrMEEE/bumblebee-Old-and-abbandoned/commit/a047be85247755cdbe0acce6f1dafc8beb84f2ac 227 205
+https://github.com/yuuwill/1024app-android/commit/0b02f1815686fa657d7b4a9583019fe4d203b80a 217 142
+https://github.com/3dshax/ctr/commit/bcb3734b9a26d0fe7ef66f7d3814406fee797303 201 137
+https://github.com/rails/rails/commit/b83965785db1eec019edf1fc272b1aa393e6dc57 200 123
+https://github.com/tmux/tmux/commit/d2b35e19cdd61d163d26c4babccc1550e72a9623 196 188
+https://github.com/mosh-hamedani/vidly-mvc-5/commit/93f39efe3ef0ce9c25ef09ebef60ad2dfc1fe7f3 191 107
+https://github.com/mosh-hamedani/vidly-mvc-5/commit/acb8c0a0a27255e3f0af85ab2f687e0e9b82b6db 165 95
+https://github.com/git/git/commit/e83c5163316f89bfbde7d9ab23ca2e25604af290 163 151
+https://github.com/easylist/easylist/commit/a4d380ad1a3b33a0fab679a1a8c5a791321622b3 159 68
+https://github.com/udacity/ud843-QuakeReport/commit/14541da929b771249ea8209698d324b61bbeee7e 153 89
+https://github.com/mikeozornin/constitution-of-russia/commit/facbe841eab3f434bd03af3627d4475ea4a671cd 138 60
+https://github.com/lianshang/code-review-fe/commit/552d837b334b32130a50db389e5ceee1a66f0f37 133 11
+https://github.com/BETAFPV/opentx/commit/49a748044b6fd538b581db3bab0c127f6c7959bc 128 10
+https://github.com/octocat/Spoon-Knife/commit/d0dd1f61b33d64e29d8bc1372a94ef6a2fee76a9 126 93
+https://github.com/Unad-BDBasicas/Inicial_Evidencia_1_3/commit/c7ab5c04f438f0221d2beb75a868a82f40adcb56 125 98
+https://github.com/Ar1i/PokemonGo-Bot/commit/e3d12abaf0c6ab022ea33c126856cac46c530f6d 123 19
+https://github.com/ruby/ruby/commit/6b8d4ab840b2d76d356ba30dbccfef4f5fd10767 122 122
+https://github.com/tumblr/policy/commit/991c5d73775a0fa0e06e258768f91d040e27a7a5 121 82
+https://github.com/ajithcj/Stockfish/commit/e8b409d740e3170aaa52d0304bab330a845e6ffe 120 17
+https://github.com/torvalds/linux/commit/1da177e4c3f41524e886b7f1b8a0c1fc7321cac2 120 113
+https://github.com/mosh-hamedani/vidly-mvc-5/commit/e7fb4e6973bbcf640780e44e18f3c12344460138 117 67
+https://github.com/github/dmca/commit/bccf7d0dbfec423c4a967f668be47b6339d15893 114 78
+https://github.com/mikegithubber/my-first-github-repository/commit/b5ed1a1bc1a737c13818847529fb21ed615e6e66 109 107
+https://github.com/google/brotli/commit/c4f439dbe6007b2a37d50c20419253d5aaa8b46b 106 53
+https://github.com/londonappbrewery/destini-challenge-completed/commit/69ed867992fc05f13a4fbef452173a956312993d 103 78
+https://github.com/bkeepers/dear-github/commit/4afa490932578027462f2a8f404a38adace02f16 101 94
+https://github.com/summerhoax/summerhoax.github.io/commit/446dbba4e51319fb62c55ef55bfbd12bfd92021f 100 10
+https://github.com/IIITSERC/SSAD_2015_A3_Group2_23/commit/404661768e73939c0dbe3fa80ca2752587158e29 99 10
+https://github.com/laboratorioIS/04_CV/commit/4a63b5b50251c59e74560e60054470fc9abc8d27 99 94
+https://github.com/mpv-player/mpv/commit/a20ae0417f2d1e1a2c173f5eaf66a81974df0008 98 25
+https://github.com/shadowsocks/shadowsocks/commit/5b450acfaa15cd6c2d3e8ab99f9297542df74025 98 92
+https://github.com/PCSX2/pcsx2/commit/f81cf360bce91649a5827967dc5e73c926711611 97 10
+https://github.com/linsonder6/Tesla/commit/217ed735d4b568cd02b6a3903b305a622c14a0b1 97 11
+https://github.com/mosh-hamedani/vidly-mvc-5/commit/8a852d11f4f8eb95b9f57e296fefb25bc0acd21b 96 64
+https://github.com/DrKLO/Telegram/commit/64e8ec3fbd26a876b7683f83a6f59c6b67316421 95 46
+https://github.com/forezp/SpringcloudConfig/commit/a68876a6211369bae723348d5f8c3defe4a55e04 95 66
+https://github.com/imsun/gitment/commit/cb5779f30b603b3431c2ee6e759ae6425d89797e 94 30
+
diff --git a/regression-test/data/github_events_p2/sql/mostForkedRepositories.out b/regression-test/data/github_events_p2/sql/mostForkedRepositories.out
new file mode 100644
index 0000000000..6b524e0b43
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/mostForkedRepositories.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !mostForkedRepositories --
+jtleek/datasharing 262926
+octocat/Spoon-Knife 198031
+rdpeng/ProgrammingAssignment2 160794
+tensorflow/tensorflow 98226
+twbs/bootstrap 92878
+github/gitignore 84075
+SmartThingsCommunity/SmartThingsPublic 78551
+barryclark/jekyll-now 68601
+rdpeng/ExData_Plotting1 67182
+nightscout/cgm-remote-monitor 59420
+Pierian-Data/Complete-Python-3-Bootcamp 49504
+tensorflow/models 49502
+torvalds/linux 47280
+jlord/patchwork 45136
+facebook/react 44678
+eugenp/tutorials 44522
+rdpeng/RepData_PeerAssessment1 44449
+angular/angular.js 43790
+jackfrued/Python-100-Days 41558
+opencv/opencv 41545
+spring-projects/spring-boot 38610
+LarryMad/recipes 38317
+vuejs/vue 37441
+laravel/laravel 36584
+jwasham/coding-interview-university 36256
+udacity/frontend-nanodegree-resume 35434
+mrdoob/three.js 35378
+django/django 34930
+firstcontributions/first-contributions 34173
+spring-projects/spring-framework 33862
+Snailclimb/JavaGuide 33198
+jquery/jquery 31858
+ant-design/ant-design 31286
+getify/You-Dont-Know-JS 31020
+CyC2018/CS-Notes 30915
+TheAlgorithms/Python 30656
+rails/rails 30602
+DefinitelyTyped/DefinitelyTyped 30389
+mmistakes/minimal-mistakes 29852
+kubernetes/kubernetes 29487
+apache/spark 28904
+facebook/react-native 27146
+996icu/996.ICU 27101
+ansible/ansible 27001
+scikit-learn/scikit-learn 26726
+robbyrussell/oh-my-zsh 26561
+coolsnowwolf/lede 26469
+bitcoin/bitcoin 26356
+git/git 25929
+angular/angular 25463
+
diff --git a/regression-test/data/github_events_p2/sql/organizationsByTheNumberOfRepositories.out b/regression-test/data/github_events_p2/sql/organizationsByTheNumberOfRepositories.out
new file mode 100644
index 0000000000..ff48f4a50b
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/organizationsByTheNumberOfRepositories.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !organizationsByTheNumberOfRepositories --
+microsoft 3359
+google 1599
+openstack 1412
+packtpublishing 1381
+apache 1017
+sindresorhus 1016
+azure 818
+aws-samples 761
+mozilla 727
+googlecloudplatform 718
+awslabs 712
+jenkinsci 596
+substack 594
+ibm 593
+adafruit 541
+mapbox 494
+mafintosh 481
+azure-samples 473
+cyanogenmod 451
+apress 445
+w3c 397
+keijiro 391
+udacity 387
+stackforge 359
+alibaba 348
+facebookresearch 328
+llsourcell 328
+esri 325
+facebook 311
+egoist 302
+github 299
+fossasia 292
+spatie 292
+mattn 288
+heroku 283
+unity-technologies 278
+vim-scripts 277
+ropensci 275
+jonschlinkert 271
+gnome 267
+googlesamples 264
+maxogden 264
+hashicorp 262
+jetbrains 260
+lineageos 259
+eclipse 257
+automattic 255
+officedev 255
+segmentio 253
+aws 251
diff --git a/regression-test/data/github_events_p2/sql/organizationsByTheNumberOfStars.out b/regression-test/data/github_events_p2/sql/organizationsByTheNumberOfStars.out
new file mode 100644
index 0000000000..2f8f05b12d
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/organizationsByTheNumberOfStars.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !organizationsByTheNumberOfStars --
+google 1414877
+microsoft 1361303
+facebook 1123380
+alibaba 580707
+sindresorhus 565535
+apache 553204
+vuejs 494824
+tensorflow 425613
+freecodecamp 407610
+fossasia 398255
+github 379901
+airbnb 378280
+996icu 354957
+angular 314363
+square 296221
+tencent 290161
+symfony 281686
+mozilla 275422
+facebookresearch 269377
+twitter 236120
+shadowsocks 232179
+kamranahmedse 209439
+donnemartin 195645
+netflix 193916
+dotnet 191059
+kubernetes 188557
+golang 178867
+googlesamples 176609
+thealgorithms 174471
+spring-projects 174352
+zeit 174319
+apple 173102
+getify 171049
+docker 170096
+laravel 167122
+jwasham 166419
+googlechrome 162071
+twbs 161475
+flutter 159926
+hashicorp 158643
+awslabs 154676
+jakewharton 143577
+reactjs 142652
+kennethreitz 140109
+reactivex 140062
+elastic 139639
+googlecloudplatform 139094
+uber 137406
+atom 137328
+justjavac 136694
+
diff --git a/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks1.out b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks1.out
new file mode 100644
index 0000000000..7a97ef8c8b
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !proportionsBetweenStarsAndForks1 --
+jtleek/datasharing 262926 6364 0.024
+octocat/Spoon-Knife 198031 4601 0.023
+rdpeng/ProgrammingAssignment2 160794 990 0.006
+tensorflow/tensorflow 98226 173681 1.768
+twbs/bootstrap 92878 126371 1.361
+github/gitignore 84075 119322 1.419
+SmartThingsCommunity/SmartThingsPublic 78551 2073 0.026
+barryclark/jekyll-now 68601 8185 0.119
+rdpeng/ExData_Plotting1 67182 271 0.004
+nightscout/cgm-remote-monitor 59420 1784 0.03
+Pierian-Data/Complete-Python-3-Bootcamp 49504 14952 0.302
+tensorflow/models 49502 75206 1.519
+torvalds/linux 47280 121415 2.568
+jlord/patchwork 45136 1329 0.029
+facebook/react 44678 188575 4.221
+eugenp/tutorials 44522 26055 0.585
+rdpeng/RepData_PeerAssessment1 44449 124 0.003
+angular/angular.js 43790 76251 1.741
+jackfrued/Python-100-Days 41558 108760 2.617
+opencv/opencv 41545 45223 1.089
+spring-projects/spring-boot 38610 58232 1.508
+LarryMad/recipes 38317 170 0.004
+vuejs/vue 37441 199731 5.335
+laravel/laravel 36584 74136 2.026
+jwasham/coding-interview-university 36256 119797 3.304
+udacity/frontend-nanodegree-resume 35434 1351 0.038
+mrdoob/three.js 35378 72597 2.052
+django/django 34930 66415 1.901
+firstcontributions/first-contributions 34173 11620 0.34
+spring-projects/spring-framework 33862 44540 1.315
+Snailclimb/JavaGuide 33198 97793 2.946
+jquery/jquery 31858 65497 2.056
+ant-design/ant-design 31286 71552 2.287
+getify/You-Dont-Know-JS 31020 144146 4.647
+CyC2018/CS-Notes 30915 93320 3.019
+TheAlgorithms/Python 30656 102067 3.329
+rails/rails 30602 53620 1.752
+DefinitelyTyped/DefinitelyTyped 30389 27883 0.918
+mmistakes/minimal-mistakes 29852 8299 0.278
+kubernetes/kubernetes 29487 68644 2.328
+apache/spark 28904 32616 1.128
+facebook/react-native 27146 105346 3.881
+996icu/996.ICU 27101 354850 13.094
+ansible/ansible 27001 51144 1.894
+scikit-learn/scikit-learn 26726 48654 1.82
+robbyrussell/oh-my-zsh 26561 107173 4.035
+coolsnowwolf/lede 26469 15568 0.588
+bitcoin/bitcoin 26356 53646 2.035
+git/git 25929 41413 1.597
+angular/angular 25463 80602 3.165
+
diff --git a/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks2.out b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks2.out
new file mode 100644
index 0000000000..134dc3b21b
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks2.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !proportionsBetweenStarsAndForks2 --
+M4cs/BabySploit 147 71572 486.884
+tipsy/github-profile-summary 330 22397 67.87
+doctrine/inflector 155 10236 66.039
+phpDocumentor/ReflectionDocBlock 143 8547 59.769
+pakastin/open-source-flash 128 7326 57.234
+egulias/EmailValidator 177 9835 55.565
+symfony/var-dumper 127 6770 53.307
+laravel/tinker 129 6773 52.504
+guzzle/promises 126 6596 52.349
+paragonie/random_compat 157 7941 50.58
+fideloper/TrustedProxy 147 7201 48.986
+charmbracelet/glow 120 5838 48.65
+woltapp/blurhash 168 7875 46.875
+dandavison/delta 140 6494 46.386
+simeji/jid 129 5976 46.326
+akavel/up 111 4873 43.901
+evanw/esbuild 384 16631 43.31
+webmozart/assert 158 6795 43.006
+tomnomnom/gron 200 8597 42.985
+sharkdp/hyperfine 158 6685 42.31
+pikapkg/web 119 4986 41.899
+mixn/carbon-now-cli 116 4778 41.19
+CodeHubApp/CodeHub 392 15897 40.554
+mjswensen/themer 102 4091 40.108
+react-spring/zustand 105 4166 39.676
+GoogleChromeLabs/react-adaptive-hooks 117 4620 39.487
+swc-project/swc 254 10011 39.413
+Raathigesh/majestic 180 7055 39.194
+sveinbjornt/Sloth 109 4254 39.028
+luruke/browser-2020 213 8278 38.864
+rhysd/vim.wasm 119 4603 38.681
+auchenberg/volkswagen 306 11730 38.333
+resume/resume.github.com 1786 68423 38.311
+kdeldycke/awesome-falsehood 411 15675 38.139
+uswds/public-sans 102 3890 38.137
+GoogleChromeLabs/ndb 265 10035 37.868
+developit/htm 159 5973 37.566
+Canop/broot 131 4894 37.359
+you-dont-need/You-Dont-Need-Momentjs 288 10749 37.323
+romefrontend/rome 131 4843 36.969
+jlongster/prettier 139 5111 36.77
+pojala/electrino 118 4333 36.72
+symfony/console 235 8546 36.366
+timqian/chart.xkcd 182 6578 36.143
+developit/workerize 111 4000 36.036
+joeycastillo/The-Open-Book 122 4362 35.754
+framer/motion 242 8626 35.645
+nearform/node-clinic 102 3633 35.618
+dylanbeattie/rockstar 139 4863 34.986
+muesli/duf 141 4933 34.986
+
diff --git a/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks3.out b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks3.out
new file mode 100644
index 0000000000..517c334488
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks3.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !proportionsBetweenStarsAndForks3 --
+rdpeng/RepData_PeerAssessment1 44449 124 358.46
+rdpeng/ExData_Plotting1 67182 271 247.9
+LarryMad/recipes 38317 170 225.39
+rdpeng/ProgrammingAssignment2 160794 990 162.42
+jenkins-docs/simple-java-maven-app 14484 222 65.24
+deadlyvipers/dojo_rules 13600 213 63.85
+google/it-cert-automation-practice 15163 288 52.65
+jleetutorial/maven-project 8191 171 47.9
+jenkins-docs/simple-node-js-react-npm-app 5946 128 46.45
+udacity/fullstack-nanodegree-vm 16782 373 44.99
+typicode/demo 8291 185 44.82
+octocat/Spoon-Knife 198031 4601 43.04
+scm-ninja/starter-web 16299 385 42.34
+jtleek/datasharing 262926 6364 41.31
+openshift/nodejs-ex 6956 171 40.68
+saasbook/hw-ruby-intro 4303 109 39.48
+SmartThingsCommunity/SmartThingsPublic 78551 2073 37.89
+saasbook/hw3_rottenpotatoes 8813 242 36.42
+sclorg/nodejs-ex 6243 175 35.67
+holbertonschool/your_first_code 4153 117 35.5
+jlord/patchwork 45136 1329 33.96
+LambdaSchool/portfolio-website 3526 104 33.9
+nightscout/cgm-remote-monitor 59420 1784 33.31
+udacity/OAuth2.0 3779 114 33.15
+xudailong/xudailong.github.io 3235 101 32.03
+zeit/now-github-starter 5992 190 31.54
+springframeworkguru/spring5-recipe-app 3585 118 30.38
+udacity/course-git-blog-project 4720 166 28.43
+cerner/smart-on-fhir-tutorial 3031 108 28.06
+devart-by-google/devart-template 2887 105 27.5
+codeschool-projects/HTMLPortfolioProject 3588 133 26.98
+carbon-design-system/carbon-tutorial 2862 109 26.26
+udacity/frontend-nanodegree-resume 35434 1351 26.23
+udacity/create-your-own-adventure 16268 630 25.82
+MicrosoftDocs/pipelines-dotnet-core 4198 166 25.29
+Cutwell/Hacktoberfest-Census 3641 144 25.28
+iloveponies/training-day 3274 140 23.39
+yankils/Simple-DevOps-Project 4408 196 22.49
+fluxcd/flux-get-started 2868 129 22.23
+udacity/mws-restaurant-stage-1 2807 127 22.1
+udacity/devops-intro-project 4152 190 21.85
+udacity/course-JS-and-the-DOM 2494 115 21.69
+cnfeat/blog.io 5354 256 20.91
+evanca/quick-portfolio 4234 205 20.65
+udacity/frontend-nanodegree-styleguide 4813 234 20.57
+DevMountain/learn-git 2279 111 20.53
+Nguyen17/Hacktoberfest-Sign-In 3111 152 20.47
+springframeworkguru/spring5webapp 8163 408 20.01
+MLH/mlh-localhost-github 2056 105 19.58
+do-community/cloud_haiku 2058 106 19.42
+
diff --git a/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks4.out b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks4.out
new file mode 100644
index 0000000000..10b4b31c3b
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks4.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !proportionsBetweenStarsAndForks4 --
+84709181 232118474 2.74
+
diff --git a/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks5.out b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks5.out
new file mode 100644
index 0000000000..6f1812f801
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/proportionsBetweenStarsAndForks5.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !proportionsBetweenStarsAndForks5 --
+44944118 171567035 3.82
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesByAmountOfModifiedCode.out b/regression-test/data/github_events_p2/sql/repositoriesByAmountOfModifiedCode.out
new file mode 100644
index 0000000000..899c0bbb90
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesByAmountOfModifiedCode.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesByAmountOfModifiedCode --
+everypolitician/everypolitician-data 150531 18 66782324 71203492
+brianchandotcom/liferay-portal 91962 337 29304605 13799025
+googleapis/google-api-java-client-services 4689 17 12184021 9874444
+code-dot-org/code-dot-org 35776 125 14329448 6810679
+elastic/kibana 51783 798 12478455 6092002
+dotnet/roslyn 23642 580 12112106 5703835
+shuyangzhou/liferay-portal 7334 140 11510525 6287677
+cms-sw/cmssw 28087 947 9488742 5076486
+Azure/azure-sdk-for-python 10323 339 10692004 3691779
+Azure/azure-sdk-for-net 9775 935 9759909 3188655
+Azure/azure-sdk-for-java 11486 270 10819433 2093449
+kubernetes/kubernetes 50005 4010 8499117 4214536
+Azure/azure-sdk-for-js 8559 173 7966391 2764315
+brain-tec/odoo 11568 25 6844586 3767385
+rust-lang/rust 35150 3253 6333591 4134718
+Azure/azure-sdk-for-go 11374 145 8813959 1631936
+ImagicalMine/ImagicalMine 1808 494 5657300 4651706
+cockroachdb/cockroach 27273 448 6339775 3681529
+AzureSDKAutomation/azure-sdk-for-go 11359 5 7347712 2664515
+AzureSDKAutomation/azure-sdk-for-java 5625 2 8289316 950276
+dotnet/corefx 23909 1077 5551303 3611403
+elastic/elasticsearch 35505 1954 6096474 3035768
+sergiogonzalez/liferay-portal 3834 160 6082683 2815344
+Azure/azure-powershell 6641 1141 6148306 2514765
+DefinitelyTyped/DefinitelyTyped 35999 13794 5722804 2630593
+NixOS/nixpkgs 84339 3806 5039996 2723533
+ballerina-platform/ballerina-lang 11611 200 4683027 2902904
+AzureSDKAutomation/azure-sdk-for-python 3169 8 5340322 2059824
+Baystation12/Baystation12 17379 581 4046648 3326499
+Roll20/roll20-character-sheets 6955 1090 5360348 2000635
+CleverRaven/Cataclysm-DDA 27370 1421 4512562 2775415
+edx/edx-platform 24649 721 4436061 2720801
+apple/swift 33600 1148 4628287 2429224
+Azure/azure-rest-api-specs 9771 1830 6060533 971685
+mozilla-b2g/gaia 30192 903 4533023 2275032
+BabylonJS/Babylon.js 6378 379 3782068 2994772
+apache/flink 13581 1142 4835276 1780093
+Ericsson/llvm-project 5273 7 4409783 1959794
+ansible/ansible 42368 7278 4943233 1324581
+ceph/ceph 37310 1394 4388528 1763042
+odoo/odoo 46326 2002 4017686 2067374
+pytorch/pytorch 29916 2188 3818920 2261688
+cocos2d/cocos2d-x 14981 1125 3764992 2237766
+Azure/azure-sdk-for-ruby 1582 93 3334700 2667297
+apache/ignite 6894 366 4519341 1470598
+juju/juju 11939 145 3949798 1887980
+tensorflow/tensorflow 15404 3806 4007607 1503030
+servo/servo 14402 1147 3660324 1840343
+AzureSDKAutomation/azure-sdk-for-js 2655 4 4085633 1330763
+natecavanaugh/liferay-portal 3608 109 3534320 1779103
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesByTheNumberOfPushes.out b/regression-test/data/github_events_p2/sql/repositoriesByTheNumberOfPushes.out
new file mode 100644
index 0000000000..4a84aa7c68
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesByTheNumberOfPushes.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesByTheNumberOfPushes --
+CocoaPods/Specs 516861 375
+odoo/odoo 239208 95
+docker-library/docs 237496 6
+openstack/openstack 202003 2
+greatfire/wiki 169566 4
+pytorch/pytorch 147447 212
+/ 145675 18546
+NixOS/nixpkgs 125285 177
+Automattic/wp-calypso 120883 432
+edx/edx-platform 118395 330
+freebsd/freebsd 109816 2
+ghc/ghc 79590 6
+servo/servo 76171 33
+JetBrains/kotlin 75102 119
+boostorg/boost 72188 14
+llvm-mirror/llvm 71895 2
+gradle/gradle 71725 72
+elastic/elasticsearch 70432 252
+chromium/chromium 67467 3
+getsentry/sentry 63600 96
+keybase/client 61854 44
+guardian/frontend 61601 205
+rust-lang/rust 60604 39
+elastic/kibana 59447 329
+llvm/llvm-project 56714 826
+arangodb/arangodb 55932 46
+discourse/discourse 55921 47
+cockroachdb/cockroach 55384 139
+JuliaLang/julia 54396 75
+owncloud/core 53321 136
+apple/swift 52099 188
+ornicar/lila 51919 13
+ceph/ceph 51024 144
+Homebrew/homebrew-core 50537 50
+tensorflow/tensorflow 50499 110
+WordPress/gutenberg 49950 179
+sourcegraph/sourcegraph 49580 84
+JetBrains/intellij-community 48047 15
+cdnjs/cdnjs 46219 24
+mongodb/mongo 43202 268
+Homebrew/homebrew-cask 41360 14
+ansible/ansible 41176 74
+dart-lang/sdk 40914 104
+php/php-src 39739 8
+libretro/RetroArch 39628 17
+h2oai/h2o-3 38992 99
+kubernetes/kubernetes 38568 94
+crate/crate 38146 47
+ruby/ruby 37868 31
+mono/monodevelop 37843 96
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithClickhouse_related_comments1.out b/regression-test/data/github_events_p2/sql/repositoriesWithClickhouse_related_comments1.out
new file mode 100644
index 0000000000..cb47327d86
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithClickhouse_related_comments1.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithClickhouse_related_comments1 --
+ClickHouse/ClickHouse 12661
+yandex/ClickHouse 7412
+traceon/ClickHouse 2339
+kokizzu/ClickHouse 1794
+skirdey/ClickHouse 881
+getsentry/snuba 764
+Mu-L/ClickHouse 644
+Vertamedia/clickhouse-grafana 538
+Altinity/clickhouse-operator 532
+mymarilyn/clickhouse-driver 475
+yandex/clickhouse-jdbc 428
+ClickHouse/clickhouse-odbc 365
+housepower/ClickHouse-Native-JDBC 331
+kshvakov/clickhouse 303
+PostHog/posthog 299
+DataDog/integrations-core 286
+AlexAkulov/clickhouse-backup 284
+Infinidat/infi.clickhouse_orm 261
+yandex/clickhouse-odbc 260
+xzkostyan/clickhouse-sqlalchemy 227
+Mattlk13/ClickHouse 217
+getsentry/onpremise 205
+lomik/graphite-clickhouse 204
+smi2/phpClickHouse 203
+ibis-project/ibis 196
+getsentry/sentry 190
+killwort/ClickHouse-Net 188
+NixOS/nixpkgs 182
+housepower/clickhouse_sinker 181
+microfleet/clickhouse-adapter 164
+timberio/vector 162
+ClickHouse/clickhouse-jdbc 161
+adjust/clickhouse_fdw 149
+ClickHouse/clickhouse-go 143
+lomik/carbon-clickhouse 137
+sentry-kubernetes/charts 123
+InterestingLab/waterdrop 122
+apache/incubator-superset 122
+apla/node-clickhouse 122
+suharev7/clickhouse-rs 112
+sysown/proxysql 110
+artpaul/clickhouse-cpp 109
+dbeaver/dbeaver 105
+IMSMWU/RClickhouse 104
+childe/gohangout 103
+DarkWanderer/ClickHouse.Client 100
+enqueue/metabase-clickhouse-driver 100
+go-graphite/carbonapi 100
+Altinity/ClickHouse 98
+BayoNet/ClickHouse 98
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithClickhouse_related_comments2.out b/regression-test/data/github_events_p2/sql/repositoriesWithClickhouse_related_comments2.out
new file mode 100644
index 0000000000..0317f4802d
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithClickhouse_related_comments2.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithClickhouse_related_comments2 --
+996icu/996.ICU 354850 1
+golang/go 92407 6
+nodejs/node 75477 1
+kubernetes/kubernetes 68644 1
+avelino/awesome-go 64700 2
+rails/rails 53620 2
+rust-lang/rust 53027 3
+ansible/ansible 51144 5
+elastic/elasticsearch 48810 1
+grafana/grafana 39147 77
+Kickball/awesome-selfhosted 37934 2
+prometheus/prometheus 35949 5
+apache/spark 32616 3
+fffaraz/awesome-cpp 31297 2
+rethinkdb/rethinkdb 28628 2
+pingcap/tidb 28099 4
+netty/netty 27854 2
+getsentry/sentry 27255 190
+composer/composer 26787 2
+Homebrew/brew 26658 2
+alibaba/druid 24851 26
+sequelize/sequelize 24415 4
+metabase/metabase 23835 91
+moby/moby 22615 2
+pandas-dev/pandas 22473 5
+dmlc/xgboost 21377 3
+spf13/cobra 20509 1
+jinzhu/gorm 20443 4
+hasura/graphql-engine 20060 2
+facebook/rocksdb 19694 1
+netdata/netdata 19605 9
+zhangdaiscott/jeecg-boot 19119 2
+alibaba/easyexcel 18773 2
+palantir/blueprint 18294 2
+apache/incubator-superset 18265 122
+protocolbuffers/protobuf 18210 1
+StevenBlack/hosts 18004 1
+sebastianbergmann/phpunit 17932 1
+alibaba/canal 17810 1
+yiisoft/yii2 17490 5
+getredash/redash 17471 45
+celery/celery 16593 2
+openssl/openssl 15814 1
+apache/flink 15690 6
+taosdata/TDengine 15322 9
+brettwooldridge/HikariCP 14983 4
+rancher/k3s 14664 3
+influxdata/influxdb 14374 2
+dbeaver/dbeaver 13757 105
+requests/requests 12997 4
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithDoris_related_comments1.out b/regression-test/data/github_events_p2/sql/repositoriesWithDoris_related_comments1.out
new file mode 100644
index 0000000000..2cf364028a
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithDoris_related_comments1.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithDoris_related_comments1 --
+everypolitician/everypolitician-data 3612
+apache/incubator-doris 3588
+balena-io/balena-sdk 399
+nullart/freqtrade 316
+Mozilla-TWQA/Hasal 238
+Mu-L/incubator-doris 203
+tektoncd/triggers 129
+mozilla/localForage 110
+angular-ui/ui-sortable 96
+balena-io/balena-cli 84
+frontendbr/vagas 79
+balena-io/open-balena-api 67
+balena-io-modules/rendition 65
+backend-br/vagas 58
+JuliaRegistries/General 45
+fake-name/ReadableWebProxy 45
+sopoforic/gamest 45
+fake-name/wlnupdates 43
+GitDoris/rest 36
+thodoriskonstantoulias/Angular_Full_Guide 34
+aivendor/onlysdk 33
+androiddevbr/vagas 33
+cjdoris/Infinity.jl 30
+jeffknupp/sandman2 30
+olivierfriard/DORIS 30
+Khan/khan-i18n 29
+rOpenGov/pxweb 29
+CocoaHeadsBrasil/vagas 27
+unitsofmeasurement/unit-api 27
+acelyc111/incubator-doris 26
+cds-snc/notification-api 26
+localForage/localForage 25
+LeonardoRiselli/python 24
+TUDelftGeodesy/Doris 23
+frontendbr/forum 23
+lux-org/lux 23
+phpdevbr/vagas 23
+coderetreat/coderetreat.github.io 22
+ftes/clickr-rails 22
+markdorison/github-actions-for-ci 22
+resin-io/resin-sdk 21
+QoreCode/doris-yii2-bug-report 20
+arendst/Tasmota 20
+dorisol1019/BGMPlayer 20
+tangydoris/WormGUIDES 20
+teodorislava/startup-network 20
+react-brasil/vagas 19
+tgstation/-tg-station 19
+dd-center/vdb 18
+markdorison/github-actions-continuous-delivery 18
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithDoris_related_comments2.out b/regression-test/data/github_events_p2/sql/repositoriesWithDoris_related_comments2.out
new file mode 100644
index 0000000000..4197df5453
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithDoris_related_comments2.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithDoris_related_comments2 --
+996icu/996.ICU 354850 4
+FreeCodeCamp/FreeCodeCamp 225490 1
+facebook/react 188575 2
+flutter/flutter 116303 4
+angular/angular 80602 3
+angular/angular.js 76251 1
+ant-design/ant-design 71552 2
+atom/atom 68396 2
+meteor/meteor 51930 1
+gatsbyjs/gatsby 51589 2
+rg3/youtube-dl 51271 2
+ansible/ansible 51144 1
+antirez/redis 49108 1
+elastic/elasticsearch 48810 4
+babel/babel 38965 1
+chartjs/Chart.js 36085 2
+prometheus/prometheus 35949 1
+JuliaLang/julia 34480 1
+mozilla/pdf.js 34406 1
+firehol/netdata 34246 1
+driftyco/ionic 33243 2
+apache/spark 32616 1
+kennethreitz/requests 30772 1
+NervJS/taro 28813 2
+pi-hole/pi-hole 28431 1
+fzaninotto/Faker 27336 1
+minio/minio 26176 1
+laravel/framework 25317 1
+rapid7/metasploit-framework 24953 4
+sequelize/sequelize 24415 3
+facebook/flow 23227 4
+littlecodersh/ItChat 22574 1
+getlantern/forum 21526 1
+Meituan-Dianping/mpvue 21316 2
+vlang/v 20611 1
+apache/incubator-echarts 19972 6
+alibaba/weex 19723 1
+jhipster/generator-jhipster 19597 1
+angular/material2 19494 3
+google/ExoPlayer 18241 1
+alibaba/canal 17810 3
+Automattic/mongoose 17562 1
+numpy/numpy 17320 2
+explosion/spaCy 16383 1
+realm/realm-cocoa 15801 2
+dotnet/roslyn 15605 3
+google/fonts 15448 1
+sqlitebrowser/sqlitebrowser 15227 2
+golang/dep 14641 1
+elastic/kibana 13434 1
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
new file mode 100644
index 0000000000..c53bf0d0d7
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheHighestGrowthYoY --
+puppeteer/puppeteer 11310 1255 9.012 2014-03-14T12:01:39
+ohmyzsh/ohmyzsh 21705 2529 8.582 2017-03-22T16:44:20
+halfrost/LeetCode-Go 8887 1191 7.462 2018-04-16T09:29:48
+jitsi/jitsi-meet 10451 1548 6.751 2014-03-31T20:41:15
+desktop/desktop 12512 2600 4.812 2017-05-16T17:10:37
+TheAlgorithms/Javascript 6009 1312 4.58 2017-08-03T16:27:42
+iamadamdev/bypass-paywalls-chrome 9503 2246 4.231 2018-04-07T23:54:45
+loadimpact/k6 5018 1352 3.712 2017-01-18T18:26:09
+r-spacex/SpaceX-API 4020 1083 3.712 2017-06-26T07:00:38
+openspug/spug 4086 1116 3.661 2018-02-10T11:01:08
+Dod-o/Statistical-Learning-Method_Code 5227 1437 3.637 2018-11-15T16:38:25
+Fndroid/clash_for_windows_pkg 9438 2979 3.168 2018-10-19T00:14:07
+williamfiset/Algorithms 5339 1778 3.003 2017-05-12T03:37:24
+aniftyco/awesome-tailwindcss 2992 1007 2.971 2018-08-07T10:00:59
+LingCoder/OnJava8 11972 4082 2.933 2018-12-06T07:16:35
+the1812/Bilibili-Evolved 3678 1255 2.931 2018-08-30T09:55:58
+jgraph/drawio-desktop 9253 3293 2.81 2017-06-07T17:17:38
+darlinghq/darling 3130 1133 2.763 2015-10-11T15:42:44
+twintproject/twint 5899 2254 2.617 2018-06-12T03:34:17
+ctgk/PRML 5129 1970 2.604 2017-07-03T03:06:25
+tomnomnom/gron 2733 1051 2.6 2016-06-04T23:19:04
+trojan-gfw/trojan 10218 3945 2.59 2017-11-13T05:54:52
+dabreegster/abstreet 3865 1503 2.572 2018-06-06T22:07:38
+an-tao/drogon 3223 1262 2.554 2018-05-04T10:03:32
+ritchieng/the-incredible-pytorch 3499 1401 2.498 2017-02-11T08:37:30
+elsewhencode/project-guidelines 3752 1503 2.496 2018-03-21T18:06:16
+AlexeyAB/darknet 8569 3465 2.473 2016-12-04T19:18:28
+denoland/deno 31550 12833 2.459 2018-08-03T00:26:45
+GitSquared/edex-ui 14151 5797 2.441 2017-10-14T15:55:21
+MathewSachin/Captura 3392 1392 2.437 2015-09-12T12:31:42
+Aircoookie/WLED 2767 1141 2.425 2017-12-17T08:36:13
+tiangolo/fastapi 17962 7474 2.403 2018-12-08T10:05:29
+edent/SuperTinyIcons 3747 1559 2.403 2017-11-12T01:57:38
+remoteintech/remote-jobs 6819 2858 2.386 2017-09-09T13:12:05
+retejs/rete 2541 1075 2.364 2018-05-31T03:06:05
+Anuken/Mindustry 5439 2322 2.342 2017-05-12T17:52:31
+Dreamacro/clash 8836 3850 2.295 2018-06-10T14:41:49
+debauchee/barrier 5731 2505 2.288 2018-02-23T12:36:21
+ryansolid/solid 3249 1433 2.267 2018-05-26T14:28:51
+wilsonfreitas/awesome-quant 2362 1053 2.243 2016-05-10T10:19:52
+TheAlgorithms/Go 2905 1299 2.236 2017-07-11T04:34:48
+JanDeDobbeleer/oh-my-posh 2748 1229 2.236 2018-04-12T04:42:01
+The-Art-of-Hacking/h4cker 5791 2622 2.209 2018-10-06T12:02:56
+TheCherno/Hazel 2852 1292 2.207 2018-10-20T04:01:11
+FreeCAD/FreeCAD 3897 1777 2.193 2015-07-04T23:06:13
+squidfunk/mkdocs-material 2318 1066 2.174 2016-02-09T19:27:50
+JaeYeopHan/Interview_Question_for_Beginner 3727 1719 2.168 2017-06-16T15:39:58
+Requarks/wiki 5999 2769 2.166 2016-08-30T18:46:22
+midwayjs/midway 2257 1052 2.145 2018-07-12T07:12:06
+jwasham/coding-interview-university 54591 25556 2.136 2017-02-27T20:09:29
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
new file mode 100644
index 0000000000..1b8be962ee
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheMaximumAmountOfIssues1 --
+koorellasuresh/UKRegionTest 379379 4
+pddemo/demo 216215 1
+lstjsuperman/fabric 173986 1
+Khan/khan-exercises 157016 462
+No-CQRT/GooGuns 149264 1
+Khan/khan-i18n 130920 3
+jlippold/tweakCompatible 127029 11243
+Ramos-dev/jniwebshell 108096 1
+ron190/jsql-injection 91086 30
+debricked/debricked-test-integration 83341 1
+chrmarti/testissues 72695 19
+BoltunovOleg/ChatRoulette 69970 2
+imamandrews/imamandrews.github.io 68926 3
+Microsoft/vscode 65122 27038
+pulWifi/pulWifi 63002 4
+AdguardTeam/AdguardFilters 61979 634
+webcompat/web-bugs 61268 3959
+nainardev/tamil-dubbed 58392 1
+PennyDreadfulMTG/perf-reports 55259 5
+joshjach/zaptest1 48149 1
+ssi-qa/Test-ssi 45982 1
+flutter/flutter 45920 16677
+znjk123123/uoI3JGf 45797 1
+MicrosoftDocs/azure-docs 44131 21036
+xuyuhuan123/x 43079 1
+bippybop/iitest 41581 1
+webhintio/scan-issues 41570 4
+humera987/FXLabs-Test-Automation 41383 2
+test-organization-kkjeer/bot-validation 40140 8
+test-organization-kkjeer/app-test 39963 4
+ssi-qa/TestSSI 39666 1
+support-ops/sit-repo 39296 1
+antonba/ApimTest 37973 1
+microsoft/vscode 34798 19479
+theapache64/movie-monk-creator 34666 2
+ZeroK-RTS/CrashReports 34133 16
+koorellasuresh/samples 32636 1
+kubernetes/kubernetes 31644 8615
+golang/go 31443 10190
+shuhongwu/hockeyapp 31401 1
+hq450/fancyss 31124 778
+StepanFirsov/tutorials 30336 5
+as00789/--------- 29134 2
+zwwxy001/001 28833 1
+cockroachdb/cockroach 28390 1049
+tensorflow/tensorflow 28380 16377
+Zhycrin/Time 28104 1
+rust-lang/rust 28036 6283
+ikedaosushi/tech-news 27774 6
+ansible/ansible 27774 13050
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
new file mode 100644
index 0000000000..248c4d75f1
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheMaximumAmountOfIssues2 --
+koorellasuresh/UKRegionTest 379379 4 1
+pddemo/demo 216215 1 1
+lstjsuperman/fabric 173986 1 5
+Khan/khan-exercises 157016 462 1749
+No-CQRT/GooGuns 149264 1 0
+Khan/khan-i18n 130920 3 9
+jlippold/tweakCompatible 127029 11243 478
+Ramos-dev/jniwebshell 108096 1 5
+ron190/jsql-injection 91086 30 907
+debricked/debricked-test-integration 83341 1 0
+chrmarti/testissues 72695 19 9
+BoltunovOleg/ChatRoulette 69970 2 0
+imamandrews/imamandrews.github.io 68926 3 3
+Microsoft/vscode 65122 27038 82043
+pulWifi/pulWifi 63002 4 24
+AdguardTeam/AdguardFilters 61979 634 984
+webcompat/web-bugs 61268 3959 483
+nainardev/tamil-dubbed 58392 1 1
+PennyDreadfulMTG/perf-reports 55259 5 3
+joshjach/zaptest1 48149 1 0
+ssi-qa/Test-ssi 45982 1 0
+flutter/flutter 45920 16677 116303
+znjk123123/uoI3JGf 45797 1 0
+MicrosoftDocs/azure-docs 44131 21036 4888
+xuyuhuan123/x 43079 1 0
+bippybop/iitest 41581 1 0
+webhintio/scan-issues 41570 4 7
+humera987/FXLabs-Test-Automation 41383 2 0
+test-organization-kkjeer/bot-validation 40140 8 6
+test-organization-kkjeer/app-test 39963 4 5
+ssi-qa/TestSSI 39666 1 0
+support-ops/sit-repo 39296 1 0
+antonba/ApimTest 37973 1 0
+microsoft/vscode 34798 19479 38395
+theapache64/movie-monk-creator 34666 2 0
+ZeroK-RTS/CrashReports 34133 16 11
+koorellasuresh/samples 32636 1 0
+kubernetes/kubernetes 31644 8615 68644
+golang/go 31443 10190 92407
+shuhongwu/hockeyapp 31401 1 0
+hq450/fancyss 31124 778 7921
+StepanFirsov/tutorials 30336 5 0
+as00789/--------- 29134 2 1
+zwwxy001/001 28833 1 0
+cockroachdb/cockroach 28390 1049 21147
+tensorflow/tensorflow 28380 16377 173681
+Zhycrin/Time 28104 1 1
+rust-lang/rust 28036 6283 53027
+ikedaosushi/tech-news 27774 6 15
+ansible/ansible 27774 13050 51144
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
new file mode 100644
index 0000000000..70e0c239a9
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheMaximumAmountOfIssues3 --
+Khan/khan-exercises 157016 462 1749
+Microsoft/vscode 65122 27038 82043
+flutter/flutter 45920 16677 116303
+MicrosoftDocs/azure-docs 44131 21036 4888
+microsoft/vscode 34798 19479 38395
+kubernetes/kubernetes 31644 8615 68644
+golang/go 31443 10190 92407
+hq450/fancyss 31124 778 7921
+cockroachdb/cockroach 28390 1049 21147
+tensorflow/tensorflow 28380 16377 173681
+rust-lang/rust 28036 6283 53027
+ansible/ansible 27774 13050 51144
+elastic/kibana 26962 4151 13434
+dotnet/roslyn 24027 3153 15605
+godotengine/godot 23546 5521 34238
+996icu/996.ICU 22791 12818 354850
+rancher/rancher 22512 4689 15241
+saltstack/salt 22450 5777 12989
+angular/angular 21806 10403 80602
+Microsoft/TypeScript 21004 6744 52328
+fanout/pushpin 20793 260 2928
+/ 20676 883 5496
+facebook/react-native 19926 11861 105346
+dart-lang/sdk 19737 2965 6976
+TrinityCore/TrinityCore 19513 2806 7942
+spring-projects/spring-boot 19349 5732 58232
+ant-design/ant-design 19149 9312 71552
+magento/magento2 18884 7452 10987
+NixOS/nixpkgs 18497 3236 6679
+JuliaLang/julia 18456 3227 34480
+owncloud/core 18366 6352 9048
+andresriancho/w3af 18128 394 3713
+elastic/elasticsearch 18111 5912 48810
+dotnet/corefx 17693 4157 20702
+grafana/grafana 17543 7973 39147
+pytorch/pytorch 16622 7044 47889
+FortAwesome/Font-Awesome 16438 12745 75924
+rg3/youtube-dl 16144 8557 51271
+hashicorp/terraform 15869 8496 26227
+CleverRaven/Cataclysm-DDA 15797 2927 5293
+ethereum/go-ethereum 15632 2526 30598
+ElemeFE/element 15541 8909 53749
+atom/atom 14919 10357 68396
+symfony/symfony 14712 6383 27656
+Automattic/wp-calypso 14616 953 13129
+npm/npm 14494 11403 16774
+laravel/framework 14341 8388 25317
+rails/rails 13904 7909 53620
+twbs/bootstrap 13599 8526 126371
+odoo/odoo 12941 4196 22407
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
new file mode 100644
index 0000000000..c1db9f542a
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheMaximumAmountOfIssues4 --
+Microsoft/vscode 65122 27038 82043
+MicrosoftDocs/azure-docs 44131 21036 4888
+microsoft/vscode 34798 19479 38395
+flutter/flutter 45920 16677 116303
+tensorflow/tensorflow 28380 16377 173681
+ansible/ansible 27774 13050 51144
+996icu/996.ICU 22791 12818 354850
+FortAwesome/Font-Awesome 16438 12745 75924
+facebook/react-native 19926 11861 105346
+npm/npm 14494 11403 16774
+jlippold/tweakCompatible 127029 11243 478
+githubschool/open-enrollment-classes-introduction-to-github 12094 10730 921
+angular/angular 21806 10403 80602
+atom/atom 14919 10357 68396
+golang/go 31443 10190 92407
+ContinuumIO/anaconda-issues 11834 9570 688
+ant-design/ant-design 19149 9312 71552
+ElemeFE/element 15541 8909 53749
+kubernetes/kubernetes 31644 8615 68644
+rg3/youtube-dl 16144 8557 51271
+twbs/bootstrap 13599 8526 126371
+hashicorp/terraform 15869 8496 26227
+laravel/framework 14341 8388 25317
+docker/for-win 9429 8124 1418
+grafana/grafana 17543 7973 39147
+rails/rails 13904 7909 53620
+magento/magento2 18884 7452 10987
+angular/angular-cli 12114 7313 26924
+pytorch/pytorch 16622 7044 47889
+qbittorrent/qBittorrent 10988 6762 12064
+Microsoft/TypeScript 21004 6744 52328
+docker/docker 12292 6466 33396
+symfony/symfony 14712 6383 27656
+owncloud/core 18366 6352 9048
+rust-lang/rust 28036 6283 53027
+facebook/react 9651 6271 188575
+nodejs/node 11756 6221 75477
+XX-net/XX-Net 12533 6192 36800
+electron/electron 10445 6059 71394
+elastic/elasticsearch 18111 5912 48810
+Wynncraft/Issues 8840 5854 229
+spyder-ide/spyder 11348 5818 6558
+travis-ci/travis-ci 10057 5800 9368
+saltstack/salt 22450 5777 12989
+angular/angular.js 8785 5757 76251
+spring-projects/spring-boot 19349 5732 58232
+home-assistant/home-assistant 11875 5632 30023
+gatsbyjs/gatsby 11540 5565 51589
+godotengine/godot 23546 5521 34238
+nextcloud/server 11355 5471 13428
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
new file mode 100644
index 0000000000..fcb9bfde58
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheMaximumAmountOfPullRequests1 --
+google-test/signcla-probe-repo 351806 4
+everypolitician/everypolitician-data 158134 18
+brianchandotcom/liferay-portal 93222 338
+NixOS/nixpkgs 84557 3816
+Homebrew/homebrew-core 60457 5852
+sauron-demo/sauron 54806 1
+elastic/kibana 52317 832
+test-organization-kkjeer/bot-validation 51409 4
+SmartThingsCommunity/SmartThingsPublic 51280 716
+test-organization-kkjeer/app-test 51006 6
+kubernetes/kubernetes 50768 4124
+odoo/odoo 46764 2038
+Homebrew/homebrew-cask 44006 3378
+ansible/ansible 42592 7337
+caskroom/homebrew-cask 38985 4825
+ceph/ceph 37495 1413
+code-dot-org/code-dot-org 37133 125
+jlord/patchwork 36787 31919
+rdxvsrmv/OfficeDocs-OfficeUpdates-test 36706 7
+DefinitelyTyped/DefinitelyTyped 36240 13826
+elastic/elasticsearch 35673 2030
+saltstack/salt 35222 3067
+rust-lang/rust 35214 3259
+apple/swift 33758 1154
+openmicroscopy/snoopys-sandbox 32507 9
+argo-testing/app 31861 1
+Automattic/wp-calypso 31687 629
+mozilla-b2g/gaia 30403 911
+apache/spark 30079 2970
+pytorch/pytorch 29990 2192
+cms-sw/cmssw 29045 973
+sauron-demo/sauron-demo 28654 12
+dimagi/commcare-hq 28143 127
+CleverRaven/Cataclysm-DDA 27698 1430
+cockroachdb/cockroach 27386 449
+firstcontributions/first-contributions 27015 24995
+ros/rosdistro 26541 1197
+ideatest1/PullRequestTest 26336 1
+JuliaRegistries/General 25487 171
+tgstation/tgstation 25305 967
+rails/rails 25232 5621
+openshift/openshift-docs 25146 677
+edx/edx-platform 25049 737
+bbq-beets/ForkPRCanary 24593 1
+dotnet/roslyn 24488 582
+dotnet/corefx 24151 1085
+flutter/flutter 23707 1331
+symfony/symfony 23572 3617
+void-linux/void-packages 23522 790
+bioconda/bioconda-recipes 23249 1209
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
new file mode 100644
index 0000000000..7fa7ea866f
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheMaximumAmountOfPullRequests2 --
+jlord/patchwork 36787 31919
+firstcontributions/first-contributions 27015 24995
+octocat/Spoon-Knife 20116 18204
+DefinitelyTyped/DefinitelyTyped 36240 13826
+deadlyvipers/dojo_rules 15925 9751
+google/it-cert-automation-practice 10132 9749
+udacity/create-your-own-adventure 10423 8839
+JetBrains/swot 9866 8291
+udacity/course-collaboration-travel-plans 8417 8132
+zero-to-mastery/start-here-guidelines 8940 8112
+githubschool/open-enrollment-classes-introduction-to-github 9299 7534
+learn-co-students/js-from-dom-to-node-bootcamp-prep-000 7435 7383
+ansible/ansible 42592 7337
+learn-co-students/javascript-intro-to-functions-lab-bootcamp-prep-000 7161 7131
+learn-co-students/js-functions-lab-bootcamp-prep-000 6984 6950
+learn-co-students/js-node-practice-lab-bootcamp-prep-000 6761 6736
+learn-co-students/js-if-else-files-lab-bootcamp-prep-000 6523 6509
+learn-co-students/javascript-arithmetic-lab-bootcamp-prep-000 6501 6472
+learn-co-students/js-what-is-a-test-lab-bootcamp-prep-000 6344 6329
+learn-co-students/first-ide-lab-bootcamp-prep-000 6250 6202
+AliceWonderland/hacktoberfest 7550 6092
+learn-co-students/js-what-is-a-test-bootcamp-prep-000 6060 6048
+learn-co-students/javascript-fix-the-scope-lab-bootcamp-prep-000 5978 5957
+Roshanjossey/first-contributions 6337 5931
+Homebrew/homebrew-core 60457 5852
+TheOdinProject/curriculum 21191 5847
+MicrosoftDocs/azure-docs 18001 5827
+freeCodeCamp/freeCodeCamp 19485 5716
+rails/rails 25232 5621
+learn-co-students/javascript-arrays-bootcamp-prep-000 5475 5441
+learn-co-students/javascript-arrays-lab-bootcamp-prep-000 5226 5197
+laravel/framework 20000 5082
+learn-co-students/javascript-objects-bootcamp-prep-000 4937 4911
+freddier/hyperblog 5000 4830
+caskroom/homebrew-cask 38985 4825
+learn-co-students/your-first-lab-cb-gh-000 4727 4700
+learn-co-students/javascript-objects-lab-bootcamp-prep-000 4668 4652
+Homebrew/homebrew 19058 4361
+gatsbyjs/gatsby 15847 4358
+wbond/package_control_channel 7843 4358
+learn-co-students/javascript-intro-to-looping-bootcamp-prep-000 4350 4325
+rdpeng/ProgrammingAssignment2 4713 4318
+michaelliao/learngit 4574 4299
+mxcl/homebrew 12780 4283
+kubernetes/kubernetes 50768 4124
+learn-co-students/javascript-logging-lab-js-intro-000 4112 4086
+CocoaPods/Specs 13787 4072
+learn-co-students/js-beatles-loops-lab-bootcamp-prep-000 4042 4024
+LarryMad/recipes 4417 4018
+helm/charts 12273 3956
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
new file mode 100644
index 0000000000..32fc27fe47
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheMaximumNumberOfAcceptedInvitations --
+githubschool/open-enrollment-classes-introduction-to-github 10453 921
+gatsbyjs/gatsby 3161 51589
+/ 3144 5496
+openjournals/joss-reviews 1733 411
+InfiniteFlightAirportEditing/Airports 684 192
+zulip/zulip 644 14027
+tencentyun/qcloud-documents 446 1032
+w3c/web-platform-tests 343 1662
+llvm/llvm-project 322 7228
+koppi/iso-country-flags-svg-collection 318 408
+zephyrproject-rtos/zephyr 291 4198
+Automattic/wp-calypso 246 13129
+FightPandemics/FightPandemics 238 108
+magento/magento2 234 10987
+dotnet/corefx 216 20702
+helm/charts 213 11693
+oppia/oppia 210 1802
+Code4SocialGood/c4sg-web 184 100
+pqrs-org/KE-complex_modifications 174 701
+IBM-Bluemix/docs 166 153
+OfficeDev/office-ui-fabric-react 156 7194
+openshiftio/openshift.io 155 106
+julianguyen/ifme 150 547
+dotnet/runtime 149 4842
+Techtonica/curriculum 149 437
+pytorch/pytorch 139 47889
+MicrosoftDocs/mixed-reality 138 155
+ifmeorg/ifme 136 728
+magento-engcom/msi 135 234
+MicrosoftDocs/office-docs-powershell 132 342
+MicrosoftDocs/azure-docs 126 4888
+leanprover-community/mathlib 125 420
+pytorch/vision 124 8418
+pytorch/tutorials 121 4838
+pytorch/text 120 2706
+MicrosoftDocs/visualstudio-docs 120 630
+sigmavirus24/Todo.txt-python 120 109
+MicrosoftDocs/OfficeDocs-SharePoint 119 254
+MicrosoftDocs/feedback 118 223
+pytorch/builder 116 156
+MicrosoftDocs/windowsserverdocs 115 926
+MicrosoftDocs/OfficeDocs-SkypeForBusiness 115 220
+MicrosoftDocs/windows-powershell-docs 115 213
+cockroachdb/cockroach 114 21147
+MicrosoftDocs/windows-itpro-docs 114 952
+MicrosoftDocs/intellicode 114 443
+MicrosoftDocs/edge-developer 114 157
+hoodiehq/camp 114 124
+MicrosoftDocs/microsoft-365-docs 113 296
+pytorch/examples 112 16121
+
diff --git a/regression-test/data/github_events_p2/sql/repositoriesWithTheWorstStagnation_order.out b/regression-test/data/github_events_p2/sql/repositoriesWithTheWorstStagnation_order.out
new file mode 100644
index 0000000000..c9820012bb
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoriesWithTheWorstStagnation_order.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoriesWithTheWorstStagnation_order --
+AioiLight/TJAPlayer3 29 5308 0.005 2018-01-17T19:59:10
+Bogdan-Lyashenko/codecrumbs 199 2293 0.087 2018-05-03T10:50:17
+CoolPhilChen/SJTU-Courses 538 5739 0.094 2018-01-20T02:04:41
+DoubleLabyrinth/navicat-keygen 1 6459 0.0 2017-12-08T02:04:48
+FreeCodeCampChina/freecodecamp.cn 343 7651 0.045 2016-09-24T10:10:42
+JesseKPhillips/USA-Constitution 93 1924 0.048 2017-11-16T21:14:35
+KidkArolis/jetpack 32 1174 0.027 2017-03-13T12:09:24
+Louiszhai/tool 418 4286 0.098 2016-07-14T06:04:09
+M4cs/BabySploit 126 71013 0.002 2018-11-11T10:10:30
+RomuloOliveira/commit-messages-guide 305 5817 0.052 2018-02-26T02:54:42
+SqueezerIO/squeezer 41 3307 0.012 2017-05-15T07:31:14
+TheBerkin/rant 83 1283 0.065 2017-07-24T23:31:51
+Wookai/paper-tips-and-tricks 251 2705 0.093 2015-07-09T18:16:32
+achael/eht-imaging 170 5358 0.032 2016-02-03T03:06:34
+adblockradio/adblockradio 100 1184 0.084 2018-11-15T14:33:52
+apachecn/awesome-algorithm 191 3424 0.056 2018-09-24T16:46:26
+app-developers/top 37 1950 0.019 2018-06-27T08:04:07
+arpitjindal97/technology_books 1 4001 0.0 2017-08-16T19:08:59
+b3log/pipe 2 2380 0.001 2017-12-20T05:08:15
+charlax/professional-programming 1112 12892 0.086 2016-05-07T03:25:06
+chrisdickinson/git-rs 88 1197 0.074 2018-12-22T05:52:49
+danijar/handout 140 1825 0.077 2018-11-24T21:07:46
+dengyuhan/magnetW 54 4215 0.013 2018-03-09T09:18:23
+dwyl/learn-json-web-tokens 175 2500 0.07 2015-07-06T13:09:04
+ecthros/uncaptcha2 259 4219 0.061 2018-12-31T17:20:19
+energicryptocurrency/energi 12 6720 0.002 2017-07-14T16:01:39
+everitoken/evt 8 1366 0.006 2018-04-23T03:57:30
+facebookincubator/redux-react-hook 185 1799 0.103 2018-11-09T16:19:29
+facebookincubator/spectrum 131 1471 0.089 2018-11-20T16:31:01
+geekinglcq/CDCS 154 1628 0.095 2018-03-19T07:54:49
+hiroppy/fusuma 332 3327 0.1 2018-04-27T01:43:35
+jeffgerickson/algorithms 677 6137 0.11 2018-12-28T03:01:40
+jfcoz/postgresqltuner 146 1750 0.083 2016-12-15T22:08:38
+jhuangtw-dev/xg2xg 600 7033 0.085 2017-01-07T15:54
+kezhenxu94/mini-github 50 1283 0.039 2018-11-04T15:11:38
+koekeishiya/chunkwm 61 1331 0.046 2017-01-15T14:43:56
+lib-pku/libpku 1950 23015 0.085 2018-11-22T13:35:21
+marcan/takeover.sh 112 2786 0.04 2017-02-10T16:27:02
+metatron-app/metatron-discovery 119 3120 0.038 2018-07-27T07:55:44
+mgp25/Instagram-API 96 1769 0.054 2015-11-16T18:48:36
+mlabouardy/komiser 189 1904 0.099 2018-03-17T16:43:27
+react-native-training/react-native-elements 48 3341 0.014 2017-04-03T04:27:02
+sinclairzx81/zero 94 2160 0.044 2017-06-14T03:45:10
+soheilpro/catj 52 1307 0.04 2014-12-13T06:16:38
+sveinbjornt/Sloth 329 3483 0.094 2011-12-03T20:50:21
+trimstray/htrace.sh 221 2788 0.079 2018-07-13T22:40:41
+trimstray/the-practical-linux-hardening-guide 516 7355 0.07 2018-10-06T22:36:36
+trojanowski/react-apollo-hooks 90 1976 0.046 2018-10-29T07:56:09
+uswds/public-sans 272 3601 0.076 2018-10-06T20:42:23
+x-ream/x7 131 1275 0.103 2018-12-23T13:46:14
+
diff --git a/regression-test/data/github_events_p2/sql/repositoryAffinityList1.out b/regression-test/data/github_events_p2/sql/repositoryAffinityList1.out
new file mode 100644
index 0000000000..c0cc75a4d1
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/repositoryAffinityList1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !repositoryAffinityList1 --
+tensorflow/tensorflow 4895
+golang/go 4354
+pingcap/tidb 4128
+donnemartin/system-design-primer 4020
+sindresorhus/awesome 3899
+prometheus/prometheus 3881
+avelino/awesome-go 3792
+kubernetes/kubernetes 3741
+grafana/grafana 3574
+facebook/react 3511
+vuejs/vue 3347
+gin-gonic/gin 3246
+flutter/flutter 3160
+facebook/rocksdb 3156
+antirez/redis 3101
+istio/istio 3094
+ansible/ansible 3094
+torvalds/linux 3092
+minio/minio 3068
+cockroachdb/cockroach 3006
+robbyrussell/oh-my-zsh 2981
+vinta/awesome-python 2964
+996icu/996.ICU 2959
+grpc/grpc 2942
+jlevy/the-art-of-command-line 2916
+elastic/elasticsearch 2781
+containous/traefik 2776
+hashicorp/consul 2745
+rust-lang/rust 2673
+wg/wrk 2671
+metabase/metabase 2666
+facebook/react-native 2656
+kamranahmedse/developer-roadmap 2642
+ant-design/ant-design 2602
+GoogleChrome/puppeteer 2549
+getify/You-Dont-Know-JS 2504
+apache/spark 2486
+google/leveldb 2475
+github/gitignore 2437
+airbnb/javascript 2435
+coreos/etcd 2429
+danistefanovic/build-your-own-x 2392
+Microsoft/vscode 2375
+fatedier/frp 2367
+tensorflow/models 2355
+getsentry/sentry 2354
+dgraph-io/dgraph 2338
+TheAlgorithms/Python 2320
+mholt/caddy 2317
+astaxie/build-web-application-with-golang 2317
+
diff --git a/regression-test/data/github_events_p2/sql/starsFromHeavyGithubUsers1.out b/regression-test/data/github_events_p2/sql/starsFromHeavyGithubUsers1.out
new file mode 100644
index 0000000000..17bde7f690
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/starsFromHeavyGithubUsers1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !starsFromHeavyGithubUsers1 --
+facebook/react 121976
+vuejs/vue 109518
+996icu/996.ICU 109244
+sindresorhus/awesome 106729
+getify/You-Dont-Know-JS 102997
+tensorflow/tensorflow 96960
+kamranahmedse/developer-roadmap 93499
+FreeCodeCamp/FreeCodeCamp 89246
+airbnb/javascript 81594
+donnemartin/system-design-primer 79909
+github/gitignore 79316
+torvalds/linux 77051
+robbyrussell/oh-my-zsh 75246
+twbs/bootstrap 70968
+jwasham/coding-interview-university 68898
+facebook/react-native 65952
+flutter/flutter 65423
+danistefanovic/build-your-own-x 62992
+golang/go 62718
+vhf/free-programming-books 62366
+M4cs/BabySploit 61966
+trekhleb/javascript-algorithms 59556
+jlevy/the-art-of-command-line 58887
+resume/resume.github.com 57943
+Microsoft/vscode 57636
+freeCodeCamp/freeCodeCamp 57145
+vinta/awesome-python 57027
+nodejs/node 50677
+FortAwesome/Font-Awesome 50169
+angular/angular.js 49818
+angular/angular 48952
+EbookFoundation/free-programming-books 48548
+daneden/animate.css 47795
+nvbn/thefuck 47668
+TheAlgorithms/Python 46791
+hakimel/reveal.js 46051
+mrdoob/three.js 46046
+atom/atom 46045
+kubernetes/kubernetes 45303
+webpack/webpack 45159
+toddmotto/public-apis 45011
+electron/electron 44893
+avelino/awesome-go 44819
+apple/swift 43735
+laravel/laravel 43569
+ant-design/ant-design 43134
+GoogleChrome/puppeteer 42974
+django/django 41836
+tonsky/FiraCode 41629
+adam-p/markdown-here 40647
+
diff --git a/regression-test/data/github_events_p2/sql/starsFromHeavyGithubUsers2.out b/regression-test/data/github_events_p2/sql/starsFromHeavyGithubUsers2.out
new file mode 100644
index 0000000000..4c414523e5
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/starsFromHeavyGithubUsers2.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !starsFromHeavyGithubUsers2 --
+facebook/react 56889
+getify/You-Dont-Know-JS 49496
+sindresorhus/awesome 48750
+vuejs/vue 43864
+airbnb/javascript 40277
+kamranahmedse/developer-roadmap 39809
+tensorflow/tensorflow 38087
+resume/resume.github.com 37815
+robbyrussell/oh-my-zsh 37015
+donnemartin/system-design-primer 36259
+torvalds/linux 35229
+github/gitignore 34664
+golang/go 31545
+danistefanovic/build-your-own-x 30382
+facebook/react-native 30200
+Microsoft/vscode 29541
+twbs/bootstrap 29045
+vhf/free-programming-books 29025
+jlevy/the-art-of-command-line 28095
+FreeCodeCamp/FreeCodeCamp 27446
+trekhleb/javascript-algorithms 26912
+flutter/flutter 26693
+jwasham/coding-interview-university 26360
+nvbn/thefuck 26204
+hakimel/reveal.js 25546
+FortAwesome/Font-Awesome 24949
+nodejs/node 24475
+angular/angular.js 23688
+webpack/webpack 23617
+toddmotto/public-apis 23601
+rust-lang/rust 23408
+996icu/996.ICU 23405
+atom/atom 23250
+gatsbyjs/gatsby 23062
+GoogleChrome/puppeteer 22863
+tonsky/FiraCode 22544
+zeit/next.js 22455
+daneden/animate.css 22396
+kubernetes/kubernetes 22151
+apple/swift 22129
+avelino/awesome-go 21905
+vinta/awesome-python 21870
+mrdoob/three.js 21756
+rails/rails 21095
+typicode/json-server 20671
+yarnpkg/yarn 20650
+neovim/neovim 20466
+Microsoft/TypeScript 20355
+angular/angular 20242
+papers-we-love/papers-we-love 20168
+
diff --git a/regression-test/data/github_events_p2/sql/theLongestRepositoryNames1.out b/regression-test/data/github_events_p2/sql/theLongestRepositoryNames1.out
new file mode 100644
index 0000000000..cb9435c8a3
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/theLongestRepositoryNames1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !theLongestRepositoryNames1 --
+1 JonathanJonathanJonathanJonathanJonatha/JonathanJonathanJonathanJonathanJonathanJonathanJonathanJonathanJonathanJonathanJonathanJonathanJona
+1 UDtUf4aRyjv7nU3YTg056xCJw1ghAJYXgad7oB5/hJJRB7rpa3IXwX8HRsA1B4jCDmlZBY9fAzXZWNPyhrsXYG5kCeC4RPFqKQ4I9sAu1aNzX2G6wAkBjm8BjPfKjdubEqkmeAIkIwgu
+1 a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a/a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-a-
+1 accounts-inheritance-finders-of-america/eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
+1 dldadnasjndfsjafajnsdfadnfadfkoafasdklk/fjkdasifjasdiofasiodfasjdogasdgajsdpgasdpgasjkdgo-askdpgspkdgvjaspgpasjidpgjiajisdgpjioasdpigasgpjia
+15 fkdjfkdkfjskfjsldkfjvndkslakfjgkdlskfjg/fksfekgkslgkkdjfkdlskfjkfkdlslakdjfkekjlklfkjdkslkjfojksjdfaskdjfsalkdfj-laskfjls-kdajfoasjfpoawefjk
+4 joooooooooooooooooooooooooooooooooooooj/jooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooj
+1 joooooooooooooooooooooooooooooooooooooj/jooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
+3 uwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwu/uwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuwuuwuwuwuwuwuwuwuwuwuwuw
+2 yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy/yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy
+2 Gremling-Machine-Learning-Study-Group/A-Simple-Deep-Neural-Network-Approach-to-Estimate-the-Reproduction-Number-for-Pandemic-Influenza-R0
+11 yingyingyingyingyingyingyingyingying/yingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingyingying
+1 reeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee/reeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
+1 1b3634f6-9166-46d7-a43a-51d575159cf0/Name-INDIVIDUAL-ENTREPRENEURSAPRYGIN-SERGEY-ALEXANDROVICH-Legal-address-152300-RUSSIA-YAROSLAVSKAY
+3 Artificial-Intelligence-Big-Data-Lab/A-Multi-Layer-and-Multi-Ensembled-Stock-Trader-Using-Deep-Learning-and-Deep-Reinforcement-Learning
+1 Gremling-Machine-Learning-Study-Group/Extracting-the-Ideality-Factor-of-a-Diode-on-the-Single-Diode-Solar-Cell-Model-with-Deep-Learning
+14 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb/bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
+8466 eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee/eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
+89 uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu/uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
+1 1b3634f6-9166-46d7-a43a-51d575159cf0/Correspondent-account-30101810945250000297-TIN-KPP-of-the-bank-7706092528-770543003-BIC-0445252
+3 kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk/kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk
+1 Smithju1986-org-Gibbstersgame-ca/windows10-Systems-Android-10-phone-latin-reset-my-Enterprise-lib-set-IT-NETWORKING-smithju1986.org
+1 abortionpillsforsaleintembisa/0734408121-Abortion-Pills-For-Sale-In-Tembisa-Mamelodi-Ssoshanguve-Mabopane-Witbank-Rustenburg-Mafik
+1 Artificial-Intelligence-for-NLP/Source-Code-of-Pragmatic-Artificial-Intelligence-Algorithms-Based-on-Natrual-Language-Processing
+2 hmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm/hmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm
+570 reeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee/reeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
+1 Gremling-Machine-Learning-Study-Group/Deep-Learning-na-analise-de-imagens-de-raio-x-para-auxilio-na-decis-o-clinica-de-COVID-19
+4 1b3634f6-9166-46d7-a43a-51d575159cf0/t.1FqJlUEmmyCmGBMs1HHLszGztmmESHtJfcGQQN0V4Abbj-KUGfc4s8hX2ID89sfAlR9ogNwxscREeDrfkiqzZA
+4 HCIT-Computing-Intelligence/Source-Code-of-Pragmatic-Artificial-Intelligence-Algorithms-Based-on-Natrual-Language-Processing
+1 ArthurEmanuelRodriguesCosta/PIBITI-2015-2016-VISUALIZA-O-DO-GRAFO-DE-CORRELA-O-ENTRE-DISCIPLINAS-NO-CURSO-DE-COMPUTA-O-UFCG
+1 BurakKahramanHacettepe/Drug-Sensitivity-Prediction-for-Cancer-Cell-lines-with-Pairwise-Input-Graph-Convolutional-Neural-Net
+4 Data-Science-and-Data-Analytics-Courses/MITx---Machine-Learning-with-Python-From-Linear-Models-to-Deep-Learning-Jun-11-2019
+1 EduardoMartinezEnriquez/Optimized-Update-Prediction-Assignment-for-Lifting-Transforms-on-Graphs-III-Multiresolution-example
+1 deepakrajpurushothaman/Solution-to-Trajectory-planning-problem-using-dynamic-optimization-method-and-meta-heuristic-solver-
+1 globalmigrateimmigration/The-Australia-working-holiday-visa-subclass-417-is-a-visa-in-a-perfect-world-appropriate-for-young
+4 DeligenceTechnologies/Home-Automation-to-monitor-heat-fire-smoke-CO-and-room-by-room-movement-of-people-using-Raspberry-Pi
+1 Md-Samiul-Abid-Chowdhury/inputting-from-and-outputting-in-any-positive-integer-in-dos-console-using-assembly-language-8086
+1 Money-Maker-Research/commmodity-tipsCommodities-are-leveraged-products-where-one-needs-to-pay-initial-margin-to-take-posi
+5 during-master-degree/M.E-Energy-Efficient-Power-and-Subcarrier-Allocation-for-OFDMA-Systems-with-Value-Function-Approxima
+1 todo-sobre-el-universo/todo-sobre-el-universo.github.io-Te-presentamos-todo-acerca-del-universo-El-Sistema-Solar-Agujeros
+1 DevExpress-Examples/Reporting_aspxreportdesigner-how-to-create-an-aspnet-end-user-reporting-application-with-the-t227679
+3 DevExpress-Examples/XAF_how-to-use-google-facebook-and-microsoft-accounts-in-aspnet-xaf-applications-oauth2-demo-t535280
+5 Esmaeili-Najafabadi/Designing-Sequence-With-Minimum-PSL-Using-Chebyshev-Distance-and-its-Application-for-Chaotic-MIMO-Ra
+1 InternetofThings2017/is-open-is-pr-author-Eskimo2016-comments-50-user-InternetofThings2017-sort-updated-desc-is-private-
+3 SmartPracticeschool/SBSPS-Challenge-4528-Creating-The-Twitter-Sentiment-Analysis-Program-in-Python-with-Naive-Bayes-Clas
+1 SmartPracticeschool/llSPS-INT-3437-Predicting-the-Energy-Output-of-Wind-Turbine-Based-on-Weather-Conditions-Watson-Auto-
+6 nirmalsenthilnathan/Open-Set-Domain-Adaptation-for-Hyperspectral-Image-Classification-Using-Generative-Adversarial-Netwo
+1 thomasrussellmurphy/eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
+1 Brundashanthmurthy/Image-Processing-Global-Thresholding-Techniques-and-Morphological-Operations-Using-MATLAB-and-Python
+6 Computing-Intelligence/Source-Code-of-Pragmatic-Artificial-Intelligence-Algorithms-Based-on-Natrual-Language-Processing
+
diff --git a/regression-test/data/github_events_p2/sql/theLongestRepositoryNames2.out b/regression-test/data/github_events_p2/sql/theLongestRepositoryNames2.out
new file mode 100644
index 0000000000..d485cd7caf
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/theLongestRepositoryNames2.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !theLongestRepositoryNames2 --
+2/t 1
+e/m 1
+f/f 7
+s/s 1
+19/x 2
+3x/n 2
+69/a 3
+7f/h 2
+9H/F 2
+9H/Z 1
+Xe/h 7
+Xe/x 32
+as/a 289
+cv/t 23
+f/hy 1
+f/pq 162
+f/r3 6
+hf/q 6
+i/AI 1
+mg/i 5
+nd/e 1
+tj/n 13477
+0/... 1
+0/Eos 1
+0/RPS 1
+0a-/M 1
+0tv/t 1
+1-t/h 1
+13/GC 1
+17h/h 1
+19/19 2
+2vk/- 1
+2vn/x 1
+39M/M 14
+3F/Jt 1
+3p/3p 1
+4bx/a 1
+4hj/- 1
+5-7/- 1
+51c/0 1
+51c/1 4
+51c/2 1
+51c/3 3
+51c/4 1
+51c/5 1
+51c/6 1
+520/a 7
+520/b 8
+520/q 6
+57/ti 2
+
diff --git a/regression-test/data/github_events_p2/sql/theMostToughCodeReviews.out b/regression-test/data/github_events_p2/sql/theMostToughCodeReviews.out
new file mode 100644
index 0000000000..5a9b490a97
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/theMostToughCodeReviews.out
@@ -0,0 +1,52 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !theMostToughCodeReviews --
+https://github.com/torvalds/linux/pull/684 66
+https://github.com/NixOS/rfcs/pull/49 52
+https://github.com/sunpy/sunpy/pull/3391 52
+https://github.com/dashbitco/mix_phx_gen_auth_demo/pull/1 51
+https://github.com/reactjs/rfcs/pull/2 44
+https://github.com/php/php-rfcs/pull/1 40
+https://github.com/danielmiessler/SecLists/pull/155 38
+https://github.com/symfony/symfony/pull/33553 35
+https://github.com/kubernetes/community/pull/306 34
+https://github.com/rust-lang/rfcs/pull/2850 33
+https://github.com/date-fns/date-fns/pull/1671 32
+https://github.com/github/site-policy/pull/1 31
+https://github.com/996icu/996.ICU/pull/25509 30
+https://github.com/dotnet/designs/pull/92 30
+https://github.com/symfony/symfony/pull/11882 30
+https://github.com/tc39/ecma262/pull/1062 30
+https://github.com/rust-lang/rfcs/pull/517 29
+https://github.com/open-telemetry/oteps/pull/97 28
+https://github.com/matrix-org/matrix-doc/pull/1772 27
+https://github.com/scipy/scipy/pull/11061 27
+https://github.com/Samsung/tizen-docs/pull/871 26
+https://github.com/bitcoin/bitcoin/pull/17977 25
+https://github.com/rust-lang/rfcs/pull/1566 25
+https://github.com/babel/babel.github.io/pull/1014 24
+https://github.com/bitcoin-core/secp256k1/pull/558 24
+https://github.com/opscode/chef-rfc/pull/21 24
+https://github.com/rust-lang/rust-www/pull/202 24
+https://github.com/NordicPlayground/fw-nrfconnect-nrf/pull/1854 23
+https://github.com/bitcoin/bitcoin/pull/7910 23
+https://github.com/kubernetes/enhancements/pull/686 23
+https://github.com/nodejs/modules/pull/23 23
+https://github.com/nodejs/node/pull/11533 23
+https://github.com/openshift/openshift-docs/pull/18254 23
+https://github.com/rust-lang/rfcs/pull/2395 23
+https://github.com/EpicGames/Signup/pull/10 22
+https://github.com/PowerShell/PowerShell-RFC/pull/185 22
+https://github.com/apache/kafka/pull/6295 22
+https://github.com/hannahhch/github-cheatsheet/pull/4 22
+https://github.com/kubernetes/community/pull/1629 22
+https://github.com/nodejs/node/pull/5020 22
+https://github.com/reactjs/rfcs/pull/6 22
+https://github.com/rust-lang/rfcs/pull/1105 22
+https://github.com/symfony/symfony/pull/23315 22
+https://github.com/symfony/symfony/pull/24411 22
+https://github.com/tgstation/tgstation/pull/27155 22
+https://github.com/whatwg/html/pull/3752 22
+https://github.com/Samsung/tizen-docs/pull/1250 21
+https://github.com/bids-standard/pybids/pull/308 21
+https://github.com/kubernetes/enhancements/pull/1367 21
+https://github.com/rails/rails/pull/19832 21
diff --git a/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub1.out b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub1.out
new file mode 100644
index 0000000000..fab617dc2b
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub1.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !theTotalNumberOfUsersOnGithub1 --
+34099240
+
diff --git a/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub2.out b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub2.out
new file mode 100644
index 0000000000..c0e76b3f3c
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub2.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !theTotalNumberOfUsersOnGithub2 --
+10131322
+
diff --git a/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub3.out b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub3.out
new file mode 100644
index 0000000000..7128c5d93a
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub3.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !theTotalNumberOfUsersOnGithub3 --
+18808891
+
diff --git a/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub4.out b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub4.out
new file mode 100644
index 0000000000..f8c51ce947
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/theTotalNumberOfUsersOnGithub4.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !theTotalNumberOfUsersOnGithub4 --
+6418718
+
diff --git a/regression-test/data/github_events_p2/sql/topRepositoriesByStars.out b/regression-test/data/github_events_p2/sql/topRepositoriesByStars.out
new file mode 100644
index 0000000000..b1db1d89d4
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/topRepositoriesByStars.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !topRepositoriesByStars --
+996icu/996.ICU 354850
+FreeCodeCamp/FreeCodeCamp 225490
+vuejs/vue 199731
+facebook/react 188575
+tensorflow/tensorflow 173681
+sindresorhus/awesome 160542
+kamranahmedse/developer-roadmap 147561
+getify/You-Dont-Know-JS 144146
+freeCodeCamp/freeCodeCamp 140027
+twbs/bootstrap 126371
+torvalds/linux 121415
+jwasham/coding-interview-university 119797
+github/gitignore 119322
+donnemartin/system-design-primer 118394
+flutter/flutter 116303
+airbnb/javascript 115651
+jackfrued/Python-100-Days 108760
+robbyrussell/oh-my-zsh 107173
+facebook/react-native 105346
+TheAlgorithms/Python 102067
+vinta/awesome-python 98604
+Snailclimb/JavaGuide 97793
+vhf/free-programming-books 94137
+CyC2018/CS-Notes 93320
+golang/go 92407
+EbookFoundation/free-programming-books 92016
+trekhleb/javascript-algorithms 89512
+danistefanovic/build-your-own-x 89253
+jlevy/the-art-of-command-line 87750
+Microsoft/vscode 82043
+angular/angular 80602
+justjavac/free-programming-books-zh_CN 78460
+labuladong/fucking-algorithm 77568
+angular/angular.js 76251
+FortAwesome/Font-Awesome 75924
+nodejs/node 75477
+tensorflow/models 75206
+laravel/laravel 74136
+daneden/animate.css 74095
+mrdoob/three.js 72597
+M4cs/BabySploit 71572
+ant-design/ant-design 71552
+electron/electron 71394
+kubernetes/kubernetes 68644
+resume/resume.github.com 68423
+atom/atom 68396
+iluwatar/java-design-patterns 67831
+PanJiaChen/vue-element-admin 67625
+django/django 66415
+apple/swift 66350
+
diff --git a/regression-test/data/github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out b/regression-test/data/github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
new file mode 100644
index 0000000000..5bed4707fd
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.out
@@ -0,0 +1,10 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !whatIsTheBestDayOfTheWeekToCatchAStar --
+1 24102566
+2 36491986
+3 38094378
+4 37570733
+5 37208005
+6 34924484
+7 23726322
+
diff --git a/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars1.out b/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars1.out
new file mode 100644
index 0000000000..662f06bbf5
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars1.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !whoAreAllThosePeopleGivingStars1 --
+4148 232492
+salifm 202534
+x0rzkov 73531
+fly51fly 57756
+PCOffline 56725
+baslr 50363
+gkze 49078
+StarTheWorld 45691
+thanhtoan1196 44715
+mcanthony 44331
+gauravssnl 43832
+ik5 42817
+jenniemanphonsy 41784
+madshansens 41045
+denji 40921
+jorgemachucav 39905
+korolr 39723
+esneko 39073
+5l1v3r1 38034
+roscopecoltran 35734
+tdusty46 34200
+JT5D 32595
+pranavlathigara 32068
+reduxionist 31377
+StarsEverywhere 31079
+nikolay 28975
+maoabc1818 28857
+gaoypChina 28767
+vulcangz 28602
+hcilab 28215
+CNXTEoE 28045
+tdusty47 27534
+lifa123 24146
+MihalczGabor 23416
+romanofficial 22976
+morristech 22269
+savage69kr 22178
+trietptm 22165
+the-cc-dev 22094
+Jackneill 21974
+hartca 21820
+jiangplus 21366
+topcloud 21343
+Jerzerak 21066
+mrluanma 20812
+pkt 20799
+wangpengwen 20754
+denisfitz57 20680
+mhaidarh 20418
+likaihere 19667
+
diff --git a/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars2.out b/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars2.out
new file mode 100644
index 0000000000..9d5e0ac30b
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars2.out
@@ -0,0 +1,4 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !whoAreAllThosePeopleGivingStars2 --
+alexey-milovidov 203
+
diff --git a/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars3.out b/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars3.out
new file mode 100644
index 0000000000..c655b07c51
--- /dev/null
+++ b/regression-test/data/github_events_p2/sql/whoAreAllThosePeopleGivingStars3.out
@@ -0,0 +1,53 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !whoAreAllThosePeopleGivingStars3 --
+koalaman/shellcheck 23579
+mxgmn/WaveFunctionCollapse 16007
+nothings/stb 15327
+Swordfish90/cool-retro-term 13619
+gabime/spdlog 10904
+kovidgoyal/kitty 10829
+lemire/simdjson 9541
+rsms/inter 8653
+yandex/ClickHouse 8629
+olivernn/lunr.js 7635
+llvm/llvm-project 7228
+mre/awesome-static-analysis 7126
+cube-js/cube.js 6783
+sharkdp/hyperfine 6685
+darlinghq/darling 6194
+google/oss-fuzz 6036
+catboost/catboost 6010
+chrissimpkins/codeface 5998
+jemalloc/jemalloc 5895
+mozilla/rr 5848
+hashicorp/packer 5740
+rqlite/rqlite 5390
+antirez/kilo 5372
+angr/angr 5013
+sysown/proxysql 4288
+unicorn-engine/unicorn 4175
+zmap/zmap 3821
+plausible/analytics 3614
+kahing/goofys 3351
+weidai11/cryptopp 2732
+jbeder/yaml-cpp 2539
+intel/hyperscan 2200
+jlfwong/speedscope 2177
+lief-project/LIEF 2131
+boyter/scc 1919
+simongog/sdsl-lite 1860
+yandex/odyssey 1833
+phracker/MacOSX-SDKs 1793
+apache/avro 1792
+zserge/awfice 1706
+randombit/botan 1677
+arrowtype/recursive 1613
+GoogleCloudPlatform/PerfKitBenchmarker 1565
+drh/lcc 1449
+uncrustify/uncrustify 1322
+orlp/pdqsort 1319
+google/highwayhash 1142
+centaurean/density 988
+google/boringssl 976
+woboq/woboq_codebrowser 916
+
diff --git a/regression-test/suites/github_events_p2/ddl/github_events.sql b/regression-test/suites/github_events_p2/ddl/github_events.sql
new file mode 100644
index 0000000000..b16f103dda
--- /dev/null
+++ b/regression-test/suites/github_events_p2/ddl/github_events.sql
@@ -0,0 +1,88 @@
+CREATE TABLE github_events
+(
+ repo_name STRING NOT NULL,
+ created_at DATETIME NOT NULL,
+ file_time DATETIME NOT NULL,
+ event_type VARCHAR(30) NOT NULL,
+ actor_login STRING NOT NULL,
+ updated_at DATETIME NOT NULL,
+ action VARCHAR(30) NOT NULL,
+ comment_id BIGINT NOT NULL,
+ body STRING NOT NULL,
+ path STRING NOT NULL,
+ position INT NOT NULL,
+ line INT NOT NULL,
+ ref STRING NOT NULL,
+ ref_type VARCHAR(10) NOT NULL,
+ creator_user_login STRING NOT NULL,
+ number INT NOT NULL,
+ title STRING NOT NULL,
+ labels STRING NOT NULL,
+ state VARCHAR(10) NOT NULL,
+ locked TINYINT NOT NULL,
+ assignee STRING NOT NULL,
+ assignees STRING NOT NULL,
+ comments INT NOT NULL,
+ author_association VARCHAR(20) NOT NULL,
+ closed_at DATETIME NOT NULL,
+ merged_at DATETIME NOT NULL,
+ merge_commit_sha STRING NOT NULL,
+ requested_reviewers STRING NOT NULL,
+ requested_teams STRING NOT NULL,
+ head_ref STRING NOT NULL,
+ head_sha STRING NOT NULL,
+ base_ref STRING NOT NULL,
+ base_sha STRING NOT NULL,
+ merged TINYINT NOT NULL,
+ mergeable TINYINT NOT NULL,
+ rebaseable TINYINT NOT NULL,
+ mergeable_state VARCHAR(10) NOT NULL,
+ merged_by STRING NOT NULL,
+ review_comments INT NOT NULL,
+ maintainer_can_modify TINYINT NOT NULL,
+ commits INT NOT NULL,
+ additions INT NOT NULL,
+ deletions INT NOT NULL,
+ changed_files INT NOT NULL,
+ diff_hunk STRING NOT NULL,
+ original_position INT NOT NULL,
+ commit_id STRING NOT NULL,
+ original_commit_id STRING NOT NULL,
+ push_size INT NOT NULL,
+ push_distinct_size INT NOT NULL,
+ member_login STRING NOT NULL,
+ release_tag_name STRING NOT NULL,
+ release_name STRING NOT NULL,
+ review_state VARCHAR(20) NOT NULL
+)
+DUPLICATE KEY (repo_name, created_at)
+PARTITION BY LIST(event_type)
+(
+ PARTITION event_1 VALUES IN("CommitCommentEvent"),
+ PARTITION event_2 VALUES IN("CreateEvent"),
+ PARTITION event_3 VALUES IN("DeleteEvent"),
+ PARTITION event_4 VALUES IN("ForkEvent"),
+ PARTITION event_5 VALUES IN("GollumEvent"),
+ PARTITION event_6 VALUES IN("IssueCommentEvent"),
+ PARTITION event_7 VALUES IN("IssuesEvent"),
+ PARTITION event_8 VALUES IN("MemberEvent"),
+ PARTITION event_9 VALUES IN("PublicEvent"),
+ PARTITION event_10 VALUES IN("PullRequestEvent"),
+ PARTITION event_11 VALUES IN("PullRequestReviewCommentEvent"),
+ PARTITION event_12 VALUES IN("PushEvent"),
+ PARTITION event_13 VALUES IN("ReleaseEvent"),
+ PARTITION event_14 VALUES IN("SponsorshipEvent"),
+ PARTITION event_15 VALUES IN("WatchEvent"),
+ PARTITION event_16 VALUES IN("GistEvent"),
+ PARTITION event_17 VALUES IN("FollowEvent"),
+ PARTITION event_18 VALUES IN("DownloadEvent"),
+ PARTITION event_19 VALUES IN("PullRequestReviewEvent"),
+ PARTITION event_20 VALUES IN("ForkApplyEvent"),
+ PARTITION event_21 VALUES IN("Event"),
+ PARTITION event_22 VALUES IN("TeamAddEvent")
+)
+DISTRIBUTED BY HASH(repo_name) BUCKETS 16
+PROPERTIES
+(
+ "replication_num" = "1"
+)
diff --git a/regression-test/suites/github_events_p2/load.groovy b/regression-test/suites/github_events_p2/load.groovy
new file mode 100644
index 0000000000..5b24b06c50
--- /dev/null
+++ b/regression-test/suites/github_events_p2/load.groovy
@@ -0,0 +1,139 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+// The cases is copied from https://github.com/trinodb/trino/tree/master
+// /testing/trino-product-tests/src/main/resources/sql-tests/testcases/tpcds
+// and modified by Doris.
+
+
+/**
+ *
+ * Load data use restore. We should use it as long as it works.
+ *
+ */
+suite("load") {
+ restore {
+ location "s3://${getS3BucketName()}/regression_backup/clickhouse/github_events"
+ ak "${getS3AK()}"
+ sk "${getS3SK()}"
+ endpoint "http://${getS3Endpoint()}"
+ region "ap-beijing"
+ repository "regression_test_github_events"
+ snapshot "github_events"
+ timestamp "2022-03-23-12-19-51"
+ replicationNum 1
+ timeout 72000
+ }
+}
+/**
+ *
+ * load data use stream load. If we cannot load data from restore, we could fallback to this.
+ * Notion, it will run a few hours and maybe fail.
+ *
+ */
+// def tableName = "github_events"
+// def filePrefix = "github_events_v2_"
+// def fileSuffix = ".tsv.gz"
+// def delimiter = "_"
+// def starSplit = 0
+// def endSplit = 311
+// def splitNum = 311
+// def splitWide = 4
+// def subSplitWide = 2
+// def subSplitNumMap = [
+// 99 : 10,
+// 100 : 10,
+// 101 : 10,
+// 102 : 10,
+// 103 : 10,
+// 104 : 10,
+// 105 : 10,
+// 106 : 10,
+// 107 : 10,
+// 108 : 10,
+// 109 : 10,
+// 110 : 10,
+// 111 : 10,
+// 112 : 10,
+// 113 : 10,
+// 114 : 10,
+// 115 : 10,
+// 116 : 10,
+// 117 : 10,
+// 118 : 10,
+// 119 : 10,
+// 120 : 10,
+// 121 : 10,
+// 122 : 10,
+// 123 : 10,
+// 124 : 10,
+// 125 : 10
+// ]
+//
+// if (starSplit == 0) {
+// sql """ DROP TABLE IF EXISTS ${tableName} """
+// sql new File("""${context.file.parent}/ddl/${tableName}.sql""").text
+// }
+//
+// for (int i = starSplit; i <= Math.min(endSplit, splitNum); i++) {
+// int subSplitNum = subSplitNumMap.get(i, 1)
+// for (int j = 0; j < subSplitNum; j++) {
+//
+// // assemble file name, file format is :
+// // no subsplit: github_events_v2_${split_number_with_4_char_wide}.tsv.gz
+// // have subsplit: github_events_v2_${split_number_with_4_char_wide}_${sub_split_number_with_2_char_wide}.tsv.gz
+// def fileName = filePrefix + "${i}".padLeft(splitWide, '0')
+// if (subSplitNum != 1) {
+// fileName = fileName + delimiter + "${j}".padLeft(subSplitWide, '0')
+// }
+// fileName = fileName + fileSuffix;
+//
+// // generate label to do failover
+// def label = UUID.randomUUID().toString()
+//
+// // do stream load
+// streamLoadWithRetry {
+// table tableName
+// retryNum = 3
+// sleepMs = 2000
+//
+// set 'label', label
+// set 'column_separator', '\t'
+// set 'compress_type', 'GZ'
+// set 'columns', 'file_time, event_type, actor_login, repo_name, created_at, updated_at, action, comment_id, body, path, position, line, ref, ref_type, creator_user_login, number, title, labels, state, locked, assignee, assignees, comments, author_association, closed_at, merged_at, merge_commit_sha, requested_reviewers, requested_teams, head_ref, head_sha, base_ref, base_sha, merged, mergeable, rebaseable, mergeable_state, merged_by, review_comments, maintainer_can_modify, c [...]
+//
+// file """${context.config.s3Url}/regression/clickhouse/github_events/${fileName}"""
+//
+// time 0
+//
+// // stream load action will check result, include Success status, and NumberTotalRows == NumberLoadedRows
+//
+// // if declared a check callback, the default check condition will ignore.
+// // So you must check all condition
+// check { result, exception, startTime, endTime ->
+// if (exception != null) {
+// throw exception
+// }
+// log.info("Stream load result: ${result}".toString())
+// def json = parseJson(result)
+// assertEquals("success", json.Status.toLowerCase())
+// assertEquals(json.NumberTotalRows, json.NumberLoadedRows)
+// assertTrue(json.NumberLoadedRows > 0 && json.LoadBytes > 0)
+// }
+// }
+// }
+// }
diff --git a/regression-test/suites/github_events_p2/sql/affinityByIssuesAndPRs1.sql b/regression-test/suites/github_events_p2/sql/affinityByIssuesAndPRs1.sql
new file mode 100644
index 0000000000..27e932ec19
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/affinityByIssuesAndPRs1.sql
@@ -0,0 +1,14 @@
+SELECT
+ repo_name,
+ count() AS prs,
+ count(distinct actor_login) AS authors
+FROM github_events
+WHERE (event_type = 'PullRequestEvent') AND (action = 'opened') AND (actor_login IN
+(
+ SELECT actor_login
+ FROM github_events
+ WHERE (event_type = 'PullRequestEvent') AND (action = 'opened') AND (repo_name IN ('yandex/ClickHouse', 'ClickHouse/ClickHouse'))
+)) AND (lower(repo_name) NOT LIKE '%clickhouse%')
+GROUP BY repo_name
+ORDER BY authors DESC, prs DESC, length(repo_name) DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/affinityByIssuesAndPRs2.sql b/regression-test/suites/github_events_p2/sql/affinityByIssuesAndPRs2.sql
new file mode 100644
index 0000000000..2a44f8ba05
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/affinityByIssuesAndPRs2.sql
@@ -0,0 +1,14 @@
+SELECT
+ repo_name,
+ count() AS prs,
+ count(distinct actor_login) AS authors
+FROM github_events
+WHERE (event_type = 'IssuesEvent') AND (action = 'opened') AND (actor_login IN
+(
+ SELECT actor_login
+ FROM github_events
+ WHERE (event_type = 'IssuesEvent') AND (action = 'opened') AND (repo_name IN ('yandex/ClickHouse', 'ClickHouse/ClickHouse'))
+)) AND (lower(repo_name) NOT LIKE '%clickhouse%')
+GROUP BY repo_name
+ORDER BY authors DESC, prs DESC, repo_name ASC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/authorsWithTheMostPushes.sql b/regression-test/suites/github_events_p2/sql/authorsWithTheMostPushes.sql
new file mode 100644
index 0000000000..f9a2fa56e1
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/authorsWithTheMostPushes.sql
@@ -0,0 +1,9 @@
+-- SELECT
+-- actor_login,
+-- count() AS c,
+-- count(distinct repo_name) AS repos
+-- FROM github_events
+-- WHERE event_type = 'PushEvent'
+-- GROUP BY actor_login
+-- ORDER BY c DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/countingStar1.sql b/regression-test/suites/github_events_p2/sql/countingStar1.sql
new file mode 100644
index 0000000000..b5cc662a9c
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/countingStar1.sql
@@ -0,0 +1 @@
+SELECT count() FROM github_events WHERE event_type = 'WatchEvent'
diff --git a/regression-test/suites/github_events_p2/sql/countingStar2.sql b/regression-test/suites/github_events_p2/sql/countingStar2.sql
new file mode 100644
index 0000000000..e8366af1b7
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/countingStar2.sql
@@ -0,0 +1 @@
+SELECT action, count() FROM github_events WHERE event_type = 'WatchEvent' GROUP BY action
diff --git a/regression-test/suites/github_events_p2/sql/countingStar3.sql b/regression-test/suites/github_events_p2/sql/countingStar3.sql
new file mode 100644
index 0000000000..c789136973
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/countingStar3.sql
@@ -0,0 +1 @@
+SELECT count() FROM github_events WHERE event_type = 'WatchEvent' AND repo_name IN ('ClickHouse/ClickHouse', 'yandex/ClickHouse') GROUP BY action
diff --git a/regression-test/suites/github_events_p2/sql/distributionOfRepositoriesByStarCount.sql b/regression-test/suites/github_events_p2/sql/distributionOfRepositoriesByStarCount.sql
new file mode 100644
index 0000000000..89a33174a9
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/distributionOfRepositoriesByStarCount.sql
@@ -0,0 +1,14 @@
+SELECT
+ pow(10, floor(log10(c))) AS stars,
+ count(distinct k)
+FROM
+(
+ SELECT
+ repo_name AS k,
+ count() AS c
+ FROM github_events
+ WHERE event_type = 'WatchEvent'
+ GROUP BY k
+) t
+GROUP BY stars
+ORDER BY stars ASC
diff --git a/regression-test/suites/github_events_p2/sql/findingFriendsThroughCountingStars.sql b/regression-test/suites/github_events_p2/sql/findingFriendsThroughCountingStars.sql
new file mode 100644
index 0000000000..3e4a53b6b1
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/findingFriendsThroughCountingStars.sql
@@ -0,0 +1,31 @@
+SELECT
+ actor_login,
+ sum(my_repo) AS stars_my,
+ sum(not_my_repo) AS stars_other,
+ round(sum(my_repo) / (203 + sum(not_my_repo)), 3) AS ratio
+FROM
+(
+ SELECT
+ actor_login,
+ CASE WHEN my_repo_name IS NOT NULL THEN 1 ELSE 0 END AS my_repo,
+ CASE WHEN my_repo_name IS NOT NULL THEN 0 ELSE 1 END AS not_my_repo
+ FROM
+ (
+ SELECT
+ actor_login,
+ repo_name AS all_repo_name
+ FROM github_events
+ WHERE event_type = 'WatchEvent'
+ ) all_repos
+ FULL OUTER JOIN
+ (
+ SELECT repo_name AS my_repo_name
+ FROM github_events
+ WHERE (event_type = 'WatchEvent') AND (actor_login IN ('alexey-milovidov'))
+ GROUP BY my_repo_name
+ ) my_repos
+ ON all_repos.all_repo_name = my_repos.my_repo_name
+) t
+GROUP BY actor_login
+ORDER BY ratio DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/githubRoulette.sql b/regression-test/suites/github_events_p2/sql/githubRoulette.sql
new file mode 100644
index 0000000000..4acb4842c7
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/githubRoulette.sql
@@ -0,0 +1 @@
+SELECT repo_name FROM github_events WHERE event_type = 'WatchEvent' ORDER BY created_at LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
new file mode 100644
index 0000000000..00faf11503
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears1.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' AND year(created_at) = '2015' GROUP BY repo_name ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
new file mode 100644
index 0000000000..6974bc7338
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears2.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' AND year(created_at) = '2016' GROUP BY repo_name ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
new file mode 100644
index 0000000000..1e02973286
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears3.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' AND year(created_at) = '2017' GROUP BY repo_name ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
new file mode 100644
index 0000000000..4342d9fd4d
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears4.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' AND year(created_at) = '2018' GROUP BY repo_name ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
new file mode 100644
index 0000000000..aba8700c7c
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears5.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' AND year(created_at) = '2019' GROUP BY repo_name ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
new file mode 100644
index 0000000000..18710b3252
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears6.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' AND year(created_at) = '2020' GROUP BY repo_name ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
new file mode 100644
index 0000000000..54b6b9fc15
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheListOfTopRepositoriesChangedOverTheYears7.sql
@@ -0,0 +1,28 @@
+-- SELECT
+-- repo,
+-- year,
+-- cnt
+-- FROM
+-- (
+-- SELECT
+-- row_number() OVER (PARTITION BY year ORDER BY cnt DESC) AS r,
+-- repo,
+-- year,
+-- cnt
+-- FROM
+-- (
+-- SELECT
+-- lower(repo_name) AS repo,
+-- year(created_at) AS year,
+-- count() AS cnt
+-- FROM github_events
+-- WHERE (event_type = 'WatchEvent') AND (year(created_at) >= 2015)
+-- GROUP BY
+-- repo,
+-- year
+-- ) t
+-- ) t2
+-- WHERE r <= 10
+-- ORDER BY
+-- year ASC,
+-- cnt DESC
diff --git a/regression-test/suites/github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql b/regression-test/suites/github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
new file mode 100644
index 0000000000..5a6e3d5d3a
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/howHasTheTotalNumberOfStarsChangedOverTime.sql
@@ -0,0 +1 @@
+SELECT year(created_at) AS year, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' GROUP BY year ORDER BY year
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments1.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments1.sql
new file mode 100644
index 0000000000..0e092e7d81
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments1.sql
@@ -0,0 +1 @@
+SELECT count() FROM github_events WHERE event_type = 'IssueCommentEvent'
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments2.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments2.sql
new file mode 100644
index 0000000000..b5cb315efd
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments2.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() FROM github_events WHERE event_type = 'IssueCommentEvent' GROUP BY repo_name ORDER BY count() DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments3.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments3.sql
new file mode 100644
index 0000000000..225fe7d010
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments3.sql
@@ -0,0 +1,17 @@
+SELECT
+ repo_name,
+ comments,
+ issues,
+ round(comments / issues, 2) AS ratio
+FROM
+(
+ SELECT
+ repo_name,
+ count() AS comments,
+ count(distinct number) AS issues
+ FROM github_events
+ WHERE event_type = 'IssueCommentEvent'
+ GROUP BY repo_name
+) t
+ORDER BY comments DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments4.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments4.sql
new file mode 100644
index 0000000000..9072482b93
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments4.sql
@@ -0,0 +1,9 @@
+SELECT
+ repo_name,
+ number,
+ count() AS comments
+FROM github_events
+WHERE event_type = 'IssueCommentEvent' AND (action = 'created')
+GROUP BY repo_name, number
+ORDER BY comments DESC, number ASC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments5.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments5.sql
new file mode 100644
index 0000000000..fff6d9c369
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments5.sql
@@ -0,0 +1,9 @@
+SELECT
+ repo_name,
+ number,
+ count() AS comments
+FROM github_events
+WHERE event_type = 'IssueCommentEvent' AND (action = 'created') AND (number > 10)
+GROUP BY repo_name, number
+ORDER BY comments DESC, repo_name, number
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments6.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments6.sql
new file mode 100644
index 0000000000..2f7d1f2121
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments6.sql
@@ -0,0 +1,11 @@
+-- SELECT
+-- repo_name,
+-- number,
+-- count() AS comments,
+-- count(distinct actor_login) AS authors
+-- FROM github_events
+-- WHERE event_type = 'IssueCommentEvent' AND (action = 'created') AND (number > 10)
+-- GROUP BY repo_name, number
+-- HAVING authors >= 10
+-- ORDER BY comments DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments7.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments7.sql
new file mode 100644
index 0000000000..f7b2e2b933
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments7.sql
@@ -0,0 +1,9 @@
+SELECT
+ repo_name,
+ count() AS comments,
+ count(distinct actor_login) AS authors
+FROM github_events
+WHERE event_type = 'CommitCommentEvent'
+GROUP BY repo_name
+ORDER BY count() DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments8.sql b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments8.sql
new file mode 100644
index 0000000000..050e1b42e2
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/issuesWithTheMostComments8.sql
@@ -0,0 +1,12 @@
+SELECT
+ concat('https://github.com/', repo_name, '/commit/', commit_id) AS URL,
+ count() AS comments,
+ count(distinct actor_login) AS authors
+FROM github_events
+WHERE (event_type = 'CommitCommentEvent') AND commit_id != ""
+GROUP BY
+ repo_name,
+ commit_id
+HAVING authors >= 10
+ORDER BY count() DESC, URL, authors
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/mostForkedRepositories.sql b/regression-test/suites/github_events_p2/sql/mostForkedRepositories.sql
new file mode 100644
index 0000000000..b66c38caca
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/mostForkedRepositories.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS forks FROM github_events WHERE event_type = 'ForkEvent' GROUP BY repo_name ORDER BY forks DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/mostPopularCommentsOnGithub.sql b/regression-test/suites/github_events_p2/sql/mostPopularCommentsOnGithub.sql
new file mode 100644
index 0000000000..bf5b050641
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/mostPopularCommentsOnGithub.sql
@@ -0,0 +1 @@
+-- SELECT body, count() FROM github_events WHERE body != "" AND length(body) < 100 GROUP BY body ORDER BY count() DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/organizationsByTheNumberOfRepositories.sql b/regression-test/suites/github_events_p2/sql/organizationsByTheNumberOfRepositories.sql
new file mode 100644
index 0000000000..ff6e0000ca
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/organizationsByTheNumberOfRepositories.sql
@@ -0,0 +1,14 @@
+SELECT
+ lower(split_part(repo_name, '/', 1)) AS org,
+ count(distinct repo_name) AS repos
+FROM
+(
+ SELECT repo_name
+ FROM github_events
+ WHERE event_type = 'WatchEvent'
+ GROUP BY repo_name
+ HAVING count() >= 10
+) t
+GROUP BY org
+ORDER BY repos DESC, org ASC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/organizationsByTheNumberOfStars.sql b/regression-test/suites/github_events_p2/sql/organizationsByTheNumberOfStars.sql
new file mode 100644
index 0000000000..aef3c57322
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/organizationsByTheNumberOfStars.sql
@@ -0,0 +1,8 @@
+SELECT
+ lower(split_part(repo_name, '/', 1)) AS org,
+ count() AS stars
+FROM github_events
+WHERE event_type = 'WatchEvent'
+GROUP BY org
+ORDER BY stars DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/organizationsByTheSizeOfCommunity.sql b/regression-test/suites/github_events_p2/sql/organizationsByTheSizeOfCommunity.sql
new file mode 100644
index 0000000000..e3ac16081d
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/organizationsByTheSizeOfCommunity.sql
@@ -0,0 +1,23 @@
+-- SELECT
+-- lower(split_part(repo_name, '/', 1)) AS org,
+-- count(distinct actor_login) AS authors,
+-- count(distinct pr_author) AS pr_authors,
+-- count(distinct issue_author) AS issue_authors,
+-- count(distinct comment_author) AS comment_authors,
+-- count(distinct review_author) AS review_authors,
+-- count(distinct push_author) AS push_authors
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- actor_login,
+-- CASE WHEN event_type = 'PullRequestEvent' THEN actor_login ELSE NULL END pr_author,
+-- CASE WHEN event_type = 'IssuesEvent' THEN actor_login ELSE NULL END issue_author,
+-- CASE WHEN event_type = 'IssueCommentEvent' THEN actor_login ELSE NULL END comment_author,
+-- CASE WHEN event_type = 'PullRequestReviewCommentEvent' THEN actor_login ELSE NULL END review_author,
+-- CASE WHEN event_type = 'PushEvent' THEN actor_login ELSE NULL END push_author
+-- FROM github_events
+-- WHERE event_type IN ('PullRequestEvent', 'IssuesEvent', 'IssueCommentEvent', 'PullRequestReviewCommentEvent', 'PushEvent')
+-- ) t
+-- GROUP BY org
+-- ORDER BY authors DESC
diff --git a/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks1.sql b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks1.sql
new file mode 100644
index 0000000000..e7061c8d8b
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks1.sql
@@ -0,0 +1,17 @@
+SELECT
+ repo_name,
+ sum(fork) AS forks,
+ sum(star) AS stars,
+ round(sum(star) / sum(fork), 3) AS ratio
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'ForkEvent' THEN 1 ELSE 0 END AS fork,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+ FROM github_events
+ WHERE event_type IN ('ForkEvent', 'WatchEvent')
+) t
+GROUP BY repo_name
+ORDER BY forks DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
new file mode 100644
index 0000000000..6d446ebf0a
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks2.sql
@@ -0,0 +1,18 @@
+SELECT
+ repo_name,
+ sum(fork) AS forks,
+ sum(star) AS stars,
+ round(sum(star) / sum(fork), 3) AS ratio
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'ForkEvent' THEN 1 ELSE 0 END AS fork,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+ FROM github_events
+ WHERE event_type IN ('ForkEvent', 'WatchEvent')
+) t
+GROUP BY repo_name
+HAVING (stars > 100) AND (forks > 100)
+ORDER BY ratio DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks3.sql b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks3.sql
new file mode 100644
index 0000000000..a7b28c7afd
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks3.sql
@@ -0,0 +1,18 @@
+SELECT
+ repo_name,
+ sum(fork) AS forks,
+ sum(star) AS stars,
+ round(sum(fork) / sum(star), 2) AS ratio
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'ForkEvent' THEN 1 ELSE 0 END AS fork,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+ FROM github_events
+ WHERE event_type IN ('ForkEvent', 'WatchEvent')
+) t
+GROUP BY repo_name
+HAVING (stars > 100) AND (forks > 100)
+ORDER BY ratio DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks4.sql b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks4.sql
new file mode 100644
index 0000000000..21ae3cbbdb
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks4.sql
@@ -0,0 +1,13 @@
+SELECT
+ sum(fork) AS forks,
+ sum(star) AS stars,
+ round(sum(star) / sum(fork), 2) AS ratio
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'ForkEvent' THEN 1 ELSE 0 END AS fork,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+ FROM github_events
+ WHERE event_type IN ('ForkEvent', 'WatchEvent')
+) t
diff --git a/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks5.sql b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks5.sql
new file mode 100644
index 0000000000..fdc8ddd009
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/proportionsBetweenStarsAndForks5.sql
@@ -0,0 +1,21 @@
+SELECT
+ sum(forks) AS forks,
+ sum(stars) AS stars,
+ round(sum(stars) / sum(forks), 2) AS ratio
+FROM
+(
+ SELECT
+ sum(fork) AS forks,
+ sum(star) AS stars
+ FROM
+ (
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'ForkEvent' THEN 1 ELSE 0 END AS fork,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+ FROM github_events
+ WHERE event_type IN ('ForkEvent', 'WatchEvent')
+ ) t
+ GROUP BY repo_name
+ HAVING stars > 100
+) t2
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesByAmountOfModifiedCode.sql b/regression-test/suites/github_events_p2/sql/repositoriesByAmountOfModifiedCode.sql
new file mode 100644
index 0000000000..b9504aeef3
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesByAmountOfModifiedCode.sql
@@ -0,0 +1,12 @@
+SELECT
+ repo_name,
+ count() AS prs,
+ count(distinct actor_login) AS authors,
+ sum(additions) AS adds,
+ sum(deletions) AS dels
+FROM github_events
+WHERE (event_type = 'PullRequestEvent') AND (action = 'opened') AND (additions < 10000) AND (deletions < 10000)
+GROUP BY repo_name
+HAVING (adds / dels) < 10
+ORDER BY adds + dels DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesByTheNumberOfPushes.sql b/regression-test/suites/github_events_p2/sql/repositoriesByTheNumberOfPushes.sql
new file mode 100644
index 0000000000..ca3f0f6f34
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesByTheNumberOfPushes.sql
@@ -0,0 +1,17 @@
+SELECT
+ repo_name,
+ count() AS pushes,
+ count(distinct actor_login) AS authors
+FROM github_events
+WHERE (event_type = 'PushEvent') AND (repo_name IN
+(
+ SELECT repo_name
+ FROM github_events
+ WHERE event_type = 'WatchEvent'
+ GROUP BY repo_name
+ ORDER BY count() DESC
+ LIMIT 10000
+))
+GROUP BY repo_name
+ORDER BY count() DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithClickhouse_related_comments1.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithClickhouse_related_comments1.sql
new file mode 100644
index 0000000000..c75047be40
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithClickhouse_related_comments1.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() FROM github_events WHERE lower(body) LIKE '%clickhouse%' GROUP BY repo_name ORDER BY count() DESC, repo_name ASC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithClickhouse_related_comments2.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithClickhouse_related_comments2.sql
new file mode 100644
index 0000000000..b4aefc116a
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithClickhouse_related_comments2.sql
@@ -0,0 +1,17 @@
+SELECT
+ repo_name,
+ sum(num_star) AS num_stars,
+ sum(num_comment) AS num_comments
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS num_star,
+ CASE WHEN lower(body) LIKE '%clickhouse%' THEN 1 ELSE 0 END AS num_comment
+ FROM github_events
+ WHERE (lower(body) LIKE '%clickhouse%') OR (event_type = 'WatchEvent')
+) t
+GROUP BY repo_name
+HAVING num_comments > 0
+ORDER BY num_stars DESC,num_comments DESC,repo_name ASC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithDoris_related_comments1.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithDoris_related_comments1.sql
new file mode 100644
index 0000000000..086ea620c6
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithDoris_related_comments1.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() FROM github_events WHERE lower(body) LIKE '%doris%' GROUP BY repo_name ORDER BY count() DESC, repo_name ASC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithDoris_related_comments2.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithDoris_related_comments2.sql
new file mode 100644
index 0000000000..2a1c299bd0
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithDoris_related_comments2.sql
@@ -0,0 +1,17 @@
+SELECT
+ repo_name,
+ sum(num_star) AS num_stars,
+ sum(num_comment) AS num_comments
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS num_star,
+ CASE WHEN lower(body) LIKE '%doris%' THEN 1 ELSE 0 END AS num_comment
+ FROM github_events
+ WHERE (lower(body) LIKE '%doris%') OR (event_type = 'WatchEvent')
+) t
+GROUP BY repo_name
+HAVING num_comments > 0
+ORDER BY num_stars DESC,num_comments DESC,repo_name ASC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
new file mode 100644
index 0000000000..ccc2e30173
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheHighestGrowthYoY.sql
@@ -0,0 +1,20 @@
+SELECT
+ repo_name,
+ sum(created_at_2020) AS stars2020,
+ sum(created_at_2019) AS stars2019,
+ round(sum(created_at_2020) / sum(created_at_2019), 3) AS yoy,
+ min(created_at) AS first_seen
+FROM
+(
+ SELECT
+ repo_name,
+ CASE year(created_at) WHEN 2020 THEN 1 ELSE 0 END AS created_at_2020,
+ CASE year(created_at) WHEN 2019 THEN 1 ELSE 0 END AS created_at_2019,
+ created_at
+ FROM github_events
+ WHERE event_type = 'WatchEvent'
+) t
+GROUP BY repo_name
+HAVING (min(created_at) <= '2019-01-01 00:00:00') AND (stars2019 >= 1000)
+ORDER BY yoy DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
new file mode 100644
index 0000000000..9e3ebb3400
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues1.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS c, count(distinct actor_login) AS u FROM github_events WHERE event_type = 'IssuesEvent' AND action = 'opened' GROUP BY repo_name ORDER BY c DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
new file mode 100644
index 0000000000..3acf5de133
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues2.sql
@@ -0,0 +1,18 @@
+SELECT
+ repo_name,
+ sum(issue_created) AS c,
+ count(distinct actor_login) AS u,
+ sum(star) AS stars
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN (event_type = 'IssuesEvent') AND (action = 'opened') THEN 1 ELSE 0 END AS issue_created,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star,
+ CASE WHEN (event_type = 'IssuesEvent') AND (action = 'opened') THEN actor_login ELSE NULL END AS actor_login
+ FROM github_events
+ WHERE event_type IN ('IssuesEvent', 'WatchEvent')
+) t
+GROUP BY repo_name
+ORDER BY c DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
new file mode 100644
index 0000000000..075e8a3cba
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues3.sql
@@ -0,0 +1,19 @@
+SELECT
+ repo_name,
+ sum(issue_created) AS c,
+ count(distinct actor_login) AS u,
+ sum(star) AS stars
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN (event_type = 'IssuesEvent') AND (action = 'opened') THEN 1 ELSE 0 END AS issue_created,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star,
+ CASE WHEN (event_type = 'IssuesEvent') AND (action = 'opened') THEN actor_login ELSE NULL END AS actor_login
+ FROM github_events
+ WHERE event_type IN ('IssuesEvent', 'WatchEvent')
+) t
+GROUP BY repo_name
+HAVING stars >= 1000
+ORDER BY c DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
new file mode 100644
index 0000000000..a227b036d4
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfIssues4.sql
@@ -0,0 +1,18 @@
+SELECT
+ repo_name,
+ sum(issue_created) AS c,
+ count(distinct actor_login) AS u,
+ sum(star) AS stars
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN (event_type = 'IssuesEvent') AND (action = 'opened') THEN 1 ELSE 0 END AS issue_created,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star,
+ CASE WHEN (event_type = 'IssuesEvent') AND (action = 'opened') THEN actor_login ELSE NULL END AS actor_login
+ FROM github_events
+ WHERE event_type IN ('IssuesEvent', 'WatchEvent')
+) t
+GROUP BY repo_name
+ORDER BY u DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
new file mode 100644
index 0000000000..de6af89518
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests1.sql
@@ -0,0 +1 @@
+SELECT repo_name, count(), count(distinct actor_login) FROM github_events WHERE event_type = 'PullRequestEvent' AND action = 'opened' GROUP BY repo_name ORDER BY count() DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
new file mode 100644
index 0000000000..532388c7e8
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumAmountOfPullRequests2.sql
@@ -0,0 +1 @@
+SELECT repo_name, count(), count(distinct actor_login) AS u FROM github_events WHERE event_type = 'PullRequestEvent' AND action = 'opened' GROUP BY repo_name ORDER BY u DESC, 2 DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
new file mode 100644
index 0000000000..1497bd5fcf
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMaximumNumberOfAcceptedInvitations.sql
@@ -0,0 +1,17 @@
+SELECT
+ repo_name,
+ sum(invitation) AS invitations,
+ sum(star) AS stars
+FROM
+(
+ SELECT
+ repo_name,
+ CASE WHEN event_type = 'MemberEvent' THEN 1 ELSE 0 END AS invitation,
+ CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+ FROM github_events
+ WHERE event_type IN ('MemberEvent', 'WatchEvent')
+) t
+GROUP BY repo_name
+HAVING stars >= 100
+ORDER BY invitations DESC, stars DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
new file mode 100644
index 0000000000..c642ee6a23
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess1.sql
@@ -0,0 +1,13 @@
+-- SELECT
+-- repo_name,
+-- count(distinct actor_login) AS u,
+-- sum(star) AS stars
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- CASE WHEN event_type = 'PushEvent' THEN actor_login ELSE NULL END AS actor_login,
+-- CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+-- FROM github_events WHERE event_type IN ('PushEvent', 'WatchEvent') AND repo_name != '/'
+-- ) t
+-- GROUP BY repo_name ORDER BY u DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
new file mode 100644
index 0000000000..b0aaf29ac4
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess2.sql
@@ -0,0 +1,13 @@
+-- SELECT
+-- repo_name,
+-- count(distinct actor_login) AS u,
+-- sum(star) AS stars
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- CASE WHEN event_type = 'PushEvent' AND (ref LIKE '%/master' OR ref LIKE '%/main') THEN actor_login ELSE NULL END AS actor_login,
+-- CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+-- FROM github_events WHERE event_type IN ('PushEvent', 'WatchEvent') AND repo_name != '/'
+-- ) t
+-- GROUP BY repo_name ORDER BY u DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
new file mode 100644
index 0000000000..834f47d6b1
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostPeopleWhoHavePushAccess3.sql
@@ -0,0 +1,16 @@
+-- SELECT
+-- repo_name,
+-- count(distinct actor_login) AS u,
+-- sum(star) AS stars
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- CASE WHEN event_type = 'PushEvent' AND (ref LIKE '%/master' OR ref LIKE '%/main') THEN actor_login ELSE NULL END AS actor_login,
+-- CASE WHEN event_type = 'WatchEvent' THEN 1 ELSE 0 END AS star
+-- FROM github_events WHERE event_type IN ('PushEvent', 'WatchEvent') AND repo_name != '/'
+-- ) t
+-- GROUP BY repo_name
+-- HAVING stars >= 100
+-- ORDER BY u DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql
new file mode 100644
index 0000000000..a37cbbeb8e
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay1.sql
@@ -0,0 +1,25 @@
+-- SELECT
+-- repo_name,
+-- day,
+-- stars
+-- FROM
+-- (
+-- SELECT
+-- row_number() OVER (PARTITION BY repo_name ORDER BY stars DESC) AS rank,
+-- repo_name,
+-- day,
+-- stars
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- to_date(created_at) AS day,
+-- count() AS stars
+-- FROM github_events
+-- WHERE event_type = 'WatchEvent'
+-- GROUP BY repo_name, day
+-- ) t1
+-- ) t2
+-- WHERE rank = 1
+-- ORDER BY stars DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql
new file mode 100644
index 0000000000..a37cbbeb8e
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay2.sql
@@ -0,0 +1,25 @@
+-- SELECT
+-- repo_name,
+-- day,
+-- stars
+-- FROM
+-- (
+-- SELECT
+-- row_number() OVER (PARTITION BY repo_name ORDER BY stars DESC) AS rank,
+-- repo_name,
+-- day,
+-- stars
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- to_date(created_at) AS day,
+-- count() AS stars
+-- FROM github_events
+-- WHERE event_type = 'WatchEvent'
+-- GROUP BY repo_name, day
+-- ) t1
+-- ) t2
+-- WHERE rank = 1
+-- ORDER BY stars DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql
new file mode 100644
index 0000000000..da62f140ae
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostStarsOverOneDay3.sql
@@ -0,0 +1 @@
+-- SELECT repo_name, created_at, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' GROUP BY repo_name, created_at ORDER BY count() DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
new file mode 100644
index 0000000000..8cb242451b
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheMostSteadyGrowthOverTime.sql
@@ -0,0 +1,20 @@
+-- SELECT
+-- repo_name,
+-- max(stars) AS daily_stars,
+-- sum(stars) AS total_stars,
+-- sum(stars) / max(stars) AS rate
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- to_date(created_at) AS day,
+-- count() AS stars
+-- FROM github_events
+-- WHERE event_type = 'WatchEvent'
+-- GROUP BY
+-- repo_name,
+-- day
+-- ) t
+-- GROUP BY repo_name
+-- ORDER BY rate DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoriesWithTheWorstStagnation_order.sql b/regression-test/suites/github_events_p2/sql/repositoriesWithTheWorstStagnation_order.sql
new file mode 100644
index 0000000000..7d4f210917
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoriesWithTheWorstStagnation_order.sql
@@ -0,0 +1,20 @@
+SELECT
+ repo_name,
+ sum(created_at_2020) AS stars2020,
+ sum(created_at_2019) AS stars2019,
+ round(sum(created_at_2020) / sum(created_at_2019), 3) AS yoy,
+ min(created_at) AS first_seen
+FROM
+(
+ SELECT
+ repo_name,
+ CASE year(created_at) WHEN 2020 THEN 1 ELSE 0 END AS created_at_2020,
+ CASE year(created_at) WHEN 2019 THEN 1 ELSE 0 END AS created_at_2019,
+ created_at
+ FROM github_events
+ WHERE event_type = 'WatchEvent'
+) t
+GROUP BY repo_name
+HAVING (min(created_at) <= '2019-01-01 00:00:00') AND (max(created_at) >= '2020-06-01 00:00:00') AND (stars2019 >= 1000)
+ORDER BY yoy,repo_name
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoryAffinityList1.sql b/regression-test/suites/github_events_p2/sql/repositoryAffinityList1.sql
new file mode 100644
index 0000000000..c4f1257af4
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoryAffinityList1.sql
@@ -0,0 +1,13 @@
+SELECT
+ repo_name,
+ count() AS stars
+FROM github_events
+WHERE (event_type = 'WatchEvent') AND (actor_login IN
+(
+ SELECT actor_login
+ FROM github_events
+ WHERE (event_type = 'WatchEvent') AND (repo_name IN ('ClickHouse/ClickHouse', 'yandex/ClickHouse'))
+)) AND (repo_name NOT IN ('ClickHouse/ClickHouse', 'yandex/ClickHouse'))
+GROUP BY repo_name
+ORDER BY stars DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/repositoryAffinityList2.sql b/regression-test/suites/github_events_p2/sql/repositoryAffinityList2.sql
new file mode 100644
index 0000000000..ceae214a7c
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/repositoryAffinityList2.sql
@@ -0,0 +1,23 @@
+-- SELECT
+-- repo_name,
+-- total_stars,
+-- round(clickhouse_stars / total_stars, 2) AS ratio
+-- FROM
+-- (
+-- SELECT
+-- repo_name,
+-- count(distinct actor_login) AS total_stars
+-- FROM github_events
+-- WHERE (event_type = 'WatchEvent') AND (repo_name NOT IN ('ClickHouse/ClickHouse', 'yandex/ClickHouse'))
+-- GROUP BY repo_name
+-- HAVING total_stars >= 100
+-- ) t1
+-- JOIN
+-- (
+-- SELECT
+-- count(distinct actor_login) AS clickhouse_stars
+-- FROM github_events
+-- WHERE (event_type = 'WatchEvent') AND (repo_name IN ('ClickHouse/ClickHouse', 'yandex/ClickHouse'))
+-- ) t2
+-- ORDER BY ratio DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/starsFromHeavyGithubUsers1.sql b/regression-test/suites/github_events_p2/sql/starsFromHeavyGithubUsers1.sql
new file mode 100644
index 0000000000..882fc19808
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/starsFromHeavyGithubUsers1.sql
@@ -0,0 +1,13 @@
+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
diff --git a/regression-test/suites/github_events_p2/sql/starsFromHeavyGithubUsers2.sql b/regression-test/suites/github_events_p2/sql/starsFromHeavyGithubUsers2.sql
new file mode 100644
index 0000000000..c32507d5e7
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/starsFromHeavyGithubUsers2.sql
@@ -0,0 +1,15 @@
+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 actor_login
+ HAVING count() >= 10
+))
+GROUP BY repo_name
+ORDER BY count() DESC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/theLongestRepositoryNames1.sql b/regression-test/suites/github_events_p2/sql/theLongestRepositoryNames1.sql
new file mode 100644
index 0000000000..d48afb10cd
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theLongestRepositoryNames1.sql
@@ -0,0 +1 @@
+SELECT count(), repo_name FROM github_events WHERE event_type = 'WatchEvent' GROUP BY repo_name ORDER BY length(repo_name) DESC, repo_name LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/theLongestRepositoryNames2.sql b/regression-test/suites/github_events_p2/sql/theLongestRepositoryNames2.sql
new file mode 100644
index 0000000000..446b7fbce2
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theLongestRepositoryNames2.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() FROM github_events WHERE event_type = 'WatchEvent' AND repo_name LIKE '%_/_%' GROUP BY repo_name ORDER BY length(repo_name) ASC, repo_name LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/theMostToughCodeReviews.sql b/regression-test/suites/github_events_p2/sql/theMostToughCodeReviews.sql
new file mode 100644
index 0000000000..7f51c1f01b
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theMostToughCodeReviews.sql
@@ -0,0 +1,10 @@
+SELECT
+ concat('https://github.com/', repo_name, '/pull/', CAST(number AS STRING)) AS URL,
+ count(distinct actor_login) AS authors
+FROM github_events
+WHERE (event_type = 'PullRequestReviewCommentEvent') AND (action = 'created')
+GROUP BY
+ repo_name,
+ number
+ORDER BY authors DESC, URL ASC
+LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql b/regression-test/suites/github_events_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql
new file mode 100644
index 0000000000..1d3ee420e8
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theTotalNumberOfRepositoriesOnGithub.sql
@@ -0,0 +1 @@
+-- SELECT count(distinct repo_name) FROM github_events
diff --git a/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub1.sql b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub1.sql
new file mode 100644
index 0000000000..89efbbc869
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub1.sql
@@ -0,0 +1 @@
+SELECT count(distinct actor_login) FROM github_events
diff --git a/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub2.sql b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub2.sql
new file mode 100644
index 0000000000..8b67f9e92f
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub2.sql
@@ -0,0 +1 @@
+SELECT count(distinct actor_login) FROM github_events WHERE event_type = 'WatchEvent'
diff --git a/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub3.sql b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub3.sql
new file mode 100644
index 0000000000..90421b6b0c
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub3.sql
@@ -0,0 +1 @@
+SELECT count(distinct actor_login) FROM github_events WHERE event_type = 'PushEvent'
diff --git a/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub4.sql b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub4.sql
new file mode 100644
index 0000000000..1fb9df230a
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/theTotalNumberOfUsersOnGithub4.sql
@@ -0,0 +1 @@
+SELECT count(distinct actor_login) FROM github_events WHERE event_type = 'PullRequestEvent' AND action = 'opened'
diff --git a/regression-test/suites/github_events_p2/sql/topLabels1.sql b/regression-test/suites/github_events_p2/sql/topLabels1.sql
new file mode 100644
index 0000000000..c1274a9264
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/topLabels1.sql
@@ -0,0 +1,9 @@
+-- SELECT
+-- label,
+-- count() AS c
+-- FROM github_events
+-- LATERAL VIEW explode_split(labels, ',') t AS label
+-- WHERE (event_type IN ('IssuesEvent', 'PullRequestEvent', 'IssueCommentEvent')) AND (action IN ('created', 'opened', 'labeled'))
+-- GROUP BY label
+-- ORDER BY c DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/topLabels2.sql b/regression-test/suites/github_events_p2/sql/topLabels2.sql
new file mode 100644
index 0000000000..c1a7b39deb
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/topLabels2.sql
@@ -0,0 +1,9 @@
+-- SELECT
+-- label,
+-- count() AS c
+-- FROM github_events
+-- LATERAL VIEW explode_split(labels, ',') t AS label
+-- WHERE (event_type IN ('IssuesEvent', 'PullRequestEvent', 'IssueCommentEvent')) AND (action IN ('created', 'opened', 'labeled')) AND ((lower(label) LIKE '%bug%') OR (lower(label) LIKE '%feature%'))
+-- GROUP BY label
+-- ORDER BY c DESC
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/topLabels3.sql b/regression-test/suites/github_events_p2/sql/topLabels3.sql
new file mode 100644
index 0000000000..030bd91978
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/topLabels3.sql
@@ -0,0 +1,14 @@
+-- SELECT
+-- sum(bug) AS bugs,
+-- sum(feature) AS feature,
+-- sum(bug) / sum(feature) AS ratio
+-- FROM
+-- (
+-- SELECT
+-- CASE WHEN lower(label) LIKE '%bug%' THEN 1 ELSE 0 END AS bug,
+-- CASE WHEN lower(label) LIKE '%feature%' THEN 1 ELSE 0 END AS feature
+-- FROM github_events
+-- LATERAL VIEW explode_split(labels, ',') t AS label
+-- WHERE (event_type IN ('IssuesEvent', 'PullRequestEvent', 'IssueCommentEvent')) AND (action IN ('created', 'opened', 'labeled')) AND ((lower(label) LIKE '%bug%') OR (lower(label) LIKE '%feature%'))
+-- ) t
+-- LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/topRepositoriesByStars.sql b/regression-test/suites/github_events_p2/sql/topRepositoriesByStars.sql
new file mode 100644
index 0000000000..c1855d75b2
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/topRepositoriesByStars.sql
@@ -0,0 +1 @@
+SELECT repo_name, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' GROUP BY repo_name ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql b/regression-test/suites/github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
new file mode 100644
index 0000000000..0268597dc6
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/whatIsTheBestDayOfTheWeekToCatchAStar.sql
@@ -0,0 +1 @@
+SELECT dayofweek(created_at) AS day, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' GROUP BY day ORDER BY day
diff --git a/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars1.sql b/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars1.sql
new file mode 100644
index 0000000000..14f4a2f269
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars1.sql
@@ -0,0 +1 @@
+SELECT actor_login, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' GROUP BY actor_login ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars2.sql b/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars2.sql
new file mode 100644
index 0000000000..7ae2b57b3b
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars2.sql
@@ -0,0 +1 @@
+SELECT actor_login, count() AS stars FROM github_events WHERE event_type = 'WatchEvent' AND actor_login = 'alexey-milovidov' GROUP BY actor_login ORDER BY stars DESC LIMIT 50
diff --git a/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars3.sql b/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars3.sql
new file mode 100644
index 0000000000..a2aa102576
--- /dev/null
+++ b/regression-test/suites/github_events_p2/sql/whoAreAllThosePeopleGivingStars3.sql
@@ -0,0 +1,13 @@
+SELECT
+ repo_name,
+ count() AS stars
+FROM github_events
+WHERE (event_type = 'WatchEvent') AND (repo_name IN
+(
+ SELECT repo_name
+ FROM github_events
+ WHERE (event_type = 'WatchEvent') AND (actor_login = 'alexey-milovidov')
+))
+GROUP BY repo_name
+ORDER BY stars DESC
+LIMIT 50
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org