[
  {
    "db_id": "app_store",
    "question": "What are the names of top 5 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 rated apps in the 'Strategy' category on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Strategy' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Gaming' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore have more than 10 million installs and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%m%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps with more than 100 million installs in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100 million%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Play Store that have 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 top 3 most popular apps in the Adventure category, along with their rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Adventure' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have more than 1 million installs and an average rating of 4 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%M+' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps in the Play Store that have more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT distinct Category FROM playstore WHERE Installs LIKE '%,1000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Gaming' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "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 are the top 5 most frequently reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS 'Reviews' FROM user_reviews GROUP BY App ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Educational' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Educational'"
  },
  {
    "db_id": "app_store",
    "question": "Which Playstore apps have more than 100,000 installs and a rating of 4.0 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100,000%' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'Compass' app in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='Compass'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Android 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 in the playstore with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'education' category that have a rating of at least 4.5 and have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='education' AND Rating >= 4.5 AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Social' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Social' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category='Games' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 100 million installs from the playstore that have a rating of 4.5 or more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100 million%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the playstore that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%M+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Puzzle' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Android apps with the highest average rating from the playstore?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS average_rating FROM playstore WHERE Type = 'Android' GROUP BY App ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity for all reviews of a specific app in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN (SELECT App FROM playstore) GROUP BY App ORDER BY AVG(Sentiment_Polarity) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have more than 1000 installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1000' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the game applications?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "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 top 3 highest rated apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Action' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of user reviews for each app in the playstore?",
    "evidence": "",
    "SQL": "SELECT p.App, AVG(ur.Sentiment_Polarity) as Average_Sentiment_Polarity FROM user_reviews ur JOIN playstore p ON ur.App = p.App GROUP BY p.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the 'Simulation' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'Simulation' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which Playstore apps have an average rating of 4.5 or higher and more than 1 million installs, and also have a 'Role Playing' genre?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%1%000000' AND Type = 'Role Playing'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the playstore with a rating above 4.5 and more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > 4.5 AND Installs > '100,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories of Play Store apps that have more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) AS InstallCount FROM playstore WHERE Installs LIKE '%10000%' GROUP BY Category ORDER BY InstallCount DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating of at least 4.5 in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Education' category with a rating above 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Rating > 4 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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 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 the most popular apps in the 'Arcade' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > (SELECT AVG(Rating) FROM playstore)"
  },
  {
    "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 rating of the most reviewed app in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App IN (SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1)"
  },
  {
    "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": "Which playstore apps have more than 1000000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1000000'"
  },
  {
    "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 apps in the playstore have more than 1,000,000 installs and a rating of more than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,1,000,000%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Casual' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps from the PlayStore with a rating of 4.5 or above, and a review sentiment of 'Positive'?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore p JOIN user_reviews r ON p.App = r.App WHERE p.Rating >= 4.5 AND r.Sentiment = 'Positive' ORDER BY p.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore have more than 100,000 installs and a rating of more than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100,000%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Entertainment' category with an average rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Entertainment' category with a minimum of 1,000,000 installs and average rating of 4.5 or more?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Entertainment' AND Installs='1,000,000+' AND Rating>=4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS AverageRating FROM playstore WHERE Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the categories of apps in the Play Store with over 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Strategy' category with an average rating of 4.5 and more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Strategy' AND Rating >= 4.5 AND Installs > '1000000' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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": "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 names of the top-rated apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'My Simple Game'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'My Simple Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the 'Tools' category with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' AND Installs LIKE '%,1,000%' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,100,000%' OR Installs LIKE '%100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the playstore which have more than 100000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '100000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'GAME' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'GAME' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications in the 'Books & Reference' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Books & Reference'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1% million%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Games' category with a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' AND Rating>=4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have an average rating of more than 4.5 stars and a sentiment of positive from users?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND EXISTS (SELECT 1 FROM user_reviews WHERE user_reviews.App = playstore.App AND user_reviews.Sentiment = 'positive')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Play Store's 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS average_rating FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'casual' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='casual' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps with at least 1000 reviews and an average rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating >= 4.5 AND Reviews >= 1000 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the playstore with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of all apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'Entertainment' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Entertainment' AND Rating > (SELECT AVG(Rating) FROM playstore WHERE Category='Entertainment')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "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 is the average rating of apps in the Play Store that have more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the applications 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 top 10 apps in the 'Tools' category of the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Tools' LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of applications in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that have a rating of 4.8 or higher and at least 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.8 AND Reviews >= 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with an average rating higher than 4 that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4 AND Installs LIKE '%>%10,000,000' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'Education' category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Installs LIKE '%1% million%' AND Rating > (SELECT AVG(Rating) FROM playstore WHERE Category = 'Education' AND Installs LIKE '%1% million%')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest overall rating in the Google Play Store?",
    "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 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 are the apps in the 'Games' category with more than 10 million installs and a rating of more than 4 out of 5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Games' AND Installs LIKE '% million%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as count FROM user_reviews GROUP BY App ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'ENTERTAINMENT' category with a minimum of 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ENTERTAINMENT' AND Installs LIKE '%,100,000%' OR Installs LIKE '100,000+'"
  },
  {
    "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 are the top 5 highest rated apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Action' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the 'Action' category with more than 10,000 installs and a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Installs LIKE '%,10,000%' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the playstore with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1%000000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore with a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Google Play store have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%1%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'ACTION' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='ACTION' AND Rating IN (SELECT MAX(Rating) FROM playstore WHERE Category='ACTION') ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the top-rated app in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of an app called Facebook from the playstore database?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Facebook'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Facebook'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Facebook'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that have 'Games' as their genre and their average rating is greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Games' AND Rating > 4.0"
  },
  {
    "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 are the top 5 apps with the highest rated reviews in the 'tools' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'tools' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the Play Store by rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most highly-rated apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the playstore that have a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as TotalInstalls FROM playstore WHERE Rating > 4.0 GROUP BY App ORDER BY TotalInstalls DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Social' category that have more than 100000 installs and a rating of at least 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Social' AND Installs>='100000' AND Rating>=4 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 highest rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "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 for the 'PUBG Mobile' app?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'PUBG Mobile'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the Play Store that have more than 10,000 installs and are rated 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Arts & Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Arts & Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with more than 100,000 installations that have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%100,000%' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Social' category that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Social' AND Installs LIKE '%1% Million%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating 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 apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Gaming'"
  },
  {
    "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 rating of the apps in the 'Action' category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps with over 10 million installs from the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '% million+' AND Category='Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the 'Action' category in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS average_rating FROM playstore GROUP BY App ORDER BY average_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of a popular app in the Utilities category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Playstore by number of installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "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 rating of the most popular apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs IN (SELECT Installs FROM playstore ORDER BY Installs DESC LIMIT 1)"
  },
  {
    "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": "Which Playstore apps have more than 1000000 installs and 3.5 or higher rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,1,000,000%' AND Rating >= 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What apps with the rating of 4.5 or higher have more than 1000 installations and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs > '1000' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the Play Store, along with their average rating and number of reviews?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS 'Average Rating', COUNT(Reviews) AS 'Number of Reviews' FROM playstore GROUP BY App ORDER BY COUNT(Reviews) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all playstore apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'WhatsApp Messenger' in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated apps in the Play Store across all genres, with at least 1000 installs?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Installs LIKE '%1000%' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have an average rating of 4.5 and more in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1 million installs on playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '% million%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular app in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "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 is the average rating of apps in the Action category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps in the 'Puzzle' category that have an average rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Puzzle' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Puzzle' genre that have an average rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres='Puzzle' AND Category IN (SELECT App FROM playstore WHERE Rating > 4 ORDER BY Rating DESC LIMIT 5)"
  },
  {
    "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 apps from the Playstore have a sentiment score of positive?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews WHERE Sentiment = 'positive'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'Gardening' category apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Gardening'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the entertainment category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Entertainment' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of all apps in the 'GAME' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have received more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps in the Playstore, across all categories?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Rating FROM playstore GROUP BY App ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment of reviews for each application in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT p.App, AVG(Sentiment_Polarity) AS Average_Sentiment FROM user_reviews ur JOIN playstore p ON ur.App = p.App GROUP BY p.App ORDER BY Average_Sentiment"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews GROUP BY App ORDER BY COUNT(*) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the Play Store, sorted by their average user rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating IS NOT NULL GROUP BY App ORDER BY AVG(Rating) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "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 are the apps in the playstore with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000,000+'"
  },
  {
    "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 are the top rated apps in the playstore categorized as Productivity?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Productivity' AND Rating > 4 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 1 million installs and a rating above 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% million%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What apps on Play Store have more than 10,000,000 installs and have an average rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%10,000,000%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as Popularity FROM playstore GROUP BY App ORDER BY Popularity DESC LIMIT 3"
  },
  {
    "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 are the top 10 apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Games' category with the most installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category='Games' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore with more than 10,000,000 installs and a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs='10,000,000+' AND Rating>4.0"
  },
  {
    "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 are all the apps in the playstore that have a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that have more than 10,000 installs and a rating of 4.5 or higher in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Educational' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Educational'"
  },
  {
    "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 average ratings of all applications 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 'Music & Audio' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Music & Audio'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of the reviews for the most popular app in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Strategy' ORDER BY Installs DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most frequently used sentiment in user reviews for 'Action' category apps in the 'Playstore'?",
    "evidence": "",
    "SQL": "SELECT Sentiment, COUNT(*) AS frequency FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Category = 'Action' GROUP BY Sentiment ORDER BY frequency DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating >= (SELECT AVG(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What apps have an average rating of more than 4.5 and more than 1000000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Installs > '1000000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the Entertainment category that have a rating above 4.5 and have more than 10,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Entertainment' AND Rating > 4.5 AND Installs > 10000 LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What apps with the 'Strategy' genre have a rating above 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Strategy' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What are the ratings of top rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Rating > (SELECT AVG(Rating) FROM playstore) ORDER BY Rating DESC LIMIT 10"
  },
  {
    "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 apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "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 app with the highest rating in the 'Adventure' genre?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Adventure' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "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 is the average rating of the apps with more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '100 million'"
  },
  {
    "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 is the average rating of the top 5 apps in the playstore, sorted by installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE (App) IN (SELECT App FROM playstore ORDER BY Installs DESC LIMIT 5)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 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 apps in the Entertainment category with average ratings above 4?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category='Entertainment' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most highly-rated apps in the Games category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Rating_Avg FROM playstore WHERE Category='Games' GROUP BY App ORDER BY Rating_Avg DESC LIMIT 3"
  },
  {
    "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 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 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 apps in the playstore with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10 million%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What apps have been installed more than 10 million times?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10 million'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the category of 'Arcade'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a average rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Finance'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the genres of the apps having more than 10 million installs in the playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Genres FROM playstore WHERE Installs LIKE '%+10%+million%' AND Genres IS NOT NULL"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Entertainment category on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the playstore categorized as 'Education'?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Education' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Entertainment category that have been installed more than 10 million times?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Entertainment' AND Installs LIKE '%10m%' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What apps on the Google Play Store have an average rating of 4.5 or higher and more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest rating in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Social' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Tools' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 10 apps in the 'Education' category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Education' LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the top-rated app in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category='Puzzle' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps by average rating in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS avg_rating FROM playstore WHERE Category = 'Entertainment' GROUP BY App ORDER BY avg_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the game apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game'"
  },
  {
    "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 rating of all apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Action' category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have a high sentiment score in the 'Casual' genre?",
    "evidence": "",
    "SQL": "SELECT * FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE Genres = 'Casual' AND Sentiment = 'Positive' ORDER BY Sentiment_Polarity DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Android apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+10%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings 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 the apps in the 'Trivia' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Trivia'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%M+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'Communication' category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Communication' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the Playstore with a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 1 million installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% million%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Action games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' LIMIT 1"
  },
  {
    "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 is the average rating of the applications that have been reviewed by users?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore AS p JOIN user_reviews AS ur ON p.App = ur.App GROUP BY p.App"
  },
  {
    "db_id": "app_store",
    "question": "What are all the reviews for an app in the 'Educational' category?",
    "evidence": "",
    "SQL": "SELECT * FROM user_reviews WHERE EXISTS (SELECT 1 FROM playstore WHERE playstore.App = user_reviews.App AND playstore.Category = 'Educational')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the top 10 category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category IN (SELECT Category FROM playstore GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 10)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Food & Drink' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "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 all apps in the playstore 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 are the apps with the highest ratings in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Entertainment' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Rating IS NOT NULL GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the overall rating of 'WhatsApp Messenger'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest rating in the 'trivias' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'trivias' AND Rating = (SELECT MAX(Rating) FROM playstore WHERE Category = 'trivias')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the 'Brain Teasers' app?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Brain Teasers'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the application 'King's Puzzle'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'King''s Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Play Store 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 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Play Store categorized under 'Action'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common content rating categories for Android apps in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Android' GROUP BY \"Content Rating\" ORDER BY COUNT(*) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps that have the highest average rating in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Productivity' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating above 4.5 and more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Installs LIKE '%10000%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the Play Store have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'Clash of Clans' app in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Clash of Clans'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps from the Google Play Store in the 'Casual' category with a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Casual' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.0 or more with at least 10000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.0 AND Installs >= '10000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the free apps categorized under 'Tools'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Games category on Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Play Store with the highest average user review rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore p JOIN user_reviews r ON p.App = r.App ORDER BY r.Sentiment_Polarity DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs='1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'WhatsApp Messenger' in the 'Communication' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='WhatsApp Messenger' AND Category='Communication'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the 'Books & Reference' category with a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Books & Reference' AND Rating > 4.5 ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps from the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Entertainment' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of reviews for apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular Android apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Android' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 reviewed apps in the Finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Finance' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'News' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'News'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Tools' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY 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": "What are the top-rated apps in the games category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Play Store 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 are the top 10 most installed apps in the Playstore, along with their genres?",
    "evidence": "",
    "SQL": "SELECT p.App, p.Genres FROM playstore p ORDER BY p.Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps in the playstore that have more than 100,000 installs and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '100,000' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Tools' category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as ReviewCount FROM user_reviews GROUP BY App ORDER BY ReviewCount DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the playstore with the highest 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 is the average rating of the apps in the 'Arcade' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with highest average rating from the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Productivity' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps 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 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Tools' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Tools' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the overall rating of the game 'Clash of Clans'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Clash of Clans'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most rated apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Game' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the 'Education' category have an average rating of 4.5 or higher and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Education' AND Rating>=4.5 AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of reviews for the app with the highest number of installs in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews AS ur JOIN playstore AS ps ON ur.App = ps.App WHERE ps.Category='Productivity' AND ps.Type='app' ORDER BY ps.Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps with a rating of 4.5 in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Game' AND Rating=4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have an average rating above 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Strategy' category with more than 1,000,000 installs and a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Strategy' AND Installs > '1,000,000' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.5 or higher and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating greater than 4.5 and more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of an app in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Review_Count FROM user_reviews GROUP BY App ORDER BY Review_Count DESC LIMIT 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 is the average sentiment polarity of all user reviews for an app categorized as Tools?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Sentiment_Polarity as REAL)) FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "Which App with the highest rating has the highest number of reviews?",
    "evidence": "",
    "SQL": "SELECT p.App, AVG(r.Sentiment_Polarity) AS avg_sentiment FROM playstore p JOIN user_reviews r ON p.App = r.App GROUP BY p.App ORDER BY AVG(r.Sentiment_Polarity) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Playstore apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Gaming'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the playstore with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > (SELECT AVG(Rating) FROM playstore) ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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 top 5 rated apps in the 'Tools' category that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Tools' AND Installs LIKE '%1,000,000%' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of all 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 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 all apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the playstore categorized as 'Social'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular Apps in the 'Action' category, sorted by the number of reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Action' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Android apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Android' AND Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What apps on the Play Store have a rating higher than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 highest rated Android apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Entertainment' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > (SELECT AVG(Rating) FROM playstore) ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore that have more than 1000000 installs and 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Installs LIKE '%M%' AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with over 10,000 installs in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Playstore that have more than 1 million installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1 million%' AND Rating >= 4.5 LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Finance' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Finance'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'Casual' category of Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Casual' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the playstore with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "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 are the top 5 most reviewed apps in the playstore, with their corresponding sentiment and sentiment polarity?",
    "evidence": "",
    "SQL": "SELECT p.App, SUM(ur.Translated_Review) as Reviews, AVG(ur.Sentiment_Polarity) as Sentiment_Polarity, AVG(ur.Sentiment_Subjectivity) as Sentiment_Subjectivity FROM user_reviews ur JOIN playstore p ON ur.App = p.App GROUP BY p.App ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated Android apps in the Games category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Android' AND Category='Games' AND Installs>'10,000' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 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 apps in the education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the playstore that have received more than 1000 reviews and have an average rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore JOIN user_reviews ON playstore.App = user_reviews.App WHERE reviews > 1000 AND rating >= 4.5 ORDER BY rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore apps have the highest rating in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Productivity' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are all the games in the playstore that have more than 1000000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%1000000%'"
  },
  {
    "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 from the playstore have a content rating of 12 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE \"Content Rating\" >= '12'"
  },
  {
    "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 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 categories of the top 10 apps in the playstore with highest average rating?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE (App, Rating) IN (SELECT App, AVG(Rating) AS avg_rating FROM playstore GROUP BY App ORDER BY avg_rating DESC LIMIT 10)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all 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 in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Entertainment' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps on the Google Play Store have the highest average user review rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "Which apps from the playstore have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 Android apps by the number of installs?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Installs) AS installs FROM playstore GROUP BY App ORDER BY installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Action category on Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Game' AND Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular Apps in the Play Store, sorted by the total number of reviews?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Reviews FROM user_reviews GROUP BY App ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps from the playstore that have more than 1000 installs and a minimum rating of 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1000' AND Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "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 are the top 5 Android apps with the most installs in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type = 'Android' AND Category = 'Entertainment' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle' AND Installs = (SELECT MAX(Installs) FROM playstore WHERE Category = 'Puzzle')"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10,000 installs and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10000%' 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) AS avg_rating FROM playstore WHERE Category = 'Action' GROUP BY App ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Android apps in the Play Store that have more than 100 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+100%+million%' AND Type = 'Android'"
  },
  {
    "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 are the top-rated apps in the Games category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Games' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating from the 'travels' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category='travels' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 rated apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Casual' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the playstore categorized as 'action'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS average_rating FROM playstore WHERE Category='action'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the Playstore have a rating of 4.5 or higher and 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 average rating of the apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have more than 1 million installs and their reviews are mostly positive?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% million%' AND EXISTS (SELECT * FROM user_reviews WHERE user_reviews.App = playstore.App AND user_reviews.Sentiment = 'positive')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Play Store 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 'Action' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS 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 top 5 apps with the highest rating in the 'Puzzle' genre in the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Puzzle' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the 'Puzzle' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game' AND Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rated reviews in the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore INNER JOIN user_reviews ON playstore.App = user_reviews.App WHERE Sentiment='Positive' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of an app called 'YouTube' from the 'Play Store'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'YouTube'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Music category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Music'"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore apps have received the highest rating from users?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating IN (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "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": "What is the average rating of the 'Productivity' category apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are 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 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 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-rated apps in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'WhatsApp'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='WhatsApp'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Gaming'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating IN (SELECT DISTINCT Rating FROM playstore ORDER BY Rating DESC LIMIT 5) ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Tools' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity for reviews of the 'Facebook' app?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) AS Average_Sentiment_Polarity FROM user_reviews WHERE App = 'Facebook'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Android apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Android App'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "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 are the top 5 rated apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Tools' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with average rating more than 4 that have more than 10,000 installs in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Rating > 4 AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which App in the Play Store has the most reviews with a positive sentiment?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews GROUP BY App HAVING COUNT(CASE WHEN Sentiment='Positive' THEN 1 END) = (SELECT MAX(count) FROM (SELECT App, COUNT(*) AS count FROM user_reviews WHERE Sentiment='Positive' GROUP BY App))"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Playstore with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'WhatsApp Messenger'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "Which Android apps have more than 1,000,000 installs and a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1,000,000%' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 most reviewed apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Games' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 mobile apps in the Playstore with the most positive reviews, sorted by review count?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Translated_Review) AS ReviewCount FROM user_reviews WHERE Sentiment = 'Positive' GROUP BY App ORDER BY ReviewCount DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Brain' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Brain'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app with most reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App IN (SELECT App FROM user_reviews GROUP BY App ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top-rated apps in the games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Education' category that have more than 100,000 installs and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Installs != 'less than 100,000' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps from the playstore which have more than 1 million installs and whose rating is more than 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs='1,000,000+' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of an app in the 'Books and Reference' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Books and Reference'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the gaming category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Gaming' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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 are the average ratings of the top 5 most reviewed apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App IN (SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 5)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Puzzle' genre in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category='Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore that have a rating of 4.0 or higher and more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.0 AND Installs >= '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the playstore with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "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 are the apps in the playstore with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%>10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 most reviewed apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as Review_count FROM user_reviews GROUP BY App ORDER BY Review_count DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps with at least 1 million installs in the 'ACTION' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ACTION' AND Installs LIKE '%,1,000,000%' AND Rating > (SELECT AVG(Rating) FROM playstore WHERE Category = 'ACTION') ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the playstore with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the education category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='EDUCATION' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are in the Social category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the PlayStore with the highest number of reviews from users who gave them a rating of 4 or 5?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Translated_Review) 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 Android apps in the Play Store that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,100,000%' AND Type = 'Android'"
  },
  {
    "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 is the average sentiment of user reviews for the app with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the PlayStore 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 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps in the playstore by the number of installs?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as total_installs FROM user_reviews GROUP BY App ORDER BY total_installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a high rating (above 4.5) in the Sports category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Sports' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment rating for the 'Game' category of apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Sentiment_Polarity AS REAL)) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Game')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated apps in the 'Comedy' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Comedy' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the applications in the \"Action\" genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular app in the playstore?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of a game called 'Subway Surfers' in the Play Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Subway Surfers'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'GTA V' on the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='GTA V'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the 'Food & Drink' category on the Google Play Store with a rating of 4.0 or higher and at least 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Food & Drink' AND Rating >= 4.0 AND Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 10 most reviewed apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Game' LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'Shopping' category apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Shopping'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest number of installs in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Tools' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Communication'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 100000 installs and are rated more than 4 out of 5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100000%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Productivity' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of user reviews for apps in the category 'Arts & Entertainment'?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category='Arts & Entertainment')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest number of reviews in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1000 reviews on play store that have a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore p JOIN user_reviews ur ON p.App = ur.App WHERE p.Installs > '1000' AND p.Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore with more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Utilities' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 1000 installations and a rating of 4 or more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1000%' AND Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the 'Games' category with the highest average user rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Games' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating of 4.5 and more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating >= 4.5 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) AS Average_Rating FROM playstore WHERE Category='Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > (SELECT AVG(Rating) FROM playstore) LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps in the Play Store, in terms of their content rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE 'Content Rating' IN (SELECT 'Rating Content' FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY Rating DESC) AS row_num FROM playstore) WHERE row_num <= 3)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Play Store with highest 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 top 5 most popular apps in the Entertainment category with a rating of 4.5 and above, based on the number of reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Rating >= 4.5 ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have a rating of 4.5 and more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Android apps in the Education category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS AverageRating FROM playstore WHERE Category = 'Education' GROUP BY App ORDER BY AverageRating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Android apps in the 'Comedy' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Comedy' AND Type = 'Android'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of reviews for the app 'Facebook'?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Sentiment_Polarity AS REAL)) AS average_sentiment_polarity FROM user_reviews WHERE App = 'Facebook'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the sentiment of a review in the 'Education' category for an app with a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT * FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category='Education' AND Rating>=4.5)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Gaming category that have at least 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Gaming' AND Installs='1,000,000+' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the 'Games' category have more than 1000 reviews with a positive sentiment?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' AND EXISTS (SELECT * FROM user_reviews WHERE user_reviews.App=playstore.App AND Sentiment='positive' AND Reviews > 1000)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "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 the apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of all apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular Android apps in the Games category based on their rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Type='Android' AND Category='Games' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications in the 'Simulation' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Simulation' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of a popular game in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'GAME' AND Installs >= '100M' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the 'Games' category with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' AND Installs LIKE '%100,000%' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Puzzle' category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Puzzle'"
  },
  {
    "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 rating of all apps in the Games category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the 'Tools' category with an average rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment rating of all reviews in the 'Action' category for the 'Subway Surfers' app?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Sentiment_Polarity AS REAL)) AS AverageSentiment FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Category = 'Action' AND playstore.App = 'Subway Surfers'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the Playstore that have a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps in the playstore with an average rating of more than 4.5 and more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating > 4.5 AND Installs > '10000'"
  },
  {
    "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 all apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest rating from the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications in the playstore categorized as 'Food & Drink'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with more than 10 million installs in the Google Play Store, sorted by rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%10,000,000%' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 most popular apps in the Playstore, sorted by the number of installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of all apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Books category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Books'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the games category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = (SELECT MAX(Installs) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews GROUP BY App ORDER BY COUNT(*) DESC LIMIT 5"
  },
  {
    "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 are the average ratings for apps in the 'Action' category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of user reviews for apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) AS average_polarity FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Games')"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Google Play Store have a minimum rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Social'"
  },
  {
    "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 5 rated apps by average rating in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) as Average_Rating FROM playstore WHERE Category = 'Social' ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the 'Personalization' category that have a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Personalization' AND Rating > 4.0 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "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 rating of the playstore apps that have more than 10000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top-rated apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Productivity' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Playstore with the highest 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 is the average sentiment rating for all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps from the playstore with a rating above 4.5 that have more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > 4.5 AND Installs LIKE '%,1000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the games category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Game' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore have more than 1 million installs and a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% million%' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps in the playstore that have a rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4"
  },
  {
    "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 are the apps in the 'Utilities' category with at least 1000 installs and an average rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Utilities' AND Installs LIKE '%1000%' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Photography' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Photography'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps 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 rating of all the apps in the 'Social' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "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 apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10,000 installs in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10000' AND Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'Music & Audio' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Music & Audio' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Adventure' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS average_rating FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Games' category of Play Store with a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have at least 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,10,000%' OR Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 1000 reviews and an average rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE App IN (SELECT App FROM user_reviews GROUP BY App HAVING COUNT(*) > 1000) AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of user reviews for the 'Angry Birds' app?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App = (SELECT App FROM playstore WHERE App = 'Angry Birds') LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 1 million installs and are more than 50MB in size?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs='1,000,000+' AND Size LIKE '%MB%' AND size>='50MB'"
  },
  {
    "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 average ratings of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of user reviews for ' Temple Run ' app?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App = 'Temple Run' "
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Tools' category with the highest ratings?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Tools' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps in the playstore that have a rating of 4 or more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the playstore with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 100,000 installs in the Games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100,000%' AND Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the Playstore with more than 1 million installs and a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% Million%' AND Rating > 4.0"
  },
  {
    "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 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 are the top 5 apps with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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 applications in the 'PERSONALIZATION' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category='PERSONALIZATION' GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "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 is the average rating of all apps in the playstore that have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000"
  },
  {
    "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 3 most popular apps in the 'Casual' category with a rating of more than 4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Casual' AND Rating > 4 ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Play Store that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%M%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 rated apps in the 'Productivity' category that have more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Productivity' AND Installs>='100' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have at least 10,000 installs and are in the 'Entertainment' category and have a price?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,10,000%' AND Category = 'Entertainment' AND Price IS NOT NULL"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps with a rating of 4.5 or above in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "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 average ratings 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 apps with a rating of 4.5 or higher from the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Productivity' AND Rating >= 4.5"
  },
  {
    "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 is the average rating of apps in the 'Action' category in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the playstore that have a rating of 4.5 and have more than 10000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.5 AND Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Social' category from the 'playstore' table?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps that belong to the 'Personalization' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Personalization'"
  },
  {
    "db_id": "app_store",
    "question": "What is the sentiment of user reviews for the app 'XYZ'?",
    "evidence": "",
    "SQL": "SELECT Translated_Review, Sentiment FROM user_reviews WHERE App='XYZ'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the playstore, ordered by the number of installs?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Installs FROM playstore WHERE Type='app' GROUP BY App ORDER BY Installs DESC LIMIT 5"
  },
  {
    "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 are the top 5 apps that have more than 10 million installs and a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '10,000,000+' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) as AverageRating FROM playstore GROUP BY App ORDER BY AverageRating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Instagram' in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Instagram'"
  },
  {
    "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 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 apps from the playstore have a rating of 4.0 or higher and have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.0 AND Installs LIKE '%10%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating from users in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Entertainment' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Arcade' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Arcade'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps from the 'Social' category in the Google Play Store with a rating of 4.5 or higher that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Social' AND Rating >= 4.5 AND Installs > '10000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 rated apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Games' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which app has the highest rating from user reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews GROUP BY App ORDER BY AVG(Sentiment_Polarity) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'Camera' app in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='Camera'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1 million installs in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% million%' AND Category = 'Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of reviews for the 'Games' category in the 'Playstore'?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) AS avg_sentiment FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Games')"
  },
  {
    "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 the app 'Instagram'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='Instagram'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Finance'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Puzzle' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Puzzle' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'GAME' category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all 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 top 5 most downloaded apps in the 'Music & Audio' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Music & Audio' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'Instagram'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Instagram'"
  },
  {
    "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 average rating of the top rated apps in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Action' category with the highest average rating among the users who have reviewed them?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore JOIN user_reviews ON playstore.App = user_reviews.App WHERE Category = 'Action' GROUP BY playstore.App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating in the playstore?",
    "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 is the average rating of the apps in the PlayStore by 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Android apps in the 'Entertainment' category with the most positive reviews?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Translated_Review) AS Review_Count FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Entertainment' AND Sentiment = 'Positive') GROUP BY App ORDER BY Review_Count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Games' category, sorted by the number of installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Games' 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 overall sentiment for 'Facebook'?",
    "evidence": "",
    "SQL": "SELECT * FROM user_reviews WHERE App='Facebook'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all 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 apps in the Play Store that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore 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": "What are the top 3 apps in the games category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps have at least 10,000 installs and average rating 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,10,000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular apps in the 'Casual' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Casual' GROUP BY App ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Android apps in the Top 100 that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Android' AND Installs LIKE '%100,000%' LIMIT 100"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'Instagram' in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Instagram'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the application that has the most installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App IN (SELECT App FROM playstore GROUP BY App ORDER BY (SELECT COUNT(*) FROM user_reviews WHERE user_reviews.App = playstore.App) DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'San Francisco' in the 'Travel' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Travel' AND App = 'San Francisco'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of all reviews for the app with category 'Game'?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Category = 'Game'"
  },
  {
    "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 all the apps with a rating of 4.5 or more from the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Games' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps from the Playstore that have an average rating greater than 4.0 and more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND Reviews > 1000 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS avg_rating FROM playstore WHERE Category='Puzzle' GROUP BY App ORDER BY avg_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 most popular apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs IN (SELECT Installs FROM playstore ORDER BY Installs DESC LIMIT 5)"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Play Store that have the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT AVG(Rating) FROM playstore ORDER BY AVG(Rating) DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'Twitter' in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Twitter'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the Play Store with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS average_rating, COUNT(Installs) AS installs FROM playstore GROUP BY App ORDER BY installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Google Maps'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Google Maps'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'Food & Drink' apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have at least 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%M%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular games in the playstore with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type = 'game' AND Installs != 'Less than 1,000' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Action' category having more than 1000000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Installs LIKE '%1,000,000%' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of a popular app in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common ratings given by users to the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating, COUNT(*) AS Count FROM playstore GROUP BY Rating ORDER BY Count DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which game apps in the Play Store have more than 100 million installs and a average rating of 4.0 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100 million%' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the adventure game category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Adventure' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the application 'Instagram'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Instagram'"
  },
  {
    "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 are the top 5 most popular apps in the Playstore with a 4-star rating and more reviews than average?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as Reviews, ROUND(AVG(Rating),2) as AvgRating FROM playstore WHERE Rating >= 4 GROUP BY App ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Health and Fitness category with a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Health and Fitness' AND Rating > 4.0 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Play Store that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most positively reviewed apps in the Play Store, sorted by average sentiment polarity?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Sentiment_Polarity) AS Average_Sentiment FROM user_reviews WHERE Sentiment = 'Positive' GROUP BY App ORDER BY Average_Sentiment DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Gaming'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Entertainment category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Action' category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Action' AND Installs LIKE '%,1,000,000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the category of 'Games'?",
    "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 all the apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.5 and more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the health and fitness category with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Health and Fitness' AND Installs LIKE '%10 million%' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have an average rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps from the 'Action' category that have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Action' AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps in the 'action' genre with a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres='action' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps with more than 1 million installs in the Games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+ Million%' AND Category='Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Casual' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most downloaded apps in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Downloads FROM user_reviews GROUP BY App ORDER BY Downloads DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore apps with more than 10,000 installs have a rating of at least 4.5 and are categorized as \"GAME\"?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%' AND Rating >= 4.5 AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Android apps in the Play Store categorized under 'Entertainment'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Entertainment'"
  },
  {
    "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 the apps in the games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Games' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all 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 App 'WhatsApp Messenger'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Social' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'COMPUTER' category that have a rating of 4.0 and above, and a total of more than 10000 reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='COMPUTER' AND Rating > 4.0 AND Reviews > 10000 ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity for all apps in the 'Tools' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE Genres='Tools'"
  },
  {
    "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 are the top 3 most rated apps in the Play Store, given the user reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore p JOIN user_reviews r ON p.App = r.App ORDER BY r.Sentiment_Polarity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Educational' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Educational' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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 most popular apps in the 'social' category with more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'social' AND Installs > '50000'"
  },
  {
    "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 are the top 3 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Action' category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the playstore that have the highest rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'Instagram' in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social' AND App='Instagram'"
  },
  {
    "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' ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most reviewed apps in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App IN (SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 10)"
  },
  {
    "db_id": "app_store",
    "question": "What is the sentiment of user reviews for an app that falls under the 'Puzzle' category and has at least 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT Translated_Review, Sentiment FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Puzzle' AND Installs >= '10000') ORDER BY Sentiment"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Action' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Play Store 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 are the top 3 most popular Apps by installs on Playstore?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the game category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the games category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Rating FROM playstore WHERE Category='Games' GROUP BY App ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.5 or above and 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 is the average rating of apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Play Store with the highest 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 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 are the top 5 apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Finance' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Finance' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Shopping' category with the highest rating in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Shopping' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the Action category?",
    "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 apps have more than 10,000 installs and a rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'Temple Run'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Temple Run'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the Play Store with more than 1 million installs, ranked by the average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Installs LIKE '%M%' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Gaming'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps with at least 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 in the 'Action' category in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of apps in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Gaming'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Casual' category with a rating of at least 4.5 and more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Casual' AND Rating >= 4.5 AND Installs LIKE '%1%000000%' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 10,000 installs in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "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 rating of the top 10 most popular apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs IN (SELECT Installs FROM playstore ORDER BY Reviews DESC LIMIT 10)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Food & Drink' category with a minimum rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Food & Drink' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 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 is the total number of reviews of an app with a rating of 4.5 in the Technology category?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews AS ur JOIN playstore AS ps ON ur.App = ps.App WHERE ps.Category = 'Technology' AND ps.Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Games' category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "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 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore have at least 5000 installs and more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%5000%' AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Play Store, sorted by the 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 apps in the Play Store with a rating of more than 4.0 have received more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all apps in the 'Puzzle' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Tools'"
  },
  {
    "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 are the top 5 apps in the Games category having more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Games' AND Installs > '10,000' ORDER BY Reviews 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 = '100,000+' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular app in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Sports category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sports'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the genres for the top-rated apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Rating > 4.0 GROUP BY Genres ORDER BY COUNT(*) DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with highest rating from the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are all the Play Store apps that have more than 10,000 reviews and an average rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 10000 AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore app has the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of all user reviews in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore with a rating of 4.5 or higher and 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 average sentiment polarity of all user reviews for the app 'Google Maps'?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App = 'Google Maps'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the playstore that have been installed more than 1000000 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of all reviews for 'Camera FV-5 Gold' app?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App='Camera FV-5 Gold'"
  },
  {
    "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 with the highest rating in the Play Store, sorted by rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the Playstore, along with their average rating and the number of reviews?",
    "evidence": "",
    "SQL": "SELECT p.App, AVG(u.Sentiment_Polarity) as Avg_Rating, COUNT(u.Translated_Review) as Num_Reviews FROM playstore p JOIN user_reviews u ON p.App = u.App GROUP BY p.App ORDER BY Num_Reviews DESC LIMIT 5"
  },
  {
    "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-rated apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Type='Game' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps that have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs like '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the Entertainment category with more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Entertainment' AND Installs>'10,000,000' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most reviews in the 'Google' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Google' ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10,000 installs and at least 4 stars rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%10,000%' AND Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'GAME' category with at least 50,000 reviews and an average rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Reviews >= 50000 AND Rating >= 4.5 ORDER BY Rating 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 apps in the playstore have a rating of 4.5 or above and have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'Educational' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Educational'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the Playstore have a average rating greater than 4.5 and a minimum of 1000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Installs >= '1000' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps in the playstore with more than 1000000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1,000,000%'"
  },
  {
    "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 average_rating FROM playstore WHERE Category = 'Games' GROUP BY App ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Translated_Review) as total_reviews FROM user_reviews GROUP BY App ORDER BY total_reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the playstore with highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating IN (SELECT DISTINCT Rating FROM playstore ORDER BY Rating DESC LIMIT 3)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the Play Store with a sentiment of 'Very Negative'?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as reviews FROM user_reviews GROUP BY App ORDER BY reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Puzzle' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps in the PlayStore categorized as Social?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Social' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have more than 10 million installs and a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10 million%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the 'Games' category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Games' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 10 most rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the play store?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Reviews FROM user_reviews GROUP BY App ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common categories of apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) as count FROM playstore GROUP BY Category ORDER BY count DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore have a rating above 4.5 and have more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Installs LIKE '%1,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps by users?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category IS NOT NULL ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%' OR Installs LIKE '%10,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most frequently reviewed apps on the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as frequency FROM user_reviews GROUP BY App ORDER BY frequency DESC LIMIT 10"
  },
  {
    "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 is the average rating of all apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of user reviews for the app 'Instagram'?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App='Instagram'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Gaming'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10,000,000' ORDER BY Installs DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore that have a rating of 4.5 and more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of an app that has been downloaded at least 10 million times and has a price less than 5 dollars?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10 million%' AND Price LIKE '%<5$%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Productivity'"
  },
  {
    "db_id": "app_store",
    "question": "Which top rated apps in the Playstore have more than 1,000,000 installs and are available for free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4 AND Installs > '1000000' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game' AND Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of reviews for a specific app?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) AS Sentiment_Polarity FROM user_reviews WHERE App = '<app_name>'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average sentiment polarity of the user reviews for a particular app in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Sentiment_Polarity AS REAL)) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Tools')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Personalization' category that have an average rating of 4.5 or higher and more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Personalization' AND Rating > 4.5 AND Installs > '10000' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Playstore categorized under 'Tools'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Tools'"
  },
  {
    "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 are the top-rated apps in the Play Store by category?",
    "evidence": "",
    "SQL": "SELECT App, Category, Rating FROM playstore WHERE Type = 'App' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have over 1 million installs in the Action category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '% million%' AND Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps with more than 10,000 installs in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Casual' AND Installs LIKE '%10,000%' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'WhatsApp Messenger' in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Social' AND App='WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most positive user reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews GROUP BY App ORDER BY (SELECT COUNT(*) FROM user_reviews WHERE Sentiment='Positive') DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the categories that have at least 1000 installations for free?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%free%' AND CAST(substr(Installs, 1, INSTR(Installs, ' installs') - 1) AS INTEGER) >= 1000"
  },
  {
    "db_id": "app_store",
    "question": "What apps have reviews with a sentiment of 'positive'?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews WHERE Sentiment = 'positive'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'Education' category with more than 1000000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Education' AND Installs LIKE '%1000000%' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore app has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Gaming' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which Apps from the Playstore have a rating of 4.5 or above and have more than 1,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 highest rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps in the playstore that have a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps from the 'ACTION' category with 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 average rating of all apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a high rating in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as Reviews FROM user_reviews GROUP BY App ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "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 highest-rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) 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 games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Games'"
  },
  {
    "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 average sentiment polarities for user reviews of apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews AS ur JOIN playstore AS ps ON ur.App = ps.App WHERE ps.Category='Games' GROUP BY ur.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most positive user reviews?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Sentiment_Polarity) AS average_polarity FROM user_reviews GROUP BY App ORDER BY average_polarity DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most positive reviews on the Play Store, ordered by the number of reviews?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Translated_Review) as Count, SUM(CASE WHEN Sentiment = 'positive' THEN 1 ELSE 0 END) as Positive FROM user_reviews GROUP BY App ORDER BY Count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Play Store have more than 10 million installs and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%>10%0' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'TOOLS' category with average rating more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='TOOLS' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have a minimum rating of 4 and more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4 AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps by average rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS average_rating FROM playstore GROUP BY App ORDER BY average_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps with more than 100 million installs have a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '100 million' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the overall rating of the top-rated game in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category='Strategy' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Education category with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Installs > '10,000,000' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the 'Education' category of the Google Play Store that have an average rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most highly-rated apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Puzzle' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of the apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category='Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the playstore that have a rating of 4.5 and more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Action' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000 installs and are in the category of 'Education'?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10000' AND Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Puzzle' genre from the 'playstore' table?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Food & Drink' category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Food & Drink' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the entertainment category with a minimum of 1000 reviews and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Entertainment' AND Reviews >= 1000 AND Rating >= 4.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": "Which apps in the playstore have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%>%10%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the top 1000 most popular games?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game' LIMIT 1000"
  },
  {
    "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 for apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with highest rating in the gaming category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS avg_rating FROM playstore WHERE Category='Gaming' GROUP BY App ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the overall sentiment of user reviews for the 'WhatsApp Messenger' app?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App = 'WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Translated_Review) FROM user_reviews GROUP BY App ORDER BY COUNT(Translated_Review) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps by users in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.5 and more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%,100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='GAME' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have more than 1,000,000 installs and a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%,1,000,000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the 'Education' category by average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) as Average_Rating FROM playstore WHERE Category='Education' GROUP BY App ORDER BY Average_Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the 'Casual' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual' AND Type = 'Game' "
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Translated_Review) as Review_Count FROM user_reviews GROUP BY App ORDER BY Review_Count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the sentiment of the translated reviews for the most popular Android app in the playstore?",
    "evidence": "",
    "SQL": "SELECT Sentiment FROM user_reviews AS ur JOIN playstore AS p ON ur.App = p.App ORDER BY p.Installs DESC LIMIT 1"
  },
  {
    "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 5 highest-rated apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 100,000 installs and a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs='100,000+' AND Rating > 4.0"
  },
  {
    "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 rating of apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of top 5 most popular apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of playstore apps in the education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Adventure' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Adventure' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications in the Playstore with the highest 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 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 apps in the playstore have a rating of 4.5 and more, and what is the average sentiment of the reviews for those apps?",
    "evidence": "",
    "SQL": "SELECT p.App, AVG(ur.Sentiment_Polarity) AS Average_Sentiment FROM playstore p JOIN user_reviews ur ON p.App = ur.App WHERE p.Rating >= 4.5 GROUP BY p.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the playstore 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 are the apps with average rating more than 4.5 in the games category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Games' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the PlayStore that are rated 4 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.0 ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Play Store that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS AvgRating FROM playstore GROUP BY App ORDER BY AvgRating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of reviews for apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category='Action')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the entertainment category that have a rating of 4.5 or higher and more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Rating >= 4.5 AND Installs > 10000 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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 is the average rating of Android apps that belong to the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the playstore with the most positive reviews?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as positive_reviews FROM user_reviews WHERE Sentiment = 'positive' GROUP BY App ORDER BY positive_reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Google Maps app on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='Google Maps'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 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 the apps in the games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that are rated 4 stars or above and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4 AND Installs LIKE '%1%000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Android apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'Uber'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Uber'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Education' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top-rated app in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Sports' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the game category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications that have more than 10 million installs in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the most popular apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs IN (SELECT Installs FROM playstore ORDER BY Installs DESC LIMIT 10)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest 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 3"
  },
  {
    "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 apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the category of 'Simulation'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS 'Average Rating' FROM playstore WHERE Category = 'Simulation'"
  },
  {
    "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 names of apps in the `playstore` table that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the Playstore by the number of reviews?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as ReviewCount FROM user_reviews GROUP BY App ORDER BY ReviewCount DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Education' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS avg_rating FROM playstore WHERE Category='Education' GROUP BY App ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating in the playstore?",
    "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 is the average rating of apps in the 'Arts & Design' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Arts & Design'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the Playstore with more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Reviews > 1000 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the overall sentiment of user reviews for the top-rated apps in the 'ACTION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) AS overall_sentiment FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Category = 'ACTION' GROUP BY playstore.App ORDER BY playstore.Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Entertainment' category with the most reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Entertainment' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most rated apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Rating FROM playstore GROUP BY App ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a minimum of 1,000,000 installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1,000,000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating IS NOT NULL ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have more than 10,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Android apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Android' AND Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Android apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Android App'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Game' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 highest rated apps in the playstore with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Installs > '100,000' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the 'Shopping' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Shopping' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of all applications categorized as 'Casual' in the 'Playstore'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated Android apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Type = 'Android' AND Category = 'Games' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Education category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Game' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 most rated apps in the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Productivity' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "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 apps with the most reviews in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS ReviewCount FROM user_reviews GROUP BY App ORDER BY ReviewCount DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest rating from the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the action category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Action' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated apps from the category 'Tools'?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Tools' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top-rated apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "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 sentiment of all user reviews for a popular app in the Games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews JOIN playstore ON user_reviews.App = playstore.App WHERE playstore.Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have an average rating of 4.5 or more 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 all the apps in the 'Entertainment' category that have more than 10,000,000 installs and a rating of more than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Installs LIKE '%,10,000,000%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > (SELECT AVG(Rating) FROM playstore) ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "Which Play Store apps have more than 1000 reviews and an average rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 1000 AND Rating >= 4.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What apps have an average rating of 4.5 or higher and more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Installs LIKE '%10000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have reviews with a sentiment polarity more positive than 0.5?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews WHERE Sentiment_Polarity > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'WhatsApp Messenger'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5"
  },
  {
    "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 apps that have more than 1 million installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1 million%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Action category in the Play Store?",
    "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 with an average rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='Puzzle' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'Games' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Games' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Education' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Education' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'ACTION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS average_rating FROM playstore WHERE Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the App 'WhatsApp Messenger' in the 'Communication' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'WhatsApp Messenger' AND Category = 'Communication'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the playstore with a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.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 are the top-rated apps in the 'Educational' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Educational' AND Rating=(SELECT MAX(Rating) FROM playstore WHERE Category='Educational') ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the playstore with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Tools' category from 'playstore'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "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": "Which apps with more than 1 million installs have a rating of 4.0 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1 million%' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the highest rating in the action category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the playstore with the highest 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 is the average rating of the games in the Playstore app store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 highest rated apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='Action' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "Which top-rated apps in the 'Productivity' category have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Productivity' AND Installs LIKE '%M%' AND Rating > 4.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 most reviewed apps in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore JOIN (SELECT App, COUNT(*) as ReviewCount FROM user_reviews GROUP BY App ORDER BY ReviewCount DESC LIMIT 5) as Top5Apps ON playstore.App = Top5Apps.App WHERE Category='Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the popular apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 'Temple Run' app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Temple Run'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most installs in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories with the highest average rating in the PlayStore?",
    "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": "What are all the top-rated Android apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Android' AND Category = 'Tools' AND Rating > 4 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Tools' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category='Tools' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps on the Playstore have more than 100 million installs and a rating of 4.5 or more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100 million%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps by average rating in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category='Tools' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most positive reviews in the Music category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p.App, SUM(CASE WHEN ur.Sentiment = 'Positive' THEN 1 ELSE 0 END) as Positive_Count FROM playstore p JOIN user_reviews ur ON p.App = ur.App WHERE p.Category = 'Music' GROUP BY p.App ORDER BY Positive_Count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have an average rating of 4.5 or higher and more than 1,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 1 million installs and more than 4 stars?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% million%' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have an average rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated apps in the 'Action' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Action' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the 'Social' category and their average rating?",
    "evidence": "",
    "SQL": "SELECT playstore.App, AVG(playstore.Rating) AS Average_Rating FROM playstore JOIN (SELECT App, Category FROM playstore WHERE Category='Social') AS social_apps ON playstore.App=social_apps.App GROUP BY playstore.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most installed android apps categorized as 'GAME' on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'GAME' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'WhatsApp Messenger' in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='WhatsApp Messenger'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the Playstore with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'game' apps in PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'GAME'"
  },
  {
    "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 top 3 most downloaded apps in the play store that have a high rating and more than 10,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Rating > 4.0 AND Reviews > 10000 ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps in the Play Store with more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore have an average rating of 4.5 and more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 1 million installs and a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1% million%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Play Store with more than 10 million downloads that have an average rating of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs > '10 million' AND Rating > 4 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all 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 apps in the 'Game' category in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of mobile apps with more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT distinct Category FROM playstore WHERE Installs LIKE '%,1000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the 'Action' category with the highest average rating?",
    "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 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 rating of the top 10 most reviewed apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore AS p JOIN (SELECT App, COUNT(*) AS cnt FROM user_reviews GROUP BY App ORDER BY cnt DESC LIMIT 10) AS t ON p.App = t.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the 'Tools' category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Tools' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 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": "What are the apps with more than 50 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%50 million%'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with more than 10,000 installs have an average rating of 4.5 or higher?",
    "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 in the games category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Games' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Games' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of a popular app in the 'Puzzle' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'App' AND Category = 'Puzzle'"
  },
  {
    "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": "What is the rating of the 'Mobile Legends: Bang Bang' app in the Play Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App='Mobile Legends: Bang Bang'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest number of installs in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of an app in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 most popular apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the playstore that have a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "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 in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Play Store categorized as `Tools`?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Tools' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Sports category that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Sports' AND Installs LIKE '%,10,000%' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the top-rated category of the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category IN (SELECT Category FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common categories of apps on the Playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, COUNT(*) FROM playstore GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 10 apps in the 'Game' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have more than 10 million installs and a rating of 4.0 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10M%' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'ACTION' category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest average rating in the 'Finance' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='Finance' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "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 top 5 most installed Android apps, and their corresponding installation numbers?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'ACTION' category on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='ACTION' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity of user reviews for apps that belong to the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(Sentiment_Polarity AS REAL)) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'Social')"
  }
]