create a table x with two fields(id, content), inside test database, and insert 10 records
坚决拥护共产党
what's the best repo
show me the SQL to get current DAY of this MONTH
How many issues did I created in pingcap/tidb in last three months
Which companies contribute the most to Kubernetes?
How many repo were written by js
How many contributors in @pingcap/tidb
Top 10 developers from PingCAP who contributes most of PRs in the past year
how many repos are written in Python?
find the most popular repo from github_events
find how many developer come from US
latest commit TIME
get the total count of events
get the number of rows in event table
Top 10 developers from PingCAP who contributes most of PRs in the past year
give me sql to find how many repo were written by python
sql function to get current time
which repo has the most actor 
which pr in @pingcap/tidb has the most comments
what day is the day that @pingcap/tidb has the most commits
which repo has the most unmerged pr
what is the most popular language in the past year
which repo has the most open issues
what language is the most popular in repo @pingcap/tikv
I would like to know how many languages appear in pingcap/tidb and what they all are
Which user has given the most pr comments
Which repo has the most commits in the past year
who created the most pr in US
how many closed pr in pingcap/tidb in the past year
are there any repo that has more than 1000 commits in the past year
how many pr closed at christmas last year
who created more than 500 pr
show the top 10 contributors
get all repo id and name 
get all repo id and name and sort it
get all repo id and name and remove replication
get all repo names include 'golang'
find who commits in at least 2 repo
find who commits in at least 2 repo in the same day
how many commiter from US
get all repos that have active commits from 2014 to 2022
which repo has most issues
get all type
list 10 commiter that have more than 500 prs
list 10 commiter that have more than 500 prs , and order them by id
list all org
list all org and sort them by the frequency of using python
create table name test in database gharchive_dev, including one filed num 
how many repos are written in Python? please insert the result to the previous table
please drop table test 
get all collaborator that has more prs than owner
who contribute to tiDB and kubernetes as the same time
who contribute to tiDB and kubernetes as the same time, please use join not or
get current time in utc+8
list the pr amount of each month of 2020 , and sort it.
who create most prs in weekend, list 10 of them
Top languages in the open source world over the past four years
Geographic distribution of developer behavior
Ranking of back-end programming languages
Developer behavior distribution on weekdays and weekends
which actor only had actions in 2014
the company who has most number of developers
the repo which earned most stars in 2021
the most numebr of push per day for a developer
the most active developer in repo pingcap/tidb
list 5 pr has most comments
Distribution of the number of events in the first and second half of each month
how many actor only submit prs in golang
how many front-end developers in org pingcap
how many prs in pingcap/tidb have been reverted