[ { "database": "sample_data", "table": "", "sql": "", "col_names": null, "questions": [ "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 ", "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", "1. What is the average metascore of IMDB movie ratings between years 2012 and 2016?", "2. How many different sellers are there with sold car orders in the past two years? ", "3. What is the percentage of revenue change in global fortune 500 companies in 2020? ", "4. How many events occurred on Github in the month of November in 2018? ", "5. What was the highest ranked movie in IMDB movie ratings in 2018? ", "6. How much average selling price has increased for cars driven over 50,0000 km from 2019 till 2021? ", "7. What was the average rating from 10 for movies in 2015?", "8. What was the highest grossing movie in 2017 with atleast a rating of 8?", "9. Of the top 10 global fortune 500 companies in 2020, what is the average number of employees?", "10. Which is the most used language in Github events over the last 5 years?", "11. How many owner types were there for sold car orders in 2019?", "12. What is the average runtime in minutes of movies when they had metascore of 90 and above in 2016?", "13. What is the percentage of assets change in global fortune 500 companies in 2021?", "14. What is the total number of Github events created from 2017-2019?", "15. What is the percentage of profit change in global fortune 500 companies that have been in the top 5 in 2018?", "16. How many unique languages are there for Github events in the past year? ", "17. What is the average gross in millions for movies released in 2016 with a rating of at least 7?", "18. How many comment ids were there for Github events between December 2019 and March 2020?", "19. How many push sizes were there for Github events over the last 5 years?", "20. Of the top 10 global fortune 500 companies in 2021, what is the average asset value in millions? ", "21. What was the average rating from 10 for movies with a certificate of ‘G’ in 2020?", "22. How many distinct push sizes were there for push events on Github in 2020?", "23. What is the average km driven for cars sold in the past two years?", "24. How many unique organization logins are there for Github events since 2017? ", "25. What is the total number of employees in global fortune 500 companies from 2018 to 2021?", "26. What is the percentage of change in profit for global fortune 500 companies that have been in the top 10 in 2019?", "27. What is the average runtime for IMDB movie ratings between 2018 and 2020?", "28. How many car sellers are there for sold cars in the past two years with fuel type of 'petrol'?", "29. Which is the most popular movie genre based on IMDB movie ratings in 2021?", "30. What is the percentage of revenue change of global fortune 500 companies between 2018-2021?" ] } ]