++++++++++++++++++++++++++++ [0] Q: create a table x with two fields(id, content), inside test database, and insert 10 records A: use test; CREATE TABLE test.x (id INT, content VARCHAR(255)); INSERT INTO test.x (id, content) VALUES (1, 'record1'), (2, 'record2'), (3, 'record3'), (4, 'record4'), (5, 'record5'), (6, 'record6'), (7, 'record7'), (8, 'record8'), (9, 'record9'), (10, 'record10'); Q: How many issues did I created in pingcap/tidb in last three months A: No Database Guessed ++++++++++++++++++++++++++++ [5] Q: Which companies contribute the most to Kubernetes? A: No Database Guessed ++++++++++++++++++++++++++++ [6] Q: How many repo were written by js A: ++++++++++++++++++++++++++++ [7] Q: How many contributors in @pingcap/tidb A: No Database Guessed ++++++++++++++++++++++++++++ [8] Q: Top 10 developers from PingCAP who contributes most of PRs in the past year A: No Database Guessed ++++++++++++++++++++++++++++ [9] Q: how many repos are written in Python? A: No Database Guessed ++++++++++++++++++++++++++++ [10] Q: find the most popular repo from github_events A: No Database Guessed ++++++++++++++++++++++++++++ [11] Q: find how many developer come from US A: ++++++++++++++++++++++++++++ [12] Q: latest commit TIME A: ++++++++++++++++++++++++++++ [13] Q: get the total count of events A: No Database Guessed ++++++++++++++++++++++++++++ [14] Q: get the number of rows in event table A: No Database Guessed ++++++++++++++++++++++++++++ [15] Q: Top 10 developers from PingCAP who contributes most of PRs in the past year A: No Database Guessed ++++++++++++++++++++++++++++ [16] Q: give me sql to find how many repo were written by python A: ++++++++++++++++++++++++++++ [17] Q: sql function to get current time A: No Database Guessed ++++++++++++++++++++++++++++ [18] Q: which repo has the most actor A: No Database Guessed ++++++++++++++++++++++++++++ [19] Q: which pr in @pingcap/tidb has the most comments A: No Database Guessed ++++++++++++++++++++++++++++ [20] Q: what day is the day that @pingcap/tidb has the most commits A: No Database Guessed ++++++++++++++++++++++++++++ [21] Q: which repo has the most unmerged pr A: ++++++++++++++++++++++++++++ [22] Q: what is the most popular language in the past year A: ++++++++++++++++++++++++++++ [23] Q: which repo has the most open issues A: No Database Guessed ++++++++++++++++++++++++++++ [24] Q: what language is the most popular in repo @pingcap/tikv A: No Database Guessed ++++++++++++++++++++++++++++ [25] Q: I would like to know how many languages appear in pingcap/tidb and what they all are A: No Database Guessed ++++++++++++++++++++++++++++ [26] Q: Which user has given the most pr comments A: No Database Guessed ++++++++++++++++++++++++++++ [27] Q: Which repo has the most commits in the past year A: No Database Guessed ++++++++++++++++++++++++++++ [28] Q: who created the most pr in US A: ++++++++++++++++++++++++++++ [29] Q: how many closed pr in pingcap/tidb in the past year A: No Database Guessed ++++++++++++++++++++++++++++ [30] Q: are there any repo that has more than 1000 commits in the past year A: No Database Guessed ++++++++++++++++++++++++++++ [31] Q: how many pr closed at christmas last year A: ++++++++++++++++++++++++++++ [32] Q: who created more than 500 pr A: No Database Guessed ++++++++++++++++++++++++++++ [33] Q: show the top 10 contributors A: ++++++++++++++++++++++++++++ [34] Q: get all repo id and name A: ++++++++++++++++++++++++++++ [35] Q: get all repo id and name and sort it A: ++++++++++++++++++++++++++++ [36] Q: get all repo id and name and remove replication A: No Database Guessed ++++++++++++++++++++++++++++ [37] Q: get all repo names include 'golang' A: ++++++++++++++++++++++++++++ [38] Q: find who commits in at least 2 repo A: No Database Guessed ++++++++++++++++++++++++++++ [39] Q: find who commits in at least 2 repo in the same day A: No Database Guessed ++++++++++++++++++++++++++++ [40] Q: how many commiter from US A: No Database Guessed ++++++++++++++++++++++++++++ [41] Q: get all repos that have active commits from 2014 to 2022 A: ++++++++++++++++++++++++++++ [42] Q: which repo has most issues A: No Database Guessed ++++++++++++++++++++++++++++ [43] Q: get all type A: No Database Guessed ++++++++++++++++++++++++++++ [44] Q: list 10 commiter that have more than 500 prs A: No Database Guessed ++++++++++++++++++++++++++++ [45] Q: list 10 commiter that have more than 500 prs , and order them by id A: No Database Guessed ++++++++++++++++++++++++++++ [46] Q: list all org A: No Database Guessed ++++++++++++++++++++++++++++ [47] Q: list all org and sort them by the frequency of using python A: No Database Guessed ++++++++++++++++++++++++++++ [48] Q: create table name test in database gharchive_dev, including one filed num A: No Database Guessed ++++++++++++++++++++++++++++ [49] Q: how many repos are written in Python? please insert the result to the previous table A: ++++++++++++++++++++++++++++ [50] Q: please drop table test A: ++++++++++++++++++++++++++++ [51] Q: get all collaborator that has more prs than owner A: ++++++++++++++++++++++++++++ [52] Q: who contribute to tiDB and kubernetes as the same time A: No Database Guessed ++++++++++++++++++++++++++++ [53] Q: who contribute to tiDB and kubernetes as the same time, please use join not or A: No Database Guessed ++++++++++++++++++++++++++++ [54] Q: get current time in utc+8 A: No Database Guessed ++++++++++++++++++++++++++++ [55] Q: list the pr amount of each month of 2020 , and sort it. A: No Database Guessed ++++++++++++++++++++++++++++ [56] Q: who create most prs in weekend, list 10 of them A: No Database Guessed ++++++++++++++++++++++++++++ [57] Q: Top languages in the open source world over the past four years A: No Database Guessed ++++++++++++++++++++++++++++ [58] Q: Geographic distribution of developer behavior A: No Database Guessed ++++++++++++++++++++++++++++ [59] Q: Ranking of back-end programming languages A: ++++++++++++++++++++++++++++ [60] Q: Developer behavior distribution on weekdays and weekends A: No Database Guessed ++++++++++++++++++++++++++++ [61] Q: which actor only had actions in 2014 A: ++++++++++++++++++++++++++++ [62] Q: the company who has most number of developers A: ++++++++++++++++++++++++++++ [63] Q: the repo which earned most stars in 2021 A: No Database Guessed ++++++++++++++++++++++++++++ [64] Q: the most numebr of push per day for a developer A: No Database Guessed ++++++++++++++++++++++++++++ [65] Q: the most active developer in repo pingcap/tidb A: ++++++++++++++++++++++++++++ [66] Q: list 5 pr has most comments A: ++++++++++++++++++++++++++++ [67] Q: Distribution of the number of events in the first and second half of each month A: ++++++++++++++++++++++++++++ [68] Q: how many actor only submit prs in golang A: No Database Guessed ++++++++++++++++++++++++++++ [69] Q: how many front-end developers in org pingcap A: ++++++++++++++++++++++++++++ [70] Q: how many prs in pingcap/tidb have been reverted A: