[
  {
    "db_id": "app_store",
    "question": "What is the most popular app in the Education category with a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' AND Rating > 4.0 ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installs for the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, COUNT(App) AS Total_Installs FROM playstore WHERE Category = 'Casual' GROUP BY App ORDER BY Total_Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Casual' category with more than 5000 installs and a minimum rating of 4.2?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Casual' AND Installs != '5,000+' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installs and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "How many users have given a positive review for the App 'Todoist'?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Todoist' AND Sentiment = 'positive'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a 'FAMILY' type and at least 100,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'FAMILY' AND Reviews >= 100000"
  },
  {
    "db_id": "app_store",
    "question": "What are the 3 apps with the highest ratings in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Rating FROM playstore WHERE Category = 'Entertainment' GROUP BY App ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps in the category of 'GAME' having more than 10,000 downloads?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'GAME' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated app with the category as games in the Google play store?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'GAMES'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 100 000 000 installs and content rating suitable for 18+?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '100 000 000' AND `Content Rating` = '18+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest average sentiment polarity and their corresponding genres?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Genres, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App, T1.Genres ORDER BY AVG(T2.Sentiment_Polarity) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average sentiment polarity score in the Business category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T2.Sentiment_Polarity) AS Avg_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Business' GROUP BY T1.App ORDER BY Avg_Sentiment DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are categorized under both Sports and Action?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category IN ('Sports', 'Action')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '% > 100,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000,000 installs and have an average rating of 4.5 or above and which genre of apps do they belong to?",
    "evidence": "",
    "SQL": "SELECT T1.Genres FROM playstore AS T1 WHERE T1.Installs > '10000000' AND T1.Rating > 4.5 GROUP BY T1.Genres"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular game in the 'Strategy' category and how many installs it has?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type = 'Strategy' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps that are more than 100 MB in size?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Size LIKE '%MB'"
  },
  {
    "db_id": "app_store",
    "question": "What apps with a price greater than 5 dollars have a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price > 5 AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps that are not free?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Price != 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have the highest rating and belong to the category of 'Games'?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'Games' GROUP BY T1.App ORDER BY T1.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10 million installs in the action category and have a price of less than 10?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs > '10,000,000' AND Category = 'ACTION' AND Price < '10.00'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the apps in the \"Simulation\" category and their average rating in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Simulation' GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10 million installs and are categorized under 'Entertainment'?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%10M+' AND Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that have been updated in the last year and their corresponding average ratings?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE CAST(SUBSTR('Last Updated', -4, 4) AS INTEGER) >= strftime('%Y', 'now') - 1 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for all apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the applications with a size larger than 100MB?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Size LIKE '%>100MB%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installations for apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Installs AS INTEGER)) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 10 apps by number of downloads?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM (SELECT * FROM playstore ORDER BY Installs DESC LIMIT 10) AS T"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating from the Games category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'Games' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Photography apps with the highest total Sentiment subjectivity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Subjectivity) AS Total_Sentiment_Subjectivity 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 Total_Sentiment_Subjectivity DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Adventure category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total Sentiment polarity score of the apps with the highest rating?",
    "evidence": "",
    "SQL": "SELECT SUM(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = ( SELECT MAX(Rating) FROM playstore )"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of all shopping apps has more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT CAST(((SELECT COUNT(*) FROM playstore WHERE Genres = 'Shopping' AND Installs > '100000') * 100 / (SELECT COUNT(*) FROM playstore WHERE Genres = 'Shopping')) AS REAL)"
  },
  {
    "db_id": "app_store",
    "question": "What are the total installs of apps in the Photography category with 4.5+ rating and what are the translated reviews of it?",
    "evidence": "",
    "SQL": "SELECT SUM(T1.Installs), T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Photography' AND T1.Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a high total Sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App 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 10"
  },
  {
    "db_id": "app_store",
    "question": "What category does PUBG Mobile belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'PUBG Mobile'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have more than 1000 reviews and have a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Reviews > 1000 AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "Which app with more than 10 million installs has a sentiment polarity score above 0.5 and a category of 'Casual'? ",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '%10% million%' AND T1.Category = 'Casual' AND T2.Sentiment_Polarity > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Sports' category with the highest average sentiment polarity score and what are their ratings in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Sports' GROUP BY T1.App, T1.Rating ORDER BY AVG(T2.Sentiment_Polarity) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular Apps in the Sports category that have more than 1000 installs and less than 500MB size?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Sports' AND Installs > 1000 AND Size < '500MB'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 100 million downloads?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs = '100,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 highest-rated apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps that belong to both the Action and Strategy genres and have a rating above 4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Genres LIKE '%Action%' AND T1.Genres LIKE '%Strategy%' AND T1.Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of applications in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Puzzle category, ordered by the number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Puzzle' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that users highly dislike, sorted by their number of installs?",
    "evidence": "",
    "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 ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps with a rating above 4.5 have more than 10,000 reviews and are categorized under the Fitness category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Fitness' AND Rating > 4.5 AND Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1,000,000 installs in the 'Game' category, and their average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT P.App, AVG(P.Rating) AS Average_Rating FROM playstore AS P WHERE P.Category = 'Game' AND P.Installs LIKE '%,1,000,000%' GROUP BY P.App"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps have more positive reviews than negative reviews?",
    "evidence": "",
    "SQL": "SELECT CAST(((SELECT COUNT(*) Po FROM user_reviews WHERE Sentiment = 'Positive') - (SELECT COUNT(*) Ne FROM user_reviews WHERE Sentiment = 'Negative')) AS REAL) * 100 / (SELECT COUNT(*) FROM user_reviews)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have been installed more than 100 million times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '% 100 million%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Puzzle' category with more than 10000 installations?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Puzzle' AND Installs > '10000' ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most downloaded apps by their category?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(App) as totalInstalls FROM playstore GROUP BY Category ORDER BY totalInstalls DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which Travel app has more than 1,000,000 reviews and has an average rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE App IN (SELECT App FROM user_reviews WHERE Reviews > 1000000) AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the category 'Strategy' in Playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Strategy' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with at least 5,000,000 installs have a sentiment objectivity of more than 0.4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Subjectivity > 0.4 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) >= 5000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the puzzle game genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most frequently installed apps in 'Strategy' genre?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Strategy' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps from the Finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0.00' AND Category = 'Finance'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the free apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%M'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest rating in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT App, MAX(Rating) FROM playstore WHERE Category = 'Entertainment' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating for apps in the category 'Adventure'? List all of their reviews.",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps in each category?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 most rated apps in the category of 'Arcade' in the Playstore?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'Arcade' ORDER BY T1.Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the 'Puzzle' category that have more than 10 million installs and have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Puzzle' AND Installs > '10,000,000' AND Rating >= 4.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of applications in the Games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories and average ratings of apps that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE Installs LIKE '%10%million%' GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the action genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps in the 'Social' category that have been installed more than 1 million times?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Social' AND Installs LIKE '%M%' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which dating apps have an average review sentiment polarity score higher than 0.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T2.Sentiment_Polarity) AS Average_Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Dating' GROUP BY T1.App HAVING AVG(T2.Sentiment_Polarity) > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps in the puzzle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps in the Technology category that have a rating of 4.5 and above with more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'Technology' AND Rating >= 4.5 AND Installs > '1000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings for apps in the Puzzle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that have more than 100 million installs and average rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Price = 0 AND Installs LIKE '%100%+%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have been updated since 2020 and what is their category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Category FROM playstore WHERE Type = 'App' AND SUBSTR('Last Updated', -4) > '2020'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most highly rated apps in the games category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAMES' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Apps in the category 'COMPUTER'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMPUTER'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of apps with a rating of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT AVG(Price) FROM playstore WHERE Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the 'Adventure' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure' AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories in the playstore which have more positive sentiment than negative sentiment in their reviews?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.Category) AS Positive_Sentiment_Count, SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) AS Positive_Reviews, SUM(CASE WHEN T2.Sentiment = 'Negative' THEN 1 ELSE 0 END) AS Negative_Reviews, SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) - SUM(CASE WHEN T2.Sentiment = 'Negative' THEN 1 ELSE 0 END) AS Sentiment_Difference FROM playstore AS T1 LEFT JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.Category ORDER BY Sentiment_Difference DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with average rating of more than 4.5 stars?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App HAVING AVG(Rating) > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of 5-star ratings for the Photography app?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Rating = 5 AND Genres = 'Photography'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Casual' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore WHERE Category = 'Casual' GROUP BY App ORDER BY Avg_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Sports category with the most Positive comments?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Sports' AND T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY COUNT(T2.Sentiment) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the Puzzle game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps that have more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%>%1000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 installed applications by 'Action' type, with a minimum of 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Action' AND Installs LIKE '%,100000%' ORDER BY CAST(SUBSTR(Installs, 1, LENGTH(Installs) - LENGTH(REPLACE(Installs, ',', ''))) AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'Game' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the sports category with more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Sports' AND Installs = '50,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest number of installations in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Education' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most downloaded apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Entertainment' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of all apps with more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 500 MB size and are free?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Size > '500MB' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps with 4.5 star rating and how many of these apps have positive sentiment?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Size), COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = 4.5 AND T2.Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating among all apps in the Entertaiment category?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS average_rating FROM playstore AS T1 WHERE T1.Category = 'ENTERTAINMENT' GROUP BY T1.App ORDER BY average_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed apps in the 'Puzzle' genre with a minimum of 4-star rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.App) COUNTNUMBER FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' AND T1.Genres LIKE '%Puzzle%' GROUP BY T1.App ORDER BY T1.Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the total number of installs of all apps in the category of \"Games\"?",
    "evidence": "",
    "SQL": "SELECT SUM(CAST(SUBSTR(Installs, 1, LENGTH(Installs) - 2) AS INTEGER)) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the store has the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, MAX(Rating) FROM playstore GROUP BY App ORDER BY MAX(Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Education category with the most installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common genres in apps with 1,000,000,000+ downloads?",
    "evidence": "",
    "SQL": "SELECT Genres, COUNT(Genres) AS frequency FROM playstore WHERE Installs = '1,000,000,000+' GROUP BY Genres ORDER BY frequency DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps in the \"Entertainment\" category that are free and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'Entertainment' AND Type = 'Free' AND Installs LIKE '%+1%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 best selling apps that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Price, T1.Installs FROM playstore AS T1 ORDER BY T1.Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 games with the most installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type = 'Game' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What app in the 'Puzzle' genre has the highest average user rating?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Genres = 'Puzzle' GROUP BY T1.App ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the apps that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category FROM playstore AS T1 WHERE T1.Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Photography genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Photography'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have at least 10 million installs and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '10,000,000+' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "Which puzzle games have the most number of reviews with sentiment of negative?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, COUNT(T1.App) as ReviewCount FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Negative' GROUP BY T1.App ORDER BY ReviewCount DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most reviews that have an average rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.App) COUNTNUMBER, AVG(T1.Rating) FROM playstore AS T1 GROUP BY T1.App ORDER BY COUNT(T1.App) DESC, AVG(T1.Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10 million installs and have a rating more than 4.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%10M%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating of 4.5 or higher and at least 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating >= 4.5 AND Installs = '500,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of game apps that have more than 100,000 installs and are priced free?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Installs > '100,000' AND Price = 'Free' AND Type = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Strategy' genre that have an average rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore AS T1 WHERE T1.Genres = 'Strategy' AND T1.Rating > 4.5 ORDER BY T1.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have a price more than $5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Price > '5.0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of an app that has received a rating of 4.5 and more?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "Which photography app with more than 100000 installs has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Installs = '100,000+' AND T1.Genres = 'Photography' GROUP BY T1.App ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 100 installs and what is the total price range of these apps?",
    "evidence": "",
    "SQL": "SELECT SUM(Length(Price)) FROM playstore WHERE Installs > '100'"
  },
  {
    "db_id": "app_store",
    "question": "List all apps with a rating above 4.2 in the games category and their translated review.",
    "evidence": "",
    "SQL": "SELECT T1.App, T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'GAMES' AND T1.Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "List down the applications in the 'Finance' category that have more than 1 million installs and their average rating.",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Finance' AND Installs > '1,000,000' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the \"Puzzle\" category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have more than 100 000 000 installs and are suitable for mature audiences?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '100000000' AND `Content Rating` = 'Mature'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Sports category with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Sports' AND Installs LIKE '%10,000,000%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free sports apps in the 'Sports' category with a minimum rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Sports' AND Price = 0 AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Action category that have a size of more than 500MB?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Action' AND Size > '500MB' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of users who hold a positive sentiment on the app \"Paladins\"?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Paladins' AND Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have the highest average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have at least 1000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) >= 1000 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 100,000 installs and price is free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '100000' AND Price = 'FREE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Productivity' category that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Productivity' AND Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories for applications that have been updated in the last 6 months, ordered by the total installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, SUM(Installs) FROM playstore WHERE 'Last Updated' >= DATE('now', '-6 months') GROUP BY Category ORDER BY SUM(Installs) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for games in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle' AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are only available on both iOS and Android platforms?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type IN ('Free', 'Paid') AND (App LIKE '%iOS%' AND App LIKE '%Android%')"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 50 stars rating and the content is suitable for teenagers?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 50 AND `Content Rating` = 'Teen'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 entertainment apps with the highest average download and their corresponding ratings?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, AVG(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) AS Average_Installs FROM playstore AS T1 WHERE T1.Category = 'ENTERTAINMENT' GROUP BY T1.App, T1.Rating ORDER BY Average_Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps that belong to 'Action' and 'Adventure' genres and have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres LIKE '%Action%' OR Genres LIKE '%Adventure%' AND Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the Casual category have 10,000,000-50,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT 100*COUNT(*)/ (SELECT COUNT(*) FROM playstore WHERE Category = 'Casual' AND Installs BETWEEN '10,000,000' AND '50,000,000') FROM playstore WHERE Category = 'Casual' AND Installs BETWEEN '10,000,000' AND '50,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the free apps in the puzzle category, by their installs count?",
    "evidence": "",
    "SQL": "SELECT T1.Installs, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Price = 0 AND T1.Category = 'Puzzle' GROUP BY T1.Installs ORDER BY T1.Installs"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for games that have a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Game' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the apps in the Tools category with more than 5000 installations?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Installs > '5000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps in the 'Action' category by total Sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Polarity) AS Total_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'Action' GROUP BY T1.App ORDER BY Total_Sentiment DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category that have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps with a high sentiment polarity (>0.5) and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating > 4 AND T2.Sentiment_Polarity > 0.5 AND T1.Installs LIKE '%1,000,000%' GROUP BY T1.App ORDER BY AVG(T2.Sentiment_Polarity) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 1,000,000 installs and have an average rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs = '1,000,000+' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the \"Sports\" category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular category of apps with a price greater than 10 dollars?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) FROM playstore WHERE Price > '10' GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps for games?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore WHERE Type = 'Game' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs of 'Tetris' App across all its versions?",
    "evidence": "",
    "SQL": "SELECT SUM(CAST(T1.Installs AS INTEGER)) FROM playstore AS T1 WHERE T1.App = 'Tetris'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 100 million installs and are free to download?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%100,000,000+' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews that mention the word 'Android' for all apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE Translated_Review LIKE '%Android%' AND App IN (SELECT App FROM playstore WHERE Category = 'Puzzle')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that are free and have more than 1000000000 downloads, and what's the average sentiment polarity score of these apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '1,000,000,000+') GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most rated games apps with average rating greater than 4.3?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Game' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Sports' genre with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Sports' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "List all Apps from the 'Arcade' category and their rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 rated apps in the 'Simulation' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Simulation' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for free apps with ratings 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Type = 'Free' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 entertainment apps with the most reviews and a rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ENTERTAINMENT' AND Rating > 4.5 ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 1000 installs and less than 50 MB size?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1000' AND Size < '50MB'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of the apps in the Health category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Health'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 paid apps in the entertainment category with more than 5 million installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'ENTERTAINMENT' AND Type = 'Paid' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 5000000 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps having more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the count of Apps with installs more than 500,000?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%>500,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the puzzle category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Puzzle' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Simulation' category by the number of installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Simulation' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps having a price greater than $10 and what is the percentage ratio of negative sentiment reviews among these Apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating), CAST(COUNT(CASE WHEN Sentiment = 'Negative' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(Sentiment) FROM playstore INNER JOIN user_reviews ON playstore.App = user_reviews.App WHERE playstore.Price > '10'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps under the \"Action\" category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Adventure category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for the app with the highest total installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App IN (SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What are the number of reviews and average rating for 'PUBG Mobile' app?",
    "evidence": "",
    "SQL": "SELECT Reviews, AVG(Rating) AS Average_Rating FROM playstore WHERE App = 'PUBG Mobile'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most installs in the Games category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Games' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for the apps in the education category?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the Games category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of all apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps that have less than 10,000 installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs < '10,000' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories of apps that have at least 5,000 installs and their average ratings?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE Installs LIKE '%,000%' GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps in the 'Casual' category with a price of less than $5?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'Casual' AND Price < '5.00'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the apps that belong to the category 'Simulation' and have a rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Simulation' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the most common rating of apps in the COMICS category?",
    "evidence": "",
    "SQL": "SELECT T1.Rating, COUNT(*) AS Count FROM playstore AS T1 WHERE T1.Category = 'COMICS' GROUP BY T1.Rating ORDER BY Count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the shopping category have more than 1 000 000 installs and have a rating of at least 4.2?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Shopping' AND Installs > '1000000' AND Rating >= 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of users rate the app 'Netflix' as 'Excellent'?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN Sentiment = 'Excellent' THEN 1 ELSE 0 END) * 100 / (SELECT COUNT(*) FROM user_reviews WHERE App = 'Netflix') AS REAL) FROM user_reviews WHERE App = 'Netflix' AND Sentiment = 'Excellent'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Simulation' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Simulation%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score for all apps that have more than 100000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '%,100000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more positive sentiment reviews in the racing genre?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Racing' AND (SELECT COUNT(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE NULL END) - COUNT(CASE WHEN Sentiment = 'Negative' THEN 1 ELSE NULL END) FROM user_reviews WHERE App = T1.App) > 0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating and total installs of apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating), SUM(Installs) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest number of downloads in the Sports category?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'Sports' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of productivity apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Installs LIKE '%1,000,000%' AND T1.Type = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) FROM playstore WHERE Category = 'Education' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps are free and have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Action category with more than 1 million installs and less than 50 MB in size?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Action' AND Installs > '1,000,000' AND Size < '50 MB'"
  },
  {
    "db_id": "app_store",
    "question": "Which categories have more than 500 apps?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore GROUP BY Category HAVING COUNT(*) > 500"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the games category with average rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS AverageRating FROM playstore WHERE Category = 'Games' AND Rating > 4.5 GROUP BY App ORDER BY AverageRating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 largest app sizes?",
    "evidence": "",
    "SQL": "SELECT App, Size FROM playstore ORDER BY Size DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have been reviewed more than 5,000,000 times and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 5000000 AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the app Action Launcher? Please only consider apps with more than 1 million installs.",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1%000000%' AND App = 'Action Launcher'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular free applications in the education category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'Education' GROUP BY App ORDER BY COUNT(*) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have the best average rating and more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '1,000,000' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps in the playstore with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs = '1,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which non-gambling apps have more than 10 million installs and an average rating of more than 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%M' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with highest rated entertainment apps that cost more than $10.00?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'ENTERTAINMENT' AND T1.Price > '10.00' ORDER BY T1.Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of 4.5 stars or higher and have been installed at least 10 million times?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the most number of apps with a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) AS count FROM playstore WHERE Rating = 4.5 GROUP BY Category ORDER BY count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of 5-star rated apps that are free to download and has more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating = '5' AND Price = 'Free' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000000"
  },
  {
    "db_id": "app_store",
    "question": "What apps belong to the 'Education' category and have an average rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' GROUP BY App HAVING AVG(Rating) > 4"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app 'Toon Blast' belong to and what is the average rating for this app?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE App = 'Toon Blast'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the Casual category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'Casual' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What categories does the Akinator app belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Akinator'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest user reviews in the education category?",
    "evidence": "",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Category = 'EDUCATION' ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps from the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the top-rated app under the education category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%M+'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a review sentiment polarity of 0.5 and at least 100 reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment_Polarity = 0.5 GROUP BY App HAVING COUNT(App) >= 100"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps from the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(SUBSTR(Installs, INSTR(Installs, ' installations') - 10, 10) AS INTEGER)) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all games with a size of more than 100MB in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' AND Size > '100MB'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps by average sentiment subjectivity in the Photography category?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Subjectivity) AS average_sentiment_subjectivity 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 average_sentiment_subjectivity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the category of 'Action' have a rating above 4?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(*) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore WHERE Category = 'Action' AND Rating > 4) FROM playstore WHERE Category = 'Action' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the entertainment apps with rating more than 4.0 and less than 5.0 and have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'ENTERTAINMENT' AND Rating > 4.0 AND Rating < 5.0 AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game' AND Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10,000 installs and are in the education category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%10,000%' AND Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have more than 10,000 installs and a high rating (>4.5) and have reviews which are generally pretty positive with sentiment polarity more than 0.5?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs > '10000' AND T1.Rating > 4.5 AND T2.Sentiment_Polarity > 0.5 GROUP BY T1.App ORDER BY AVG(T2.Sentiment_Polarity) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by average rating in the 'game' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'game' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by number of installs in the education category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Education' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have average rating greater than 4.5 and how many installs they have?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the Apps that belong to the 'Puzzle' genre and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Puzzle' AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Games' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular Photography app in terms of installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs 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 T1.Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Social Networking category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'SOCIAL NETWORKING' GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of applications with rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the apps with the highest installation counts?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of Photography apps with a rating of 4.5 and above, and the total installs of these apps?",
    "evidence": "",
    "SQL": "SELECT COUNT(T1.App), SUM(T1.Installs) FROM playstore AS T1 WHERE T1.Genres = 'Photography' AND T1.Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average Sentiment polarity?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) AS Avg_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Avg_Sentiment DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "Which Apps in the 'Action' category have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Installs > '10 million'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest number of installs and what is its category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Category FROM playstore AS T1 ORDER BY T1.Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps are more than 50MB in size and suitable for all ages?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Size LIKE '%MB%' AND `Content Rating` = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the free apps with more than 50,000 installs and rated 4.5 or higher, and which category do they belong to?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Category FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Installs > '50,000' AND T1.Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of the game 'Subway Surfers' and what is its average rating?",
    "evidence": "",
    "SQL": "SELECT T1.Genres, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.App = 'Subway Surfers'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps from the sports category have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Installs LIKE '%1,000%' OR Installs LIKE '%1 000%' OR Installs LIKE '%1000%'"
  },
  {
    "db_id": "app_store",
    "question": "What app in the education category has the most number of installations and what is its average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category='EDUCATION' GROUP BY App ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installs in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Education' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the category 'Education'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 apps in the Arcade category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Arcade' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the categories of the apps that have at least 1000 installs and are available for free?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%1000%' AND Type LIKE '%Free%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Education' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories with the most installs for apps with a positive sentiment?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(*) as Installs FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' GROUP BY T1.Category ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installations for apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Facebook' in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Facebook' AND Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated applications in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'Education' GROUP BY T1.App ORDER BY T1.Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most downloaded apps in the Games category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Games' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 rated games apps?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='GAME' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the Casual category with a high rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Casual' AND Rating > 4.5 ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that users pretty liked and their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T2.Sentiment_Polarity > 0 GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the 'Puzzle' category have more than 1,000,000 installs, and are not rated 1-star or 2-star?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN T1.Rating > 2 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'Puzzle' AND T1.Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the games category that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Games' AND Installs LIKE '%,10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the ratio of apps with rating more than 4 in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(*) AS REAL) / (SELECT COUNT(*) FROM playstore WHERE Rating > 4) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the category 'Food & Drink' have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'Food & Drink' AND T1.Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the dating category with a minimum of 50,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Dating' ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular games in the action category with more than 10 million installations?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Type = 'Game' AND Category = 'Action' AND Installs LIKE '10%..%' ORDER BY Installs DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average review for apps in the 'GAME_ACTION' genre, with the average sentiment polarity score of their user reviews greater than 0.3?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Reviews) FROM playstore AS T1 WHERE T1.Genres = 'GAME_ACTION' AND (SELECT AVG(T2.Sentiment_Polarity) FROM user_reviews AS T2 WHERE T2.App = T1.App) > 0.3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest number of installs and what are the categories of these apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Category FROM playstore WHERE Installs IN ( SELECT Installs FROM playstore ORDER BY (SELECT COUNT(*) FROM user_reviews WHERE user_reviews.App = playstore.App) DESC LIMIT 3 )"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore WHERE Category = 'Strategy' GROUP BY App ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Tools' category and also have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Installs > '100,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the entertainment apps with more than 100000000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ENTERTAINMENT' AND Installs > '100,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Education category have been reviewed more than 50,000 times and are suitable for teenagers?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'EDUCATION' AND Reviews > 50000 AND `Content Rating` = 'Teen'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for games with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Photography category have a higher average rating than the overall average rating of all Photography apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore WHERE Category = 'Photography' GROUP BY App HAVING AVG(Rating) > (SELECT AVG(Rating) FROM playstore WHERE Category = 'Photography')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the puzzle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the top rated apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all reviewed apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for apps in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Reviews) FROM playstore AS T1 WHERE T1.Category = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "Which 10 apps have the highest average rating in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Action' GROUP BY T1.App ORDER BY AVG(T1.Rating) DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps that have at least 10,000 installs and have a positive sentiment, categorized under Entertainment?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%10,000%' AND Category = 'Entertainment' AND (SELECT COUNT(*) FROM user_reviews WHERE App = playstore.App AND Sentiment = 'Positive') > 0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the category of Action and how many apps are there in this category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the top-grossing Photography app in the Playstore?",
    "evidence": "",
    "SQL": "SELECT T1.App, MAX(T1.Price) AS Max_Price 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 Max_Price DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '10000'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the category of Productivity are rated with the highest average rating and have the most reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating, COUNT(*) AS Total_Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Productivity' GROUP BY T1.App ORDER BY Average_Rating DESC, Total_Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "List the top 3 highest rated Apps with more than 1 million installs, what is their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Installs LIKE '%1%000000%' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of apps with the largest number of installs in the action category?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Action' GROUP BY T1.App ORDER BY T1.Installs DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which paid apps have more than 10 000 000 installs and are suitable for all ages?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Price = 'Paid' AND Installs > '10000000' AND `Content Rating` = 'ALL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest number of installs that are rated 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Rating >= 4.5 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the action games category with at least 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'Action' AND T1.Installs > '100000' ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the most reviewed app in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as review_count FROM user_reviews GROUP BY App ORDER BY review_count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with highest average rating, and are there any apps that are not available in the United States?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating, 'Yes' AS Available_In_US FROM playstore WHERE Price = 0 GROUP BY App HAVING AVG(Rating) >= (SELECT AVG(Rating) FROM playstore WHERE Price = 0) ORDER BY Average_Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top three apps in the Education category with the most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'Education' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'ACTION' AND T1.Installs > '10000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Action' AND T1.Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of puzzle games by the user review on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type LIKE '%Puzzle%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 0"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps with a rating of at least 4.5 and price of less than $10",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Rating >= 4.5 AND CAST(SUBSTR(Size, 1, LENGTH(Size) - 1) AS REAL) < 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 installed apps in the Category 'Action'?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps among the games category? List out the names of the apps along with the number of reviews.",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Reviews FROM playstore AS T1 WHERE T1.Category = 'Game' ORDER BY T1.Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the apps in the 'Education' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Avg_Rating FROM playstore WHERE Genres = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the 'Health & Fitness' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, COUNT(*) as count FROM playstore WHERE Category = 'Health & Fitness' GROUP BY App ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1 million installs and what are their average ratings?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Installs LIKE '%1,000,000%' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the Entertainment category and their average rating score?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Price = 0 AND Category = 'Entertainment' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Entertainment category with the highest ratings?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Entertainment' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the sports category which have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sports' AND Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications in the adventure category that have received more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all gardening apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Gardening'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the apps with at least 1000 reviews in the productivity category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Productivity' AND Reviews >= 1000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the \"Simulation\" category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have been installed by more than 1 million users and have an average rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Rating, COUNT(Installs) AS Installs FROM playstore WHERE Installs LIKE '%M' GROUP BY App HAVING AVG(Rating) >= 4.5 ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which App in the 'Games' category has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Category = 'Games' GROUP BY T1.App ORDER BY Average_Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Strategy' genre that have more than 100,000 installs and a rating of 4.4 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Strategy' AND Installs LIKE '%,100,000%' AND Rating >= 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for dating applications in the 1-5 range?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Dating' AND Rating BETWEEN 1 AND 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most rated apps in the Action game genre?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore WHERE Type = 'Action' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the puzzle game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the category of 'Social' with most user reviews and what is the average sentiment of these reviews?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE Category = 'Social' ) GROUP BY App ORDER BY COUNT(*) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps categorized as Action?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the most applications that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore GROUP BY Category HAVING COUNT(*) > (SELECT COUNT(*) FROM playstore WHERE Installs > '10000') ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps with more than 1000000000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs = '1,000,000,000+' GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the highest average rating of the apps in it?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by rating in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Education' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment subjectivity score of apps in the sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Self-Improvement category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'Self-Improvement'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of no comment reviews are from apps with a high rating?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN T1.Rating > 4.5 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.App) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Translated_Review = 'nan'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of 'Education' category apps have less than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) / (SELECT COUNT(*) FROM playstore WHERE Category = 'EDUCATION' AND Installs < '100000') * 100 FROM playstore WHERE Category = 'EDUCATION' AND Installs < '100000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have the highest number of reviews from 18-24 age group in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Sentiment) as review_count FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Entertainment' AND T1.\"Content Rating\" = 'Teen' GROUP BY T1.App ORDER BY review_count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps with more than 1 million installs and their corresponding content rating?",
    "evidence": "",
    "SQL": "SELECT T1.Genres, T1.\"Content Rating\" FROM playstore AS T1 WHERE T1.Installs LIKE '%1 million%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest average rating for each genre?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Genres, AVG(Rating) AS avg_rating FROM playstore GROUP BY Genres ORDER BY avg_rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have a positive sentiment and more than 1 million reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Sentiment) AS ReviewCount FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY ReviewCount DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating and total Sentiment subjectivity score for the applications in the category Sports?",
    "evidence": "",
    "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.Category = 'Sports' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Action' category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of applications in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Price) FROM playstore WHERE Category = 'Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Health and Fitness category have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Health and Fitness' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories in the playstore with the highest rating average?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the apps that are free and do not have explicit content?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND 'Content Rating' NOT LIKE '%Explicit%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories in the playstore that have highest average rating among the apps in those categories?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, AVG(Rating) AS avg_rating FROM playstore GROUP BY Category ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories with the highest average rating in the 'Education' type?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore WHERE Type = 'Education' GROUP BY Category ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the Racing category?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Translated_Review) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Racing' GROUP BY T1.App ORDER BY COUNT(T2.Translated_Review) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "How many games in the 'Action' category have more than 100 000 000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Game' AND Category = 'Action' AND Installs > '100000000'"
  },
  {
    "db_id": "app_store",
    "question": "How many apps have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Installs LIKE '%+10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the applications in the gaming category with an average rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Gaming' AND Rating > 4.0 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with a rating of more than 4 stars have more than 100 reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4 AND Reviews > 100"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of applications in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the applications that have a rating of 4.5 and above with their respective genres?",
    "evidence": "",
    "SQL": "SELECT App, Genres FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the Utilities category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Utilities'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Food & Drink category have an average rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Food & Drink' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications by number of downloads in the games category?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'GAMES' GROUP BY T1.App ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the education category with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Installs LIKE '%,100,000%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of apps that are categorized as 'Photography' and have a rating higher than 4.5?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'Photography' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10 million installs and are not free?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%10% million%' AND Price != 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps with a minimum of 10,000 installs? Please list the genres along with the number of apps in each genre.",
    "evidence": "",
    "SQL": "SELECT Genres, COUNT(*) AS num_apps FROM playstore WHERE Installs LIKE '%10,000%' GROUP BY Genres ORDER BY num_apps DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most positive sentiment reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) AS Count FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that belong to the 'Productivity' category with 100,000+ installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Productivity' AND Installs LIKE '%,100,000%' OR Installs LIKE '100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the 'Food and Drink' category have a Sentiment polarity score greater than 0.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Food and Drink' AND T2.Sentiment_Polarity > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the action genre with less than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Action' AND Installs < '1000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average download for apps with rating above 4.5 and size more than 50MB in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) FROM playstore WHERE Category = 'GAMES' AND Rating > 4.5 AND Size > '50MB'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Communication' category with an average rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Communication' AND Rating > 4.5 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have at least 100,000,000+ installs and are in the Health & Fitness category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '100,000,000+' AND Category = 'HEALTH & FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the highest installs but less than 100MB in size and what are their installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Size LIKE '%<100MB%' ORDER BY CAST(SUBSTR(Size, INSTR(Size, 'GB')+3) AS INTEGER) DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which app has the highest number of installations across all categories?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, COUNT(Installs) AS Total_Installs FROM playstore GROUP BY App ORDER BY Total_Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most downloaded apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T1.Installs) AS Total_Installs FROM playstore AS T1 GROUP BY T1.App ORDER BY Total_Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of applications have more negative sentiment than positive sentiment?",
    "evidence": "",
    "SQL": "SELECT CAST((( SELECT COUNT(*) FROM user_reviews WHERE Sentiment = 'Negative') - ( SELECT COUNT(*) FROM user_reviews WHERE Sentiment = 'Positive')) AS REAL) * 100 / ( SELECT COUNT(*) FROM user_reviews )"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average sentiment polarity and what genres do they belong to?",
    "evidence": "",
    "SQL": "SELECT T1.Genres, AVG(T2.Sentiment_Polarity) AS average_sentiment_polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.Genres ORDER BY average_sentiment_polarity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the apps that have been reviewed with a sentiment of 'very positive'?",
    "evidence": "",
    "SQL": "SELECT T1.Category FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'very positive'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 50 million installs and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Installs LIKE '%M%' GROUP BY App HAVING AVG(Rating) > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the category of 'Tools'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with a minimum rating of 4.5 have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Rating >= 4.5 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000000"
  },
  {
    "db_id": "app_store",
    "question": "What apps have both free and paid versions, and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Type IN ('Free', 'Paid') GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the total number of apps that has a rating of 4.0 or higher?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the most positive sentiment from the Games genre and their average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T2.Sentiment_Polarity) AS Average_Sentiment_Polarity, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Games' AND T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY Average_Sentiment_Polarity DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the total installs of apps with a rating more than 4.5 and price more than 10.0?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Rating > 4.5 AND Price > 10.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings for the apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Google Play Store with highest number of installs, their categories and their prices?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Category, T1.Installs, T1.Price FROM playstore AS T1 ORDER BY T1.Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Music category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Music' AND Installs LIKE '%10,000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the top 3 apps in the 'Action' category that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Action' AND Installs LIKE '%100000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the category of Education with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Category = 'Education' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 1000000 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps that are of the 'Education' category and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Education' AND T1.Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the app with the most reviews?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.Category) AS Total_Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.Category ORDER BY Total_Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the 'action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'action' AND Type = 'game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps that have more than 1 million downloads?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of apps that have more than 1,000,000 installs and their average rating is greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%M+' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all apps with more than 10,000 installs and belonging to the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%%10,000%' AND Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most frequently reviewed apps?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) FROM user_reviews GROUP BY App ORDER BY COUNT(*) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Simulation' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Productivity category with the most installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Productivity' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of Apps in the 'ACTION' category in the Google Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the Games category that have more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games' AND Installs LIKE '%100,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What genre of apps are most popular in the top 10 apps with highest rating?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Rating IN (SELECT MAX(Rating) FROM playstore GROUP BY Genres) LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, COUNT(Reviews) FROM playstore GROUP BY App ORDER BY COUNT(Reviews) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "How many free apps that are greater than 1 year old are installed more than 10 million times?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'free' AND STRFTIME('%Y', 'now') - STRFTIME('%Y', Size) > 1 AND Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Health & Fitness category with the most downloads?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'HEALTH & FITNESS' GROUP BY App, Installs ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all apps that have 'Games' as their category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for apps in the 'Health & Fitness' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Health & Fitness'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Sports category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'Sports' ORDER BY CAST(T1.Installs AS REAL) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps are in the \"Casual\" category and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Casual' AND Installs LIKE '%M%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most common Category for the apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(*) FROM playstore AS T1 JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.Category HAVING COUNT(*) > 100000 ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps in the list of apps with the highest number of installations, also classified under the Action category, having a minimum of 10,000 reviews and an average rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Installs IS NOT NULL AND Reviews >= 10000 AND Rating >= 4.5 ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps categorized as 'Educational'?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'EDUCATIONAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10,000 installs and their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Installs LIKE '%10,000%' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the education category with the highest sentiment subjectivity and their total sentiment polarity?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Subjectivity) AS Total_Sentiment_Subjectivity, SUM(T2.Sentiment_Polarity) AS Total_Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Education' GROUP BY T1.App ORDER BY Total_Sentiment_Polarity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of games in the 'Action' genre with a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Genres = 'Action' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest total Sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Polarity) 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 5"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of reviews for 'AccuWeather - Weather Forecast' are positive?",
    "evidence": "",
    "SQL": "SELECT 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 = 'AccuWeather - Weather Forecast'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the gaming category with most reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Translated_Review) AS Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Gaming' GROUP BY T1.App ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000 installs and have 'Action' as their category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '10000' AND Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Action category with the highest average user ratings?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Action' GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Size) FROM playstore AS T1 WHERE T1.Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps that have a sentiment objectivity of 0.6 and are in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Subjectivity = 0.6 AND T1.Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "List all Apps that have more than 100 reviews and have a price greater than $0.99",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 100 AND Price > '0.99'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps that have been reviewed by a user having a positive sentiment?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of apps in the category of game?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Rating FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100 million%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the largest game app in the playstore?",
    "evidence": "",
    "SQL": "SELECT MAX(Size) FROM playstore WHERE Type='game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installations for all applications in the 'Role Playing' category?",
    "evidence": "",
    "SQL": "SELECT SUM(CAST(SUBSTR(Installs, 1, INSTR(Installs, ' Install') - 1) AS INTEGER)) FROM playstore WHERE Category = 'Role Playing'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore WHERE Category = 'SPORTS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the category Games and how many of them have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Avg_Rating, COUNT(*) AS Total_Apps FROM playstore WHERE Category = 'Games' AND Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have more than 10,000 installs and have a sentiment polarity score of more than 0?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '%,%' AND T2.Sentiment_Polarity > 0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories that have at least 50 apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, COUNT(App) as apps_count FROM playstore GROUP BY Category ORDER BY apps_count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the highest rated apps in the 'Social Media' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore AS T1 WHERE T1.Category = 'Social Media' ORDER BY T1.Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the application categorized as Productivity?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have a rating of 4.5 or higher and more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating >= 4.5 AND Installs > '100,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%,10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free applications in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Arcade category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps that are games and have more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Game' AND Installs LIKE '%10000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps in the 'Games' category with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'Games' AND T1.Installs > '10,000,000' ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for all applications in the 'Education' category that have a sentiment review greater than 0.5?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'Education' AND T1.Sentiment_Polarity > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 genres of apps in the top 100 highest-rated apps in the 'Adventure' category?",
    "evidence": "",
    "SQL": "SELECT T1.Genres, COUNT(T1.Genres) AS GenresCount FROM playstore AS T1 WHERE T1.Category = 'Adventure' AND T1.Rating IN (SELECT MAX(Rating) FROM playstore WHERE Category = 'Adventure' LIMIT 100) GROUP BY T1.Genres ORDER BY GenresCount DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the name and genre of the app that has the most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Genres FROM playstore AS T1 WHERE (T1.Installs = (SELECT MAX(Installs) FROM playstore))"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps in the Sports category with the most downloads?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Category = 'Sports' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps with the highest average rating in the Racing genre?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Genres = 'Racing' GROUP BY T1.App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Games category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore WHERE Category = 'Games' GROUP BY App ORDER BY Avg_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most installed apps in the education category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are only installed more than 1,000,000 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > 1000000"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10 million installs and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Installs = '10,000,000+' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest rating in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Education' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of apps with more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%100000000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 100,000,000 downloads?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '100,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Fitness' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Fitness' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "List the top 5 apps that have the highest number of installations in the 'GAME' category.",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'GAME' ORDER BY (SELECT COUNT(*) FROM user_reviews WHERE App = playstore.App) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "List out all apps in the 'Puzzle' category",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps from the 'Puzzle' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Puzzle' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have the most installs in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Casual' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that belong to the category of Puzzle games and have more than 10,000,000 downloads?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle' AND Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'Super Stylish Judge' in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Super Stylish Judge'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Puzzle' category with a size smaller than 100MB and an average rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Puzzle' AND Size != '100MB' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have been updated within the last 3 months and what kind of sentiment users hold on it?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Sentiment FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE CAST(SUBSTR('Last Updated', -7, 2) || ' ' || CAST(SUBSTR('Last Updated', 1, 2) AS INTEGER) AS INTEGER) > DATE('now', '-3 months') )"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps that are both in the game category and have a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Category = 'Game' AND Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a rating of 4.5 or higher and more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating >= 4.5 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre with the most 5-star reviews in the Photography category?",
    "evidence": "",
    "SQL": "SELECT T1.Genres FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Photography' AND T2.Sentiment = '5-star' GROUP BY T1.Genres ORDER BY COUNT(T2.Sentiment) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps with a high number of installs in the tools category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Category = 'Tools' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10 million installs and what are their content ratings?",
    "evidence": "",
    "SQL": "SELECT App, 'Content Rating' FROM playstore WHERE Installs LIKE '%M%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the category 'Entertainment' that have more than 1 000 000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 1000000 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC"
  },
  {
    "db_id": "app_store",
    "question": "How many games Apps have more than 100 reviews?",
    "evidence": "",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Reviews > 100 AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What app has the most reviews with a sentiment polarity score greater than 0.7 and belongs to the Action category?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Action' AND T2.Sentiment_Polarity > 0.7 GROUP BY T1.App ORDER BY COUNT(T2.Sentiment_Polarity) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of gaming apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Photography category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Photography'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most negative sentiments in the category of social media",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.App) AS COUNT FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Negative' AND T1.Category = 'Social Media' GROUP BY T1.App ORDER BY COUNT DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of apps that have 'Shopping' as a genre and average rating is more than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres = 'Shopping' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment score for applications with a price more than $1.99?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Price > '$1.99')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for games with a high rating (4.5 and above) in the Action genre?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Reviews) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating >= 4.5 AND T1.Genres = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Game category with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Game' AND Installs > '10 million'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installations for the Top Paid Apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Type = 'Paid' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated app in the 'Educational' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Educational' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are free and have a rating above 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 10 games from the games category with a price of free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore AS T1 WHERE T1.Category = 'Games' AND T1.Type = 'Free' ORDER BY T1.Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the apps in the Games category with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games' AND Installs LIKE '%100000%'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of racing apps have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(*) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore WHERE Genres = 'Racing' AND Installs LIKE '%10%') FROM playstore WHERE Genres = 'Racing' AND Installs LIKE '%10%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Fashion' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Fashion'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total Sentiment polarity score of all the apps in the education category?",
    "evidence": "",
    "SQL": "SELECT SUM(Sentiment_Polarity) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 10 million installs and are in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%M%' AND Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the education category and have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Education' AND T1.Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 100 million installs and are priced between 0 and 5 dollars?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100 million%' AND Price BETWEEN '0' AND '5'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Puzzle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 1 million installations in the Sports category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Sports' AND Installs LIKE '%1% million%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price for the apps in the entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Price) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps among the ones that have a rating of 4.5 or higher and average sentiment polarity score of 0.5 or higher, by the number of reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.Reviews) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating >= 4.5 AND T2.Sentiment_Polarity >= 0.5 GROUP BY T1.App ORDER BY COUNT(T1.Reviews) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "Which games have more than 10 million installs and have an average rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%10 million%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'News' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'News' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the different categories for apps with 1,000,000+ installs and their respective counts?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.App) FROM playstore AS T1 WHERE T1.Installs = '1,000,000+' GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest rating that are categorized as puzzle games?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'PUZZLE' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the Gaming category have been reviewed more than 5000000 times?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Gaming' AND Reviews > 5000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of apps in the Puzzle category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating higher than 4.5 and also have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.5 AND Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the 'Education' category in terms of number of installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Education' GROUP BY App ORDER BY COUNT(Installs) DESC"
  },
  {
    "db_id": "app_store",
    "question": "List down the categories of apps with more than 100,000 installs and their corresponding average ratings.",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Installs LIKE '%100,000%' GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the action genre with a rating of 4.5 or higher have at least 1,000 installs and what are the corresponding reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Action' AND T1.Rating >= 4.5 AND T1.Installs LIKE '%,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres that have apps with more than 1000000000 installs?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Installs > '1000000000' GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 entertainment apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of entertainment apps with more than 1,000,000 installs and a price less than 10 dollars?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Installs > '1,000,000' AND CAST(REPLACE(REPLACE(Price, ',', ''), '+', '') AS REAL) < 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most downloaded games and their categories?",
    "evidence": "",
    "SQL": "SELECT Playstore.App, Category FROM playstore JOIN (SELECT App, COUNT(*) AS Downloads FROM playstore GROUP BY App ORDER BY Downloads DESC LIMIT 3) AS TopDownloads ON playstore.App = TopDownloads.App WHERE Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that are related to Entertainment and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Installs LIKE '%1%000000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity for apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM user_reviews AS T2 INNER JOIN playstore AS T1 ON T2.App = T1.App WHERE T1.Genres = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What education apps have more than 1 million installs and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'EDUCATION' AND T1.Installs LIKE '%1%000%000' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the simulation category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS avg_rating FROM playstore GROUP BY Category ORDER BY avg_rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the most common sentiment held by users of the apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT Sentiment, COUNT(*) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'Games' GROUP BY Sentiment ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating that have a size greater than 50MB?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Size LIKE '%MB' AND Rating IN (SELECT DISTINCT Rating FROM playstore ORDER BY Rating DESC LIMIT 5)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 applications with more than 1 million installs and a positive sentiment review greater than 0.6?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1%000000' AND App IN ( SELECT App FROM user_reviews WHERE Sentiment = 'Positive' AND Sentiment_Polarity > 0.6 ORDER BY Sentiment_Polarity DESC LIMIT 3 )"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the 'Casual' category, ordered by the total number of reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Translated_Review) AS Total_Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Casual' GROUP BY T1.App ORDER BY Total_Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the category 'Puzzle'? ",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps under the category 'Action'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "Which Photography apps have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '1000000' AND Genres = 'Photography'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of apps with more than 1 million installs in the 'Social Media' category?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(*) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%M+' AND Category = 'Social Media')"
  },
  {
    "db_id": "app_store",
    "question": "What are the education apps with a rating of 4.5 and more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the Subway Surfers app and what type of game is it?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity), T1.Type FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Subway Surfers'"
  },
  {
    "db_id": "app_store",
    "question": "Which application in the puzzle game category has the most negative sentiments?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.App) COUNTNUMBER FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Puzzle' AND T2.Sentiment = 'Negative' GROUP BY T1.App ORDER BY COUNTNUMBER DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by install count in the weather category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Genres = 'Weather' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have less than 10,000 installs and an average rating of more than 4.5 and their translated reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs < '10000' AND T1.Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of all the apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of Applications in the category of Education?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps with more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.Installs) FROM playstore AS T1 WHERE T1.Installs LIKE '%1000%' GROUP BY T1.App ORDER BY COUNT(T1.Installs) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with more than 100 million installs have a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "Which puzzle games have more than 100,000 installs and are priced at $0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Puzzle' AND Installs LIKE '%,100000,' AND Price = '$0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Action' category with the most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Action' GROUP BY App ORDER BY CAST(Installs AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have more than 10 million installs and are not in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(*) AS Installs FROM playstore AS T1 WHERE T1.Installs LIKE '%M%' AND T1.Type != 'Game' GROUP BY T1.App ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000 installs and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000%' GROUP BY App HAVING COUNT(*) > 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the category \"Personalization\" have a rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Personalization' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score for all apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps in the 'Tools' category with a minimum of 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' AND Price = 0 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 1000000 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, AVG(Rating) AS average_rating FROM playstore GROUP BY Category ORDER BY average_rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps that have reviews mentioning 'battery life'?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Translated_Review) AS Count FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Translated_Review LIKE '%battery life%' GROUP BY T1.App ORDER BY Count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the social media category and what is their price?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, T1.Price FROM playstore AS T1 WHERE T1.Category = 'Social Media' ORDER BY T1.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 applications that have more than 10 million installs and are priced more than 10 USD?",
    "evidence": "",
    "SQL": "SELECT App, Installs, Price FROM playstore WHERE Installs > '10,000,000' AND CAST(SUBSTR(Price, INSTR(Price, '$')+1) AS REAL) > 10.0 GROUP BY App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps categorized as 'Social'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Photography category have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres = 'Photography' AND Installs LIKE '%,1000000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps that belong to the genre of Action?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Genres LIKE '%Action%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with highest rating in the Weather category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore WHERE Category = 'Weather' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have the highest rating and also have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > 4 AND Installs LIKE '%M%' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps in the Play Store that have more than 100,000 installs and are categorized as 'Entertainment'?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100,000%' AND Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the `Tools` category have a 4 or higher rating and more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Category = 'Tools' AND T1.Rating >= 4 AND T1.Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the top-rated Photography app that has more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Genres = 'Photography' AND T1.Installs LIKE '%1%000000%' ORDER BY T1.Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the top three most popular apps among users with a sentiment of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Sentiment) AS Count FROM playstore AS T1 LEFT JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity = 'Positive' AND T2.Sentiment_Polarity IS NOT NULL GROUP BY T1.App ORDER BY Count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for all apps in the action category with a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'Action' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed games?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Type = 'Game' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular games in the Puzzle genre with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Puzzle' AND Installs LIKE '%million%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of apps in the Comics category with more than 1000000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'COMICS' AND Installs > '1000000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Action genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Action%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of apps in the Health & Fitness category with more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Health & Fitness' AND T1.Installs > '1000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are category 'Puzzle'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of the reviews for the app 'WhatsApp Messenger'? How does this polarity compare to the overall Google Play Store rating of the app?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'WhatsApp Messenger' GROUP BY T1.App, T1.Rating"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of apps with highest average rating among apps with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE Installs > '10000' GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of positive reviews for the most popular app?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = (SELECT App FROM playstore WHERE Installs = (SELECT MAX(Installs) FROM playstore)) AND Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the top 3 Apps that have more than 10,000 installs and have a average rating of more than 4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '10,000' AND Rating > 4 ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps have at least 50,000,000 installs and an average rating of at least 4.0 out of 5.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > 50000000 AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1 million installs and their content rating?",
    "evidence": "",
    "SQL": "SELECT App, 'Content Rating' FROM playstore WHERE Installs LIKE '%1% M%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the game 'Candy Crush Saga'?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'Candy Crush Saga' AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for a paid application that belongs to the Strategy genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Type = 'Paid' AND Genres = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all puzzle games in the play store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) FROM playstore AS T1 GROUP BY T1.Category ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have the highest average rating and how many installations do they have?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) as Average_Rating, Installs FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular size of apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Size, COUNT(T1.App) AS count FROM playstore AS T1 GROUP BY T1.Size ORDER BY count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the puzzle genre that received the most reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.App) COUNTNUMBER FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres LIKE '%Puzzle%' GROUP BY T1.App ORDER BY COUNTNUMBER DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the applications with a size of more than 500 MB and installs more than 100 million?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Size LIKE '%MB' AND Installs LIKE '% million' AND CAST(SUBSTR(Size, 1, LENGTH(Size) - 2) AS REAL) > 500 AND CAST(SUBSTR(Installs, 1, LENGTH(Installs) - 8) AS INTEGER) > 100000000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have the most positive reviews and have a rating of 4.5 or higher?",
    "evidence": "",
    "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 = 'Positive' AND T1.Rating >= 4.5 GROUP BY T1.App ORDER BY AVG(T2.Sentiment_Polarity) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating of 4.5 or higher and belong to the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have been installed more than 100 million times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%>100 million%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the app with the highest number of installs in the 'Sports' category?",
    "evidence": "",
    "SQL": "SELECT Price FROM playstore WHERE Type = 'Sports' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the educational category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Educational' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps with 4 rating in the Sports category?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating = 4 AND Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the apps in the 'Books and Reference' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Books and Reference'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have both the rating of 4.5 and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.5 AND Installs LIKE '%1%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by total reviews?",
    "evidence": "",
    "SQL": "SELECT App, SUM(Reviews) AS total_reviews FROM playstore GROUP BY App ORDER BY total_reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a content rating of M and have less than 1GB in size?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE `Content Rating` = 'M' AND Size LIKE '<1GB'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for applications in the Adventure category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps with more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest number of installs in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Games' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with a content rating of Teen?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE \"Content Rating\" = 'Teen'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of apps in the playstore that are classified as 'Action'?",
    "evidence": "",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the games category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'Games' AND Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 50,000,000 installs and are categorized under 'TRAVEL' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%50,000,000+' AND Category = 'TRAVEL'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the action category have more than 1 million installations?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps that have more than 100000 installs and what is the total rating of these apps?",
    "evidence": "",
    "SQL": "SELECT COUNT(T1.App), SUM(T1.Rating) FROM playstore AS T1 WHERE T1.Installs > '100000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Games' category by the number of installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Genres = 'Games' ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all video games apps in the playstore that have received at least 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs >= '100,000' AND Type = 'Video Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps that are free to download?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average installs of games from the puzzle genre having more than 1 million reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Genres = 'Puzzle' AND Reviews > 1000000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest number of installs, excluding apps with less than 100 installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Installs > '100' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installs under the utility category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Utility' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that are also games?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the productivity category with more than 100000 installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Productivity' AND Installs > '100000' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have an average rating of 4 or more and have been installed by more than 1 million users?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4 AND Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have been reviewed the most in the sports category? ",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Count FROM user_reviews WHERE Translated_Review IS NOT NULL GROUP BY App ORDER BY Count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installations that have a price of free?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Price = 'Free' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the applications that have more than 10 million downloads and have a higher rating than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10%M%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the category 'Social'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps among the games and their average sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT Genres, AVG(Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE Type = 'Game' GROUP BY Genres ORDER BY AVG(Sentiment_Polarity) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS average_rating FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the total reviews of all Photography apps?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Genres = 'Photography'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'House & Home' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'House & Home'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of free puzzle games?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Price = 'Free' AND T1.Type = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for apps in the 'Strategy' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Genres LIKE '%Strategy%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a higher rating in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Game' AND Rating > (SELECT AVG(Rating) FROM playstore WHERE Category = 'Game')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of the apps in the 'Business' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Price AS REAL)) AS AVG_PRICE FROM playstore WHERE Genres = 'Business'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of games with ratings 4.5 and above that have less than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN Rating >= 4.5 AND Reviews < 1000 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(App) FROM playstore WHERE Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the adventure category with a rating less than 4.0 and more than 20,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ADVENTURE' AND Rating < 4.0 AND Installs LIKE '%20,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews with sentiment polarity as 0.5 for the app 'Game of War'?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Game of War' AND Sentiment_Polarity = '0.5'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the app Candy Crush Saga?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'Candy Crush Saga'"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of apps that belong to the action genre and have been installed more than 100 million times, along with their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Genres = 'Action' AND Installs LIKE '% > 100M' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the category with most number of reviews for all apps that have 4.9 and above average ratings?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(*) as Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating >= 4.9 GROUP BY T1.Category ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 1,000,000 installs and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Installs LIKE '%,%' GROUP BY App HAVING CAST(SUBSTRING(Installs, INSTR(Installs, ',') + 1) AS INTEGER) > 1000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the category of Casual?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'CASUAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "List the names of apps that have both a sports category and a free type and the average rating of those apps.",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS AVG_RATING FROM playstore AS T1 WHERE T1.Category = 'SPORTS' AND T1.Type = 'Free' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 10,000 installs and a content rating of MATURE?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '10000' AND 'Content Rating' = 'MATURE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 genres for a game having at least 100 installs?",
    "evidence": "",
    "SQL": "SELECT Genres, COUNT(*) AS InstallCount FROM playstore WHERE Installs LIKE '%100%' GROUP BY Genres ORDER BY InstallCount DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories that have the highest average rating for apps with installs more than 10,000,000?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore WHERE Installs > '10,000,000+' GROUP BY Category ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What category has the most free apps with a rating above 4?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.App) AS count FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Rating > 4 GROUP BY T1.Category ORDER BY count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most rated apps with average reviews over 4.5 in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Social' AND Rating > 4.5 GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of apps with a average rating of 4.5 and the number of installs more than 10 million?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Genres FROM playstore WHERE Rating = 4.5 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the category \"Action\"?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of education apps that are free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Education' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10,000 installs and a rating more than 4.5 out of 5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'Action' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest total installs amount of the apps in the category of 'Education'?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'Education' GROUP BY T1.App ORDER BY T1.Installs DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for games categorized under 'Adventure' in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Action category that have a rating higher than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of apps that are in the Productivity category and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Productivity' AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which categories have a rating of at least 4.5 and what is the sentiment of the users of those apps?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating >= 4.5 GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "Which apps that have been reviewed by both teenagers and adults have a higher rating among adults?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T2.Sentiment_Polarity) AS avg_sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.`Content Rating` IN ('Teen', 'Teen 17+') GROUP BY T1.App HAVING AVG(T2.Sentiment_Polarity) > (SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE `Content Rating` = 'Teen') ORDER BY avg_sentiment DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 1000000 installs and are free? List out then application name and its installs.",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs NOT LIKE '%-%' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 1000000 AND Price = 0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by total number of installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free applications that have more than 10 million installs and less than 500 MB in size?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%M+' AND Size LIKE '%<500 MB'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of 5-star rating applications that have received more positive sentiment than negative sentiment?",
    "evidence": "",
    "SQL": "SELECT COUNT(T1.App) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = 5.0 AND (SELECT COUNT(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE NULL END) - COUNT(CASE WHEN Sentiment = 'Negative' THEN 1 ELSE NULL END) FROM user_reviews WHERE App = T1.App) > 0"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most popular Photography app in the top 100 apps by installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Photography' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the 'Game' category have more than 100,000 installs and have a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Game' AND Installs LIKE '%100,000%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the Apps in the 'Action' Category that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' AND Installs LIKE '%1% million%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the Arcade category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the top 5 most downloaded games in the 'Action' category have a rating of 4.8 and more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Game' AND Category = 'Action' AND Rating >= 4.8 ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the top 5 that have the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM (SELECT App, Rating, ROW_NUMBER() OVER (ORDER BY Rating DESC) AS RowNum FROM playstore) WHERE RowNum <= 5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps that are in the 'Tools' category and have a price of less than $10?",
    "evidence": "",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Category = 'Tools' AND Price < '10.00'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most reviews and their average rating, for apps that have a category of 'GAME' and average rating is 4.2 or above?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.Rating) as reviews, AVG(T1.Rating) as average_rating FROM playstore AS T1 WHERE T1.Category = 'GAME' AND T1.Rating >= 4.2 GROUP BY T1.App ORDER BY reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the best selling apps in the Action category with a price range of $1-$5?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Price FROM playstore AS T1 WHERE T1.Category = 'Action' AND T1.Price >= '$1' AND T1.Price <= '$5' ORDER BY CAST(REPLACE(REPLACE(T1.Installs, ',', ''), '+', '') AS INTEGER) DESC"
  },
  {
    "db_id": "app_store",
    "question": "How many games with a rating of 4 or 5 are installed more than 1 million times?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type='Game' AND (Rating = 4 OR Rating = 5) AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the \"Action\" category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Photography category by their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Genres = 'Photography' GROUP BY T1.App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most installs under 100MB in size?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Size LIKE '%<100MB%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the \"ACTION\" category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the apps that are in the education category and have more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 100"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 1 million installs and a rating of more than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '1,000,000,000+' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of games apps that have received over 10000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Installs > 10000 AND Type = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the play store are free and have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 'Free' AND Installs LIKE '%%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of apps in the Casual game category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that have more than 1,000,000 installs and are priced more than $9.99?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1,000,000' AND Price > '9.99'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of application that belongs to the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Size AS REAL)) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of positive sentiment reviews for the Apps that belongs to Action genre?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Genres = 'Action' AND T1.Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 applications in the 'Game' category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'GAME' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps that have more than 100,000,000 installs and are in the Games category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs = '100,000,000+' AND Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the sport category with more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sport' AND Installs LIKE '%,10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 2 most reviewed apps and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 2"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that users really like this app and what are their categories?",
    "evidence": "",
    "SQL": "SELECT DISTINCT P.App, P.Category FROM playstore AS P INNER JOIN user_reviews AS U ON P.App = U.App WHERE U.Sentiment_Polarity > 0"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that are both puzzle and adventure games and have more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Puzzle' AND Type = 'Adventure' AND Installs LIKE '%,10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Sports' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "List all puzzle games that have a rating less than 4 and have more than 10,000 installs and 1000 reviews.",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating < 4 AND Installs LIKE '%10,000%' AND Reviews > 1000 AND Type = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed puzzle games and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS AVERAGE_RATING, COUNT(T1.Installs) AS INSTALL_COUNT FROM playstore AS T1 WHERE T1.Type = 'Puzzle' GROUP BY T1.App ORDER BY INSTALL_COUNT DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for the apps with a rating of 4 or more?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the category of Education that have been updated after 2019?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education' AND Type = 'Free' AND CAST(SUBSTR(\"Last Updated\", -4, 4) AS INTEGER) > 2019"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10 million installs and are in the Action category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > 10000000 AND Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed apps in the 'Simulation' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type = 'Simulation' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for applications in the 'Action' category that have a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'Action' AND T2.Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps with the highest average rating in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Price = 0 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of applications with a rating 4.5 and above that are larger than 50MB and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN Rating >= 4.5 AND Size > '50MB' AND Installs > '10000' 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": "What is the average rating of apps in the Adventure genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of positive sentiments for apps in the Social category having more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT 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 user_reviews AS T2 INNER JOIN playstore AS T1 ON T1.App = T2.App WHERE T1.Category = 'SOCIAL' AND T1.Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of games in the racing genre that have a rating of more than 4.5 and have more positive sentiment reviews than negative sentiment reviews?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN (SELECT COUNT(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE NULL END) - COUNT(CASE WHEN Sentiment = 'Negative' THEN 1 ELSE NULL END) FROM user_reviews GROUP BY App) > 0 AND T1.Rating > 4.5 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Game' AND T1.Genres = 'Racing'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top three apps in the Education category with the most installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.Installs) AS total_installs FROM playstore AS T1 WHERE T1.Category = 'Education' GROUP BY T1.App ORDER BY total_installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the Photography category has the highest average Sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) AS Average_Sentiment_Polarity 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 Average_Sentiment_Polarity DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of apps with the most number of installs in the 'Games' genre?",
    "evidence": "",
    "SQL": "SELECT Category, SUM(Installs) FROM playstore WHERE Type = 'Games' GROUP BY Category ORDER BY SUM(Installs) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of music apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Music'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps in the Puzzle game genre?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Installs) FROM playstore AS T1 WHERE T1.Genres = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Sports'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 100,000 installations and are rated more than 4 out of 5 stars?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%100000%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most positive sentiment?",
    "evidence": "",
    "SQL": "SELECT T1.App, T2.Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'positive' GROUP BY T1.App ORDER BY T2.Sentiment_Polarity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which app with more than 100 million installs has a highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100 million%' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are top-rated with more than 50 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > (SELECT AVG(Rating) FROM playstore) AND Installs LIKE '%50%0%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most common genre for applications with a 4.5 star rating and more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT Genres, COUNT(*) AS Frequency FROM playstore WHERE Rating = 4.5 AND Installs > '50,000' GROUP BY Genres ORDER BY Frequency DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have been installed by more than 1 million users?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the action category have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT CAST(((SELECT COUNT(*) FROM playstore WHERE Category = 'Action' AND Installs LIKE '%+1,000,000%') ) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore WHERE Category = 'Action')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average review number for applications with a price of $0.99?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Price = '$0.99'"
  },
  {
    "db_id": "app_store",
    "question": "What are the Apps with more than 100 million installs under the category 'Game' and their price?",
    "evidence": "",
    "SQL": "SELECT App, Price FROM playstore WHERE Category = 'Game' AND Installs > '100000000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories with the highest average rating among the free apps?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS avg_rating FROM playstore WHERE Type = 'Free' GROUP BY Category ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed apps that are not free?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Type != 'Free' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are in the 'Education' category and have a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed free weather apps?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Genres = 'Weather' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular applications with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 10,000 installs that have a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10,000' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of the apps in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for the apps in the 'Entertainment' category and above '4.5' rating?",
    "evidence": "",
    "SQL": "SELECT SUM(T1.Reviews) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Entertainment' AND T1.Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Simulation game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total rating of all apps in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT SUM(Rating) FROM playstore WHERE Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 best-rated apps with more positives sentiment than negative sentiment?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, COUNT(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE NULL END) - COUNT(CASE WHEN Sentiment = 'Negative' THEN 1 ELSE NULL END) AS Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity > 0 GROUP BY T1.App ORDER BY Sentiment_Polarity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated app that costs money and has more than 1 million downloads?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Price = 'paid' AND Installs LIKE '%M%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore WHERE Category = 'Food & Drink' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of games with a size of more than 100MB that are free?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN T1.Size LIKE '%MB%' AND T1.Type = 'free' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(DISTINCT T1.Size LIKE '%MB%') FROM playstore AS T1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the 'Social' category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'Social' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the photography category with a rating above 4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Photography' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that are having more negative sentiment than positive sentiment, and what is the percentage of this?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS total, (CAST(COUNT(*) AS REAL) * 100 / (SELECT COUNT(*) FROM user_reviews WHERE Sentiment = 'Positive')) AS percentage FROM user_reviews GROUP BY App ORDER BY percentage DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Productivity' category with a rating greater than or equal to 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Productivity' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Health & Fitness category have a size of more than 500MB and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Health & Fitness' AND Size LIKE '%MB%' AND CAST(Rating AS INTEGER) >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the apps that have more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of Apps with average rating greater than 4.5 and at least 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating > 4.5 AND Installs LIKE '%,100000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Simulation' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Education' GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Cooking category with the most installs?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Installs) FROM playstore WHERE Category = 'Cooking' GROUP BY App ORDER BY COUNT(Installs) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name and category of the app with the highest average sentiment polarity score for free applications?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Category, AVG(T2.Sentiment_Polarity) AS average_sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' GROUP BY T1.App, T1.Category ORDER BY average_sentiment DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the action category have an average sentiment polarity score above 0.5?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Action' AND T2.Sentiment_Polarity > 0.5 GROUP BY T1.App HAVING AVG(T2.Sentiment_Polarity) > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Arcade' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What category has the most apps with a price more than 9.99 dollars?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) FROM playstore WHERE Price > '9.99' GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with genre 'Action'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with rating of 4.5 have been installed more than 10 million times and what are the translated reviews of those apps?",
    "evidence": "",
    "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 = 4.5 AND T1.Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the category 'Education' have more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Installs LIKE '%>%1000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps which have more than 10 million installs and have a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '10,000,000+' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of apps that have been installed more than 10 million times?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%10 million%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installs in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' GROUP BY App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the most number of apps?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) as Total_Apps FROM playstore GROUP BY Category ORDER BY Total_Apps DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 genres of applications in the playstore that have an average rating of 4.5 and above, and are free?",
    "evidence": "",
    "SQL": "SELECT Genres, AVG(Rating) AS avg_rating FROM playstore WHERE Type = 'Free' AND Rating >= 4.5 GROUP BY Genres ORDER BY avg_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the 'Educational' genre and has more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Educational' AND Installs > '1000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average installs of gaming apps with a free price tag and a content rating of Everyone 10+",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Type = 'Gaming' AND Price = 'Free' AND 'Content Rating' = 'Everyone 10+'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating higher than 4 and what is the sentiment of users on these apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Sentiment FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Rating > 4)"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps in the playstore that have a rating above 4 and also have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating > 4 AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that belong to the Action genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Action%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the highest rating among music streaming apps with less than 50 MB size?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'MUSIC & AUDIO' AND Size < '50MB' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the average number of installs for games with a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Type = 'Game' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 largest apps in the 'Action' category that have more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT App, Size FROM playstore WHERE Category = 'Action' AND Installs LIKE '%100%' ORDER BY LENGTH(Size) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a rating of at least 4.5 that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of apps that have more than 1 million installs, and are priced above $5, sorted by rating in descending order?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, CAST(COUNT(*) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%1%') FROM playstore AS T1 WHERE T1.Installs LIKE '%1%' AND T1.Price > '5' GROUP BY T1.App, T1.Rating ORDER BY T1.Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10 million installs and are categorized as 'Education'?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%M%' AND Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps in the action genre with a minimum rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Rating >= 4.5 ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the 'GAME' category that have an average rating of 4.5+?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Price = 0 AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps with a sentiment ratio of positive sentiment above 90%?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND App IN (SELECT T1.App FROM user_reviews AS T1 GROUP BY T1.App HAVING SUM(CASE WHEN T1.Sentiment = 'Positive' THEN 1 ELSE 0 END) * 100.0 / COUNT(T1.Sentiment) > 90 ORDER BY COUNT(T1.Sentiment) DESC LIMIT 5)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the strategy category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "Which app has the most positive sentiment reviews among all the reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Sentiment) AS total_sentiment_reviews, SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) AS positive_sentiment_reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY positive_sentiment_reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Health and Fitness category that have more than 50000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness' AND Reviews > 50000"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the gaming category have at least 50,000 installs and average rating is 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Gaming' AND Installs != '' AND CAST(SIZE AS INTEGER) >= 50000 AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for education apps with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION' AND Installs > '10000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps in the Photography genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Photography'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Apps in the Photography genre based on the average user review rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Genres = 'Photography' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps under the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of 4.5 or more, and what is their category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Category FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories with the highest average rating? List down the names of the apps and their corresponding ratings under each category",
    "evidence": "",
    "SQL": "SELECT T1.Category, T1.App, T1.Rating FROM playstore AS T1 GROUP BY T1.Category ORDER BY AVG(T1.Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the applications in the 'Action' and 'Adventure' genres with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres LIKE '%Action%' OR Genres LIKE '%Adventure%' AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the games in the puzzle genre which have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Genres = 'Puzzle' AND Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a price more than $10 and are categorized under the Games category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Price > '10.0' AND Category = 'GAMES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating and total Sentiment subjectivity score of apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), SUM(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Sports' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most installs in the Gaming category?",
    "evidence": "",
    "SQL": "SELECT App, CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) AS Installs FROM playstore WHERE Category = 'GAMING' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What genre has the most neutral sentiment for the app named  \"Diary Story\"?",
    "evidence": "",
    "SQL": "SELECT Genres, COUNT(*) as sentiment_count FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Diary Story' AND T2.Sentiment = 'Neutral' GROUP BY Genres ORDER BY sentiment_count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10 million installs, average rating more than 4.5, and belong to the action genre?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10m%' AND Rating > 4.5 AND Genres = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all photography apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Photography' AND Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the puzzle category with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Puzzle' AND Installs > '10000000' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews from the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest number of installs and what are their corresponding categories?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Category, COUNT(T1.Installs) AS Installs FROM playstore AS T1 GROUP BY T1.App, T1.Category ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the 'Strategy' category have more positive reviews than negative reviews?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN ( SELECT COUNT(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE NULL END) - COUNT(CASE WHEN Sentiment = 'Negative' THEN 1 ELSE NULL END) FROM user_reviews GROUP BY App ) > 0 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the top 5 apps in the action category?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Category = 'Action' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of apps that have more than 1,000 installs and also have reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1000' AND Reviews > 0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Games' category and how many apps are there in that category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps that have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have a 'Shopping' genre and more than 5,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Shopping' AND Installs > '5,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps in the 'Action' category have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Category = 'Action' AND Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the puzzle category with more than 10000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle' AND Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Education' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have received the most reviews with sentiment as positive?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Translated_Review) AS Review_Count FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY Review_Count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that belong to the 'Action' category and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Installs LIKE '%1% million%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the Apps with a 'Photography' genre and more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres = 'Photography' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of applications with more than 10,000 installs and belonging to the game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '10000' AND Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the games category with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 10 million installs from the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs > '10,000,000' AND Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of users have reviewed the 'Google Maps' app as having a negative sentiment?",
    "evidence": "",
    "SQL": "SELECT (SELECT COUNT(*) FROM user_reviews WHERE App = 'Google Maps' AND Sentiment = 'Negative') * 100.0 / (SELECT COUNT(*) FROM user_reviews WHERE App = 'Google Maps')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps in the category of 'Sports'?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for games with at least 10000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAMES' AND Reviews >= 10000"
  },
  {
    "db_id": "app_store",
    "question": "What apps have at least 1,000,000 installs and have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%,000,000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Installs AS INTEGER)) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps in the Arcade category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of all apps in the Lifestyle category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Lifestyle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 genres that have the highest average rating?",
    "evidence": "",
    "SQL": "SELECT Genres, AVG(Rating) as Average_Rating FROM playstore GROUP BY Genres ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the productivity category with a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Productivity' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps that have been installed by at least 500 users?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,500%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the Games category and their corresponding genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Size), Genres FROM playstore WHERE Category = 'GAMES' GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have a rating of 4.5 and above, along with their average rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE Rating >= 4.5 GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of reviews for the application with the most reviews?",
    "evidence": "",
    "SQL": "SELECT COUNT(Reviews) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY COUNT(T2.Translated_Review) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 popular apps in the 'Action' genre?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres LIKE '%Action%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps are categorized under Education and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Installs LIKE '10% OR 10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps that have been reviewed more than 50 million times and have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Reviews > 50000000 AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of the top 3 most reviewed apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT T1.Genres, COUNT(T2.App) AS ReviewCount FROM playstore AS T1 LEFT JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.Genres ORDER BY ReviewCount DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore with a size less than 10 MB that have more than 50,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Size < '10 MB' AND Installs > '50000000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 10,000 installs and are categorized under the 'Educational' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Installs LIKE '%,10,000%' AND T1.Category = 'Educational'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the gaming category with more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Gaming' AND Installs > '1000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the action genre that have less than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Action' AND Installs < '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "Which applications with 5 star rating have more than 10 million downloads?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 5 AND Installs > '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Productivity category with the highest average sentiment?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) AS Average_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Productivity' GROUP BY T1.App ORDER BY Average_Sentiment DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the application with the highest amount of installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App IN (SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the category 'Casual'? List the top 5 and their ratings?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'Casual' ORDER BY T1.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the Apps with a sentiment polarity score of 0.8 and are rated 4.5 stars or higher?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity = 0.8 AND T1.Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of Photography apps installed on 1-10 million devices?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Size) FROM playstore AS T1 WHERE T1.Genres = 'Photography' AND T1.Installs LIKE '1-10%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for apps with 'Games' as their category?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "Which Apps from the Playstore have the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with a rating above 4.0 have more than 10,000 installs and belong to the 'Entertainment' genre?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.0 AND Installs LIKE '%10,000%' AND Genres = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+100000000%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10 million installs and belong to the category of Action?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%+10,000,000%' AND Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for apps with 4.5 or higher rating?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Education category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Education' AND Installs LIKE '%10,000%' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the category 'Role Playing' have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN T1.Installs = '10,000+' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(*) FROM playstore AS T1 WHERE T1.Category = 'Role Playing'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Action' AND Price = 0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the playstore, in order of their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the 'Adventure' category have a rating above 4.5 and more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Adventure' AND Rating > 4.5 AND Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres for apps with ratings higher than 4.5?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of apps that have a sentiment polarity score of 0.9 or more and belong to the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Genres FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Entertainment' AND T2.Sentiment_Polarity >= 0.9"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Music category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Music'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the Health & Fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'Health & Fitness'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps in the Tools category with more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'TOOLS' AND T1.Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the Adventure game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with a rating of 4.5 and above that are in the educational category and were last updated in 2020?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating >= 4.5 AND Category = 'Educational' AND SUBSTR('Last Updated', -4) = '2020'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the action category, which have more than 10 million installs and free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Action' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000000 AND Price = 0 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which games have an average rating of 4.5 and have more than 100000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating = 4.5 AND Installs LIKE '%100000%' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1000 reviews that have an average rating less than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 1000 AND Rating < 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest-rated apps in the Adventure category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Adventure' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs for all apps in the 'Strategy' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Genres = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 1,000 installs and have a positive sentiment, and how many?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(*) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '%,1,000%' AND T2.Sentiment = 'Positive' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with less than 10,000 installs and what is the percentage ratio of positive sentiment reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), CAST(COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '<% 10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the applications that have a rating higher than 4.5 and are related to social media?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Genres LIKE '%Social Media%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the apps that have been reviewed with sentiment greater than 0.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT playstore.Category FROM playstore INNER JOIN user_reviews ON playstore.App = user_reviews.App WHERE user_reviews.Sentiment = 'Positive' AND user_reviews.Sentiment_Polarity > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "List the apps in the technology category with a rating greater than 4.5 and what is the sentiment polarity of the reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, T2.Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Technology' AND T1.Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of all apps that are in the category 'Role Playing' and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Role Playing' AND Installs LIKE '%1% M'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the most installs and what are their genres?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Genres FROM playstore AS T1 WHERE T1.Installs NOT LIKE '%I%' AND T1.Installs NOT LIKE '%M%' AND T1.Installs NOT LIKE '%B%' ORDER BY CAST(REPLACE(REPLACE(T1.Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "How many users hold positive sentiment for apps that are in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT COUNT(DISTINCT user_reviews.App) FROM user_reviews INNER JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Genres LIKE '%Strategy%' AND user_reviews.Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%10%million%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating and in the category of 'TRAVEL'?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'TRAVEL' ORDER BY T1.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "List apps that have a rating greater than 4.5 and a size less than 50M, along with the number of installs and genres.",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, T1.Size, T1.Installs, T1.Genres FROM playstore AS T1 WHERE T1.Rating > 4.5 AND T1.Size < '50M' ORDER BY T1.Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of the top-rated apps in the category of Action?",
    "evidence": "",
    "SQL": "SELECT T1.Genres FROM playstore AS T1 INNER JOIN (SELECT App, AVG(Rating) AS Rating FROM playstore WHERE Category = 'Action' GROUP BY App ORDER BY Rating DESC LIMIT 10) AS T2 ON T1.App = T2.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have more than 100 installs and have a rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, T1.Installs FROM playstore AS T1 WHERE T1.Installs LIKE '%100%' AND T1.Rating > 4.5 ORDER BY T1.Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating higher than 4.0 and have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.0 AND Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with 4.5+ average rating and less than 500 reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating >= 4.5 AND Reviews < 500"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category that have a review sentiment subjectivity score above 0.5?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' AND EXISTS (SELECT * FROM user_reviews WHERE user_reviews.App = playstore.App AND Sentiment_Subjectivity > 0.5)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have the most positive sentiment ratings?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Polarity) as Total_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Total_Polarity DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which applications are both free and have the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Entertainment category that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'ENTERTAINMENT' AND T1.Installs LIKE '%%100000%' ORDER BY T1.Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications with the highest installs in the Action category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Action' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of users towards the 'Pok\u00e9mon Go' app?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM user_reviews AS T2 WHERE T2.App = 'Pok\u00e9mon Go'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of at least 4.5 and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS AverageRating FROM playstore WHERE Rating >= 4.5 GROUP BY App ORDER BY AverageRating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps that are free and have more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Price = 0 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 genres that have the highest average rating of apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT Genres, AVG(Rating) AS avg_rating FROM playstore GROUP BY Genres ORDER BY avg_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which games have at least 1,000,000 installs and a rating of 4.5 or higher, and how many of them are currently free?",
    "evidence": "",
    "SQL": "SELECT COUNT(CASE WHEN T1.Type = 'Free' THEN 1 ELSE NULL END) AS Free, COUNT(*) AS Total FROM playstore AS T1 WHERE T1.Installs LIKE '%%%1,000,000%' AND T1.Rating >= 4.5 GROUP BY CASE WHEN T1.Type = 'Free' THEN 1 ELSE 0 END"
  },
  {
    "db_id": "app_store",
    "question": "List apps whose category is 'action' and installs are more than 10,000, and state the size of each app.",
    "evidence": "",
    "SQL": "SELECT App, Size FROM playstore WHERE Category = 'action' AND Installs > '10000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the count of apps with 'Action' category and average rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'Action' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are of 'Action' genre and how many installations do they have?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 installed apps with a rating of 4 and above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of free apps in the entertainment category has at least 100,000 installs and a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(*) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore WHERE Type = 'Free' AND Category = 'Entertainment' AND Installs >= '100,000') FROM playstore WHERE Type = 'Free' AND Category = 'Entertainment' AND Installs >= '100,000' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "Which shopping apps have an average rating of 4.5 and more, and how many installs they have?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'Shopping' AND Rating >= 4.5 GROUP BY App, Installs ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the apps in the adventure category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the Play Store have at least 10 000 000 installs and also have a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT CAST(((SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%M%' AND Rating >= 4.5) / (SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%M%')) * 100 AS REAL) AS percentage"
  },
  {
    "db_id": "app_store",
    "question": "What categories are associated with apps that have more than 1 million installs and a 4-star rating or higher?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Installs LIKE '%1,000,000%' AND Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore) ORDER BY Rating LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular free games and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Type = 'Free' AND Category = 'GAME' GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the application with the highest average rating and the most installs?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating, MAX(Installs) AS Max_Installs FROM playstore GROUP BY Category ORDER BY Average_Rating DESC, Max_Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the games category that have been updated since 2020?",
    "evidence": "",
    "SQL": "SELECT App, Category FROM playstore WHERE Type = 'Game' AND SUBSTR('Last Updated', -4) > '2020' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which puzzle games with more than 1 million installs and a rating of 4.5 and above have the most reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.App) COUNTNUMBER FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs > '1,000,000' AND T1.Rating >= 4.5 GROUP BY T1.App ORDER BY COUNT(T1.App) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the average Sentiment scores for applications in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment) AS avg_sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Social' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 genres that have the most apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Genres, COUNT(*) AS count FROM playstore GROUP BY Genres ORDER BY count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Puzzle genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game' AND Genres LIKE '%Puzzle%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps in the adventure category that have a price and are installed more than 100 thousand times?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'Adventure' AND T1.Installs LIKE '%100%' AND T1.Price IS NOT NULL"
  },
  {
    "db_id": "app_store",
    "question": "What apps belong to the category of 'Arts & Design' and have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Arts & Design' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the 'Education' category with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 100000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Casual' category with the highest average sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) AS average_polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Casual' GROUP BY T1.App ORDER BY average_polarity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps in the 'Sports' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Sports' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of paid apps in the playstore have an average rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN Rating >= 4.5 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(App) FROM playstore WHERE Type = 'Paid'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 10 most popular apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game' LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps from the action category that have more than 10000 installs and a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'ACTION' AND Installs LIKE '%10000%' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 1 million installs and less than 500 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1,000,000+' AND Reviews < 500"
  },
  {
    "db_id": "app_store",
    "question": "Which app has the most reviews and what is the polarity of the sentiment towards it?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(CAST(Sentiment_Polarity AS REAL)) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY COUNT(T2.Translated_Review) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most installs and their respective sizes?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Size FROM playstore AS T1 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that belong to the category 'GAME'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are installed more than 100000000 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '100,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "List all apps that have at least 100,000 installs and have at least 1,000 reviews.",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,100,000%' AND Reviews >= 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest total installs in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T1.Installs) AS Total_Installs FROM playstore AS T1 WHERE T1.Category = 'Entertainment' GROUP BY T1.App ORDER BY Total_Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment subjectivity for Photography apps that have more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Subjectivity) AS Average_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Photography' AND T1.Installs > '100' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the top 5 apps in the Google Play Store with the most reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the most apps with a rating of 4.5 or above, considering only apps with reviews more than 1 million?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.App) FROM playstore AS T1 JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating >= 4.5 AND T1.Reviews > 1000000 GROUP BY T1.Category ORDER BY COUNT(T1.App) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 50 million reviews and have 'Action' in their categories?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Reviews > 50000000 AND Category LIKE '%Action%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T2.Sentiment_Polarity) AS Average_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Average_Sentiment DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the most downloaded entertainment apps that users review highly positively and have a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, COUNT(T1.App) AS TotalInstalls FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'ENTERTAINMENT' AND T2.Sentiment_Polarity > 0 AND T1.Rating >= 4.5 GROUP BY T1.App ORDER BY TotalInstalls DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the application 'My Singing Monsters'?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.App = 'My Singing Monsters'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most number of reviews in the Action category?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(*) as num_reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Action' GROUP BY T1.App ORDER BY num_reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of games with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Tools category by their average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Tools' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps across all genres and what is the percentage ratio of positive sentiment reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), CAST(COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment) FROM playstore AS T1 LEFT JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Price = 0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories with the highest average rating and what is the count of apps under each category?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) AS average_rating, COUNT(*) AS app_count FROM playstore AS T1 GROUP BY T1.Category ORDER BY average_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all education Apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps in the action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest number of installs and their corresponding categories?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Category, SUM(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) AS total_installs FROM playstore AS T1 GROUP BY T1.App, T1.Category ORDER BY total_installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps which have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%>10 million%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for apps with a rating of 4.5 or higher and how many of these reviews are positive?",
    "evidence": "",
    "SQL": "SELECT COUNT(T2.Translated_Review), SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) AS Positive_Count FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews of apps in the puzzle genre and how many of them are positive?",
    "evidence": "",
    "SQL": "SELECT COUNT(T1.Reviews), SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most reviewed apps in the playstore that are priced between $1 and $5?",
    "evidence": "",
    "SQL": "SELECT App, Reviews FROM playstore AS T1 WHERE T1.Price BETWEEN '1' AND '5' GROUP BY T1.App ORDER BY T1.Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What apps are rated with more than 4.2 stars and have more than 1 million installs? Show me the App names.",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.2 AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for all travel applications with rating more than 4.5?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Rating > 4.5 AND Category = 'Travel'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps from the 'Educational' category have the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Educational' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the 'Casual' category, and how many reviews do they have?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore WHERE Category = 'Casual' GROUP BY App ORDER BY COUNT(Reviews) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings and most common sentiment of apps in the food and drink category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), MAX(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) AS Most_Positive_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Food and drink' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 applications with the highest number of installs in the racing genre?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Racing' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 applications with the most positive reviews?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Count FROM user_reviews WHERE Sentiment = 'Positive' GROUP BY App ORDER BY Count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '100,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore with the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of no comment reviews are from apps with ratings between 4 and 5?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN T1.Rating >= 4 AND T1.Rating < 5 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.App) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Translated_Review = 'nan'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of the top-rated apps in the 'Finance' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Genres FROM playstore WHERE Category = 'Finance' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Gaming'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG( CAST( replace(replace( Price, ',', '' ), '$', '' ) AS REAL ) ) AS Average_Price FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with more than 100,000 downloads have the highest rating in the adventure category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Adventure' AND Installs LIKE '%,100,000%' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the top 10 rated apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category, T1.App FROM playstore AS T1 WHERE T1.Category = 'Productivity' ORDER BY T1.Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the category 'Simulation'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Strategy category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest sentiment polarity score and their genres?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Genres, MAX(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App, T1.Genres ORDER BY MAX(T2.Sentiment_Polarity) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have a rating of more than 4 and a size of more than 10 M?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating > 4 AND Size > '10M'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Business' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Business'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most reviewed apps with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%%10,000%' GROUP BY App ORDER BY Reviews DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most downloaded puzzle games and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Type = 'Puzzle' GROUP BY App ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are in the top 5 of the 'Casual' category by rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Casual' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest total Sentiment subjectivity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Subjectivity) AS Total_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Total_Sentiment DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the 'Tools' category have a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(*) AS REAL) * 100.0 / (SELECT COUNT(*) FROM playstore WHERE Category = 'Tools' AND Rating > 4.0) FROM playstore WHERE Category = 'Tools' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the social media category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social Media'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Action' category that have an average rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Action' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps under 50MB in size?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as Count FROM playstore WHERE Size < '50MB' GROUP BY App ORDER BY Count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(T1.Price AS REAL)) FROM playstore AS T1 WHERE T1.Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Productivity' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Productivity' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the apps in the 'Arcade' category that have a 'Very Positive' sentiment and more than 1 million downloads?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Arcade' AND T2.Sentiment = 'Very Positive' AND T1.Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories of apps with the most number of reviews?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) as num_reviews FROM playstore GROUP BY Category ORDER BY num_reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which games with more than 1 million installs are in the education category and have a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1,000,000' AND Category = 'EDUCATION' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for free applications that have a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Type = 'Free' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with 'Action' as one of their genres and 'Everyone 10+' as the content rating?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Action%' AND 'Content Rating' = 'Everyone 10+'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have an average rating above 4.5 and have more than 1,000 reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.5 AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that are free and in the arcade genre?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Genres LIKE '%arcade%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Health and Fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for the Game apps under the Action genre?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'Action' AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories with the most installs and what are their average installs?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) as Average_Installs FROM playstore GROUP BY Category ORDER BY Average_Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories that have an average rating above 4.2 and what are their respective sizes?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, AVG(Rating) AS Average_Rating, AVG(CAST(SIZE AS REAL)) AS Average_Size FROM playstore GROUP BY Category HAVING AVG(Rating) > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common genres among the apps with 10,000+ installs and are targeted to adults?",
    "evidence": "",
    "SQL": "SELECT COUNT(DISTINCT Genres) AS Most_Common_Genres FROM playstore WHERE Installs LIKE '%10,000%' AND \"Content Rating\" = 'Adult'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  }
]