[
  {
    "db_id": "app_store",
    "question": "What is the lowest sentiment polarity score of the Basketball Stars app for people who dislikes the app pretty much and how many downloads does it have?",
    "evidence": "lowest sentiment polarity score refers to MIN(Sentiment_Polarity); user dislike the app pretty much refers to Sentiment_Polarity<-0.5; number of downloads it has refers to installs;",
    "SQL": "SELECT MIN(T2.Sentiment_Polarity), T1.Installs FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Basketball Stars'"
  },
  {
    "db_id": "app_store",
    "question": "List the top 5 shopping apps with the most reviews.",
    "evidence": "shopping apps refers to Genre = 'Shopping'; most reviews refers to MAX(Reviews);",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Shopping' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage for free application with a rating 4.5 and above have not been updated since 2018?",
    "evidence": "paid refers to Type = 'Paid'; application refers to App; Rating>4.5; Last Updated>'2018; percentage = DIVIDE(SUM(Genres = 'Mature 17+' and Rating>4.5 and\u00a0substr(\"Last Updated\",-4,4)>'2018' )), (COUNT(App)) as percent;",
    "SQL": "SELECT CAST(SUM(CASE WHEN SUBSTR('Last Updated', -4) > '2018' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(App) PER FROM playstore WHERE Type = 'Free' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "How much is the size of Browser 4G and how many users have a pretty positive favorability on it?",
    "evidence": "Browser 4G is the App; pretty positive favorability refers to Sentiment_Polarity score = 0.5",
    "SQL": "SELECT T1.Size, COUNT(T1.App) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Browser 4G' AND T2.Sentiment_Polarity >= 0.5"
  },
  {
    "db_id": "app_store",
    "question": "List apps whose rating is 3.9 and state the translated review of each app.",
    "evidence": "lowest rating refers to Rating = 1;",
    "SQL": "SELECT T1.App, T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = 3.9"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of installments of the app with the highest total Sentiment polarity score?",
    "evidence": "installments refers to Installs; highest total sentiment polarity score = MAX(SUM(Sentiment_Polarity));",
    "SQL": "SELECT T1.Installs FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY SUM(T2.Sentiment_Polarity) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "How many negative comments are there in all the apps with 100,000,000+ installs?",
    "evidence": "negative comment refers to Sentiment = 'Negative'; Installs = '100,000,000+';",
    "SQL": "SELECT COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs = '100,000,000+' AND T2.Sentiment = 'Negative'"
  },
  {
    "db_id": "app_store",
    "question": "List down app that does not have negative sentiment and give their average rating?",
    "evidence": "doest not have negative sentiment refers to Sentiment! = 'Negative'; average = AVG(Sentiment_Polarity);",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment != 'Negative' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "List all free sports Apps and their translated review.",
    "evidence": "paid sports Apps refers to type = 'Paid' and Category = 'SPORTS';",
    "SQL": "SELECT T1.App, T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "How much is the average sentiment polarity score of Golf GPS Rangefinder: Golf Pad and what is it's rating in the Google Play Store?",
    "evidence": "average sentiment polarity score = AVG(Sentiment_Polarity); Golf GPS Rangefinder: Golf Pad\u00a0 is the App;",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Golf GPS Rangefinder: Golf Pad'"
  },
  {
    "db_id": "app_store",
    "question": "Name the top 10 most reviewed apps.",
    "evidence": "most reviewed app refers to MAX(Reviews);",
    "SQL": "SELECT DISTINCT App FROM playstore ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "For the Honkai Impact 3rd App, what is the highest sentiment polarity score and what genre does it belong to?",
    "evidence": "highest sentiment polarity score refers to MAX(Sentiment_Polarity);",
    "SQL": "SELECT MAX(T2.Sentiment_Polarity), T1.Genres FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Honkai Impact 3rd' AND T2.Sentiment_Polarity > 0.5 GROUP BY T1.Genres"
  },
  {
    "db_id": "app_store",
    "question": "What is the average download for entertainment apps with size no more than 1.0 M?",
    "evidence": "downloads and installs are synonyms; entertainment apps refers to Category = 'ENTERTAINMENT';",
    "SQL": "SELECT AVG(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Size < '1.0M'"
  },
  {
    "db_id": "app_store",
    "question": "Which 1,000,000,000+ intalls apps has the most no comment reviews?",
    "evidence": "no comment refers to Translated_Review = 'nan'; most no comment reviews = (MAX(COUNT(Translated_Review = 'nan')));",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs = '1,000,000+' AND T2.Translated_Review = 'nan' GROUP BY T1.App ORDER BY COUNT(T2.Translated_Review) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of games belonging in the arcade genre which has a content rating of Everyone 10+?",
    "evidence": "average price = AVG(Price);",
    "SQL": "SELECT AVG(Price) FROM playstore WHERE 'Content Rating' = 'Everyone 10+' AND Genres = 'Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the Cooking Fever app? Indicate the age group that the app is targeted at.",
    "evidence": "average sentiment polarity score = AVG(Sentiment_Polarity); age group the app is target at refers to Content Rating;",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity), T1.\"Content Rating\" FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Cooking Fever'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating and the total Sentiment subjectivity score of \"Onefootball - Soccer Scores\"?",
    "evidence": "Onefootball - Soccer Scores refers to App = 'Onefootball - Soccer Scores';",
    "SQL": "SELECT T1.Rating, SUM(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Onefootball - Soccer Scores'"
  },
  {
    "db_id": "app_store",
    "question": "Which Photography app has the highest total Sentiment subjectivity score?",
    "evidence": "Photography app refers to Genre = 'Photography'; highest total sentiment subjectivity score = MAX(sum(Sentiment_Subjectivity));",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Photography' GROUP BY T1.App ORDER BY SUM(T2.Sentiment_Subjectivity) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "List out genre that have downloads more than 1000000000.",
    "evidence": "downloads and installs are synonyms; Installs = '1,000,000,000+';",
    "SQL": "SELECT Genres FROM playstore WHERE Installs = '1,000,000,000+' GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "Indicate the number of installs and include the percentage of positive sentiments of FREEDOME VPN Unlimited anonymous Wifi Security.",
    "evidence": "FREEDOME VPN Unlimited anonymous Wifi Security is the App; percentage = MULTIPLY(DIVIDE((SUM(Sentiment = 'Positive')), (COUNT(*))), 100)",
    "SQL": "SELECT T1.Installs , CAST(SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) * 100 / SUM(CASE WHEN T2.Sentiment IS NOT NULL THEN 1.0 ELSE 0 END) AS REAL) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'FREEDOME VPN Unlimited anonymous Wifi Security'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average review number for application with 5 rating?",
    "evidence": "average review = AVG(Review); application refers to app; Rating = 5;",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Rating = 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have been reviewed more than 75 000 000 times and the content is suitable for teenagers?",
    "evidence": "Reviews>75000000; suitable for teenagers refers to Content Rating = 'Teen';",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Reviews > 75000000 AND `Content Rating` = 'Teen'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage ratio between positive sentiments and negative sentiments that are in Fate/Grand Order? Also indicate the current version.",
    "evidence": "Fate/Grand Order is the App; percentage ratio = MULTIPLY(DIVIDE((SUM(Sentiment = 'Positive')), (SUM(Sentiment = 'Negative'))), 100);",
    "SQL": "SELECT CAST(SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) AS REAL) * 100 / SUM(CASE WHEN T2.Sentiment = 'Negative' THEN 1 ELSE 0 END), T1.`Current Ver` FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Fate/Grand Order (English)' AND T1.`Current Ver` = '1.18.0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total Sentiment polarity score of the most expensive app?",
    "evidence": "total sentiment polarity score = sum(Sentiment_Polarity); most expensive app refers to MAX(Price);",
    "SQL": "SELECT SUM(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Price = ( SELECT MAX(Price) FROM playstore )"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have multiple genres and what is the total sentiment subjectivity of these apps?",
    "evidence": "multiple genres refers to COUNT(Genres>1; total sentiment subjectivity = Sum(Sentiment_Subjectivity);",
    "SQL": "SELECT SUM(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres > 1"
  },
  {
    "db_id": "app_store",
    "question": "For the Akinator app, how many reviews have sentiment subjectivity of no more than 0.5 and what is its current version?",
    "evidence": "Sentiment_Subjectivity<0.5; current version refers to Current Ver;",
    "SQL": "SELECT COUNT(T2.Sentiment_Subjectivity), T1.\"Current Ver\" FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Akinator' AND T2.Sentiment_Subjectivity < 0.5"
  },
  {
    "db_id": "app_store",
    "question": "Name the Apps with a sentiment objectivity of 0.3 and include their number of installs.",
    "evidence": "FALSE;",
    "SQL": "SELECT DISTINCT T1.App, T1.Installs FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity = 0.3"
  },
  {
    "db_id": "app_store",
    "question": "How many of the users hold neutral attitude on \"10 Best Foods for You\" app and what category is this app?",
    "evidence": "neutral attitude refers to Sentiment = 'Neutral';",
    "SQL": "SELECT COUNT(T2.App), T1.Category FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = '10 Best Foods for You' AND T2.Sentiment = 'Neutral'"
  },
  {
    "db_id": "app_store",
    "question": "What are the content ratings for the apps that have \"gr8\" in their comments?",
    "evidence": "app with gr8 in their comments refers to Translated_Review LIKE '%gr8%';",
    "SQL": "SELECT DISTINCT T1.`Content Rating` FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Translated_Review LIKE '%gr8%'"
  },
  {
    "db_id": "app_store",
    "question": "How many apps have rating of 5?",
    "evidence": "FALSE;",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5"
  }
]