[
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Candy Crush Saga' app and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher in the 'playstore' table? Additionally, provide the average number of reviews for these apps.",
    "SQL": "SELECT COUNT(*), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating in the Google Play Store?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category and how many apps are there in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many of them are paid?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Tools' AND Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5? List the names of these apps along with their categories.",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Reviews = ( SELECT MAX(Reviews) FROM playstore )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and have at least 10,000 reviews? List their categories.",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating > 4.5 AND Reviews >= 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is the average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and the number of reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app '7 Minute Workout'?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = '7 Minute Workout'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have a rating above 4.5?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating > 4.5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 4.5 or higher and have at least 1,000,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Reviews >= 1000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category with at least 100 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews >= 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment review for the 'Facebook' app and what is the average rating of these reviews?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Facebook' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is the average rating for these apps?",
    "SQL": "SELECT COUNT(App) AS Number_of_apps, AVG(Rating) AS Average_rating FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have a rating greater than 4.0? List the names of these apps.",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular apps based on the number of reviews? Please provide the app name, category, and average rating.",
    "SQL": "SELECT App, Category, AVG(Rating) as Average_Rating FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have at least 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews >= 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is the average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating of at least 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are available in the 'Health & Fitness' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App) AS Number_of_apps, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a rating of 4.5 or higher for the app 'Body Fit' and what is the average rating of these users?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE App = 'Body Fit' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Minecraft' app and how many users have reviewed it?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Minecraft'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating in the 'Family' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Family' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and number of reviews for apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps with 5000 or more reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews >= 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a content rating of 'Everyone' and what are their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE 'Content Rating' = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating among all apps in the playstore?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Entertainment' category have a rating greater than 4.0? List their names.",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Books and Reference' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Books and Reference'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social Networking' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social Networking'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews and what is the average rating for the app 'App Name'?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'App Name'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Family' category have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4 and what is their average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Rating > 4 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and what is the total number of reviews for these apps?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Educational' category that have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Educational' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the games in the 'Playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Candy Crush Saga' app based on the user reviews?",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'Entertainment' category have the highest average rating?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews were received for the app 'Super Mario Odyssey' and what is the average rating of the app?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'Super Mario Odyssey'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0 and have been installed more than 10,000,000 times?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0 AND Installs > '10,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is the average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'Free' price and belong to the 'Health & Fitness' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Health & Fitness' AND Price = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating in the playstore?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many apps are there in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and how many of those apps are in the 'Tools' category?",
    "SQL": "SELECT COUNT(App), COUNT(CASE WHEN Category = 'Tools' THEN App END) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have received at least 100,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Reviews >= 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a rating of 4.5 or higher to the Instagram app and what is the average rating of these users?",
    "SQL": "SELECT COUNT(Rating), AVG(Rating) FROM playstore WHERE App = 'Instagram' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Find the average rating of apps in the 'Communication' category that have at least 100 reviews.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication' AND Reviews >= 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and how many of them are in the 'Tools' category?",
    "SQL": "SELECT COUNT(App), SUM(CASE WHEN Category = 'Tools' THEN 1 ELSE 0 END) AS ToolsCount FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the genres of apps with a rating greater than 4.0? List them along with the number of apps in each genre.",
    "SQL": "SELECT Genres, COUNT(App) FROM playstore WHERE Rating > 4.0 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized under 'Health & Fitness' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4 and what is their average number of reviews?",
    "SQL": "SELECT App, AVG(Reviews) FROM playstore WHERE Rating > 4 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Super Mario Bros.' game on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Super Mario Bros.'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and how many reviews does it have?",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating, COUNT(Reviews) AS Num_Reviews FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5, and what are their average reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Utilities' category and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Messenger' app in the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Messenger'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating greater than 4.0? List the names of these apps and their respective ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed the App 'Candy Crush Saga' and what is the average rating of the app?",
    "SQL": "SELECT COUNT(user_reviews.App), AVG(playstore.Rating) FROM user_reviews INNER JOIN playstore ON user_reviews.App = playstore.App WHERE user_reviews.App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Photo Editor & Collage' have and what is its average rating?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'Photo Editor & Collage'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and how many reviews do they have?",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average reviews and rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Reviews), AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and belong to the 'Family' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5 AND Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating greater than 4.5? Additionally, provide the average number of reviews for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Health & Fitness' category have a rating above 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Health & Fitness' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most installed apps and their installation counts?",
    "SQL": "SELECT App, Installs FROM playstore ORDER BY CAST(REPLACE(SUBSTR(Installs, 1, LENGTH(Installs) - 4), ',', '') AS INT) DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'Tools' category and have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is the average rating of that app?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 ORDER BY T1.Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Entertainment' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating in the 'Health & Fitness' category?",
    "SQL": "SELECT App, AVG(Rating) as Avg_Rating FROM playstore WHERE Category = 'Health & Fitness' GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and have received a positive sentiment review?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating > 4.5 AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative sentiment to the app 'Super Duper App'?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'Super Duper App' AND Sentiment_Polarity < 0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category with more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5.0 and what is the average rating of all apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating = 5.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is the average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write a SQL query that returns the number of apps that have received positive sentiment reviews and their average rating.",
    "SQL": "SELECT COUNT(DISTINCT T1.App), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings and number of reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Chrome' browser app on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Chrome'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Find the average rating of all apps that are categorized as 'Entertainment' and have more than 1,000 reviews.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Family' category have received a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Dropbox app and what is the average rating of these users?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Dropbox' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 4.5 and are categorized under 'Family'?",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.5 AND Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 highest rated apps in the 'Entertainment' category and their ratings?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Entertainment' ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is the average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews did the app 'Airbnb' receive? What is the average rating of this app?",
    "SQL": "SELECT SUM(Reviews), AVG(Rating) FROM playstore WHERE App = 'Airbnb'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications in the playstore have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating? And what is the average rating of that app?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and how many reviews does it have?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Avg_Rating, COUNT(T1.Reviews) AS Total_Reviews FROM playstore AS T1 GROUP BY T1.App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the names and genres of the top-rated apps in the 'Games' category?",
    "SQL": "SELECT App, Genres FROM playstore WHERE Category = 'Games' ORDER BY Rating DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4 and have at least 100,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4 AND Reviews >= 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Angry Birds' app have on the Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Angry Birds'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps that have received more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher? List the names and categories of these apps.",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and has received at least 10,000 reviews?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore WHERE Reviews >= 10000 ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category with at least 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews >= 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' category? What is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 on the Google Play Store? List the names of these apps.",
    "SQL": "SELECT COUNT(App), App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Temple Run' app and how many reviews it has received?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Temple Run'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.0 and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating > 4.0 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of the apps with the highest ratings?",
    "SQL": "SELECT Category FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Business' category? Additionally, list the number of apps in each sub-genre of 'Business'.",
    "SQL": "SELECT AVG(T1.Rating), T1.Genres, COUNT(T1.Genres) FROM playstore AS T1 WHERE T1.Category = 'Business' GROUP BY T1.Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps that are more than 100 MB in size?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Size > '100M'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category and how many of them have 5 reviews or more?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Tools' AND Reviews >= 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique categories are there in the Google Play Store?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are rated above 4.5 and have more than 1,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'Health & Fitness' category have a rating of 4.5 or higher? Provide their prices and the number of reviews for each.",
    "SQL": "SELECT App, Price, Reviews FROM playstore WHERE Category = 'Health & Fitness' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' category and have more than 10,000 reviews? List their average rating.",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Family' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have more than 500,000 installs?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Installs = '500,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and are of the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Facebook' app from the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are rated 4.5 or higher on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 1,000 reviews and what is the most popular genre among these apps?",
    "SQL": "SELECT AVG(Rating), Genres FROM playstore WHERE Reviews > 1000 GROUP BY Genres ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Pandora Music' app have and what is its average rating?",
    "SQL": "SELECT Reviews, AVG(Rating) FROM playstore WHERE App = 'Pandora Music'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app 'Facebook' from the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have received more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories are there in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest user rating? Provide the app's name and rating.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Rating = ( SELECT MAX(Rating) FROM playstore )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5.0 and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating = 5.0 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating? Provide the app name and its average rating.",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating > 4.5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category with a rating of 4.5 or higher? List the app names and their ratings for these apps.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'Tools' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated the app 'FitnessGenius' with a rating greater than 4.5 and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T1.Rating), AVG(T1.Rating) FROM playstore AS T1 WHERE T1.App = 'FitnessGenius' AND T1.Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Rating = ( SELECT MAX(Rating) FROM playstore WHERE Category = 'Tools' )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have more than 500,000 reviews? ",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category and how many such apps exist?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment review for the 'Uber' app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Uber' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating of 5.0 and what are the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating = 5.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and how many reviews does it have?",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating, COUNT(Reviews) AS Total_Reviews FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Productivity' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' category and have more than 5000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users who rated the 7 Minute Workout app with a rating above 4 have written a translated review?",
    "SQL": "SELECT COUNT(DISTINCT T2.Translated_Review) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = '7 Minute Workout' AND T1.Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 5000 reviews and are of type 'Free'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 5000 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 5000 reviews and belong to the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 5000 AND Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a rating of 5 for the 'Kingdoms of Amalthea' game?",
    "SQL": "SELECT COUNT(Rating) FROM playstore WHERE App = 'Kingdoms of Amalthea' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and are of type 'Free'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category with more than 50000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Family' category have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Reviews = ( SELECT MAX(Reviews) FROM playstore )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'Tools' category and have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written negative reviews for the 'Instagram' app?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Instagram' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many apps have a rating greater than 4?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Tools' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating > 4.5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and its category?",
    "SQL": "SELECT App, Category FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating = 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews on the Google Play Store?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which is the app with the highest average rating? And what is the average rating of that app?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its category?",
    "SQL": "SELECT App, Category FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) as Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment in their review for the app 'Candy Crush Saga'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Candy Crush Saga' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and belong to the 'Utilities' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5 AND Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews are there for the app 'Facebook'?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category and how many apps are there in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Find the average rating of apps in the 'Tools' category.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the FitnessPal app and what is its average rating?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'FitnessPal' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and how many user reviews do they have?",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category and how many of them have a rating greater than 4?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are available in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category with at least 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews >= 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique genres are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'Health and Fitness' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative review to the Headspace app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Headspace' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews and are of the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000 AND Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a neutral sentiment towards the Instagram app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Instagram' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Books and Reference' category have received more than 1000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Books and Reference' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Family' category have a rating above 4.5, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Family' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many distinct apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Snake' app have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Snake' AND Rating > 3.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The most popular app in the 'Health & Fitness' category based on the number of user reviews. How many user reviews does it have?",
    "SQL": "SELECT MAX(Reviews) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Facebook' app on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have a rating greater than 4? What is the average rating for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and how many reviews does it have?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating, COUNT(Reviews) AS Total_Reviews FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Candy Crush Saga' have on the Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category and how many of these apps have received more than 10,000 reviews?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(*) FROM playstore AS T1 WHERE T1.Category = 'Social' AND T1.Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Entertainment' category have received a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Entertainment' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app 'Facebook' and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are there in the 'playstore' database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive review for the app 'Instagram'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Instagram' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "how many users have a positive sentiment towards the app 'Candy Crush Saga' and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Saga' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and the total number of reviews for the app 'Bible'? ",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE App = 'Bible'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Candy Crush Saga' app and how many user reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are considered 'Family' content and have at least 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE `Content Rating` = 'Family' AND Reviews >= 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have been downloaded at least 1,000 times?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs >= '1,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app '7 Minute Workout' have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = '7 Minute Workout' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating > 4.5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most downloaded apps based on the number of installs?",
    "SQL": "SELECT App, Installs FROM playstore ORDER BY Installs DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 500,000 installs?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Bible Study Apps' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Bible Study Apps'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating of 4 or higher, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating >= 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average number of reviews?",
    "SQL": "SELECT AVG(Reviews), COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Casual' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Casual'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most reviewed apps in the 'Tools' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Find the average rating of apps that are 'Paid'",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating in the 'Lifestyle' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Lifestyle' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique users have reviewed the 'Netflix' app?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE App = 'Netflix'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many of them have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and the total number of reviews for the app 'Airbnb'?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE App = 'Airbnb'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and how many of these apps have a rating of 5? ",
    "SQL": "SELECT COUNT(App) , SUM(CASE WHEN Rating = 5 THEN 1 ELSE 0 END) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is the rating value?",
    "SQL": "SELECT App, AVG(Rating) as Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and have at least 1000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews >= 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is the rating?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most popular genres among apps with a rating greater than 4.5?",
    "SQL": "SELECT Genres FROM playstore WHERE Rating > 4.5 GROUP BY Genres ORDER BY COUNT(App) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps with more than 10,000 reviews on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive review for the app 'Facebook'? Include the average rating of the app.",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Facebook' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Entertainment' category with a rating above 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Entertainment' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average number of reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' category and have more than 500 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written negative reviews for the app 'Running Basics'? ",
    "SQL": "SELECT COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Negative' AND T1.App = 'Running Basics'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5, and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many such apps exist?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Medical' category with more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Medical' AND Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive and negative reviews does the Pok\u00e9mon Go app have and what is its rating on the Google Play Store?",
    "SQL": "SELECT COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) AS Positive_Reviews, COUNT(CASE WHEN T2.Sentiment = 'Negative' THEN 1 ELSE NULL END) AS Negative_Reviews, T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Pok\u00e9mon Go'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are categorized under 'Education'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive review for the Fitness App and what is its category on the Google Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), T1.Category FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Fitness App' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the Beauty and Self-Help app have and what is the average rating?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'Beauty and Self-Help'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Social' category have more than 50,000 reviews and are free?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Social' AND Reviews > 50000 AND Price = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular apps with the highest rating and how many reviews do they have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized under 'ENTERTAINMENT' and have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and are of the 'Utilities' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Utilities' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The average rating of apps that have more than 10,000 reviews on the Google Play Store.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating on the Google Play Store and what is the number of reviews for that app?",
    "SQL": "SELECT App, Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category with more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users with positive sentiment towards the RunKeeper app are there?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'RunKeeper' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the 'Candy Crush Saga' app on the Google Play Store and what is the average rating of these users?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Saga' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app that has the highest number of reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users with positive sentiment towards the Weather Underground app have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Weather Underground' AND T2.Sentiment = 'Positive' AND T1.Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have a rating above 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Tools' category with a rating higher than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social Networking' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social Networking'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews are there for the app 'Facebook' and what is the average rating of these reviews?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Instagram app?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'Instagram' AND Sentiment_Polarity > 0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories of apps are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Social' category have a rating higher than 4.0? Please list the names of these apps.",
    "SQL": "SELECT COUNT(App), App FROM playstore WHERE Category = 'Social' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5 and have at least 1000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews >= 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Family' category have a rating higher than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'One Piece' app have on the Google Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'One Piece'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Education' category have a rating above 4.5, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Education' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and how many of these are in the 'Communication' category?",
    "SQL": "SELECT COUNT(CASE WHEN Rating > 4.5 THEN 1 ELSE NULL END) as count, SUM(CASE WHEN Category = 'Communication' THEN 1 ELSE 0 END) as comm FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Maps' app and how many reviews it has received?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Maps'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 4.5 or higher and how many user reviews do they have?",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore WHERE Rating >= 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most rated apps in the playstore?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated the Ultimate Guitar app with a 5-star rating and what is its size?",
    "SQL": "SELECT COUNT(T1.Rating), T1.Size FROM playstore AS T1 WHERE T1.App = 'Ultimate Guitar' AND T1.Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category? How many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write a SQL query to find the number of apps that are of type 'Free' and have a rating greater than 4.0.",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Candy Crush Saga' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a negative sentiment towards the 'Super Mario' app and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Super Mario' AND T2.Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have been reviewed in the user_reviews table?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Candy Crush Saga' app and how many user reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 100 reviews and are of the type 'Free'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' database have a rating greater than 4.0 and are of type 'Free'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Game' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Utilities' category and have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'Utilities' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Family' category have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users reviewed the app 'RunKeeper' with a positive sentiment?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'RunKeeper' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular apps based on the number of reviews? Please include the app name and the number of reviews.",
    "SQL": "SELECT App, Reviews FROM playstore ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is the content rating of this app?",
    "SQL": "SELECT App, `Content Rating` FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and belong to the category of 'Family'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the top 10 most reviewed apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' ORDER BY Reviews DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4 and how many of these apps are of the 'Family' category?",
    "SQL": "SELECT COUNT(App) , COUNT(CASE WHEN Category = 'Family' THEN App ELSE NULL END) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Family' category that have more than 50,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category with more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have been rated at least 4.5 and have at least 100,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5 AND Reviews >= 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps with a rating greater than 4 have more than 1000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4 AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category with more than 100,000 user reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and how many reviews does it have?",
    "SQL": "SELECT App, Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received a rating of 4.5 or higher and have more than 100,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have at least 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews >= 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users had a positive sentiment towards the Duolingo app, and what was the average rating of these users?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Duolingo' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is the average rating of that app?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Utilities' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Utilities' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Health and Fitness' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Candy Crush Saga' app based on the user reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS avg_rating FROM playstore GROUP BY Category ORDER BY avg_rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their categories?",
    "SQL": "SELECT COUNT(App), Category FROM playstore WHERE Rating > 4.5 GROUP BY Category",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest user ratings and how many users have given each app a rating? Group the results by the app's rating.",
    "SQL": "SELECT App, COUNT(Reviews) AS NumberOfRatings FROM playstore GROUP BY Rating ORDER BY Rating DESC",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category and how many apps are in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Health & Fitness' category and have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'Health & Fitness' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or above and what are their average number of reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are marked as 'Free' on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and how many user reviews do they have?",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 and how many of them are free?",
    "SQL": "SELECT COUNT(App), COUNT(CASE WHEN Price = 'Free' THEN 1 ELSE NULL END) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative sentiment towards the Instagram app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Instagram' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the average rating of apps in the 'Social' category that have at least 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social' AND Reviews >= 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and total number of reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Tools' category? What is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have a rating higher than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category that have more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Facebook' have and what is its rating?",
    "SQL": "SELECT Reviews, Rating FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive sentiment to the app 'Running Paths'? What is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Running Paths' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the Google Play Store app with 5 stars and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T1.Rating), AVG(T1.Rating) FROM playstore AS T1 WHERE T1.App = 'Google Play Store' AND T1.Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different types of apps are there in the playstore? What are the average ratings of apps belonging to each type?",
    "SQL": "SELECT TYPE, AVG(Rating) FROM playstore GROUP BY TYPE",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that are classified as 'Family' or 'Tools' and how many users have given each of these apps 5 stars?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE Category IN ('Family', 'Tools') AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular apps based on the number of reviews? Include the average rating for each app.",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5 and what is the average number of reviews for these apps?",
    "SQL": "SELECT App, AVG(Reviews) FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'Paid' type and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received the highest rating and have more than 1,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore) AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Health and Fitness' category have received more than 500,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Health and Fitness' AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free to download?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Business'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4 and how many of these apps are of the 'Health and Fitness' genre?",
    "SQL": "SELECT COUNT(App), COUNT(CASE WHEN Genres = 'Health and Fitness' THEN 1 ELSE NULL END) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Instagram' have and what is its average rating?",
    "SQL": "SELECT COUNT(T2.Translated_Review), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Instagram' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and what are their average reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Productivity' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category with more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.5 and are of type 'Free'? How many of these apps have 'Family' as their content rating?",
    "SQL": "SELECT COUNT(App), COUNT(App) FROM playstore WHERE Rating > 4.5 AND Type = 'Free' AND 'Content Rating' = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Facebook' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are in the 'Business' category and have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Tools' category and have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of user reviews and what is the average rating of that app?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category with more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category with more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 1000 reviews and what is the count of such apps?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category? Please list their names and the average rating.",
    "SQL": "SELECT COUNT(App), AVG(Rating), App FROM playstore WHERE Category = 'Tools' GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "how many installs of the app weighing less than 10MB are available ?",
    "SQL": "SELECT SUM(CASE WHEN Size < '10M' THEN CAST(REPLACE(trim(Installs, ','), '+', '') AS INT) ELSE 0 END) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have? Please list the top 5 sentiments and their corresponding sentiment polarities.",
    "SQL": "SELECT COUNT(Reviews), Sentiment, Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Instagram' GROUP BY Sentiment, Sentiment_Polarity ORDER BY COUNT(Reviews) DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Business'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'PUBG Mobile' app and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'PUBG Mobile'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app '7 Minute Workout' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = '7 Minute Workout'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most reviewed apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Category = 'Tools' ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write a query to find the average rating of apps in the 'Social Networking' category.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social Networking'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Health and Fitness' category have been installed more than 1 million times?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Health and Fitness' AND Installs > '1,000,000'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating greater than 4.5 on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5.0 and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating = 5.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have a rating above 4.5, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.0 and have at least 50000 reviews? List the app names and their genres.",
    "SQL": "SELECT App, Genres FROM playstore WHERE Rating > 4.0 AND Reviews >= 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are classified as 'Family' under the 'Category' column and have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category with more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and how many reviews do they have?",
    "SQL": "SELECT App, SUM(Reviews) FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH AND FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is its sentiment in user reviews?",
    "SQL": "SELECT T1.App, T1.Rating, T2.Sentiment FROM playstore AS T1 JOIN user_reviews AS T2 ON T1.App = T2.App ORDER BY T1.Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category and how many apps are there in this category?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps received a rating above 4.5 and have more than 1,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have more than 1000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating higher than 4.0? What are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating > 4.0 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and are in the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the playstore have a rating higher than 4.5 and more than 1,000,000 reviews? Please list their app names, categories, and ratings.",
    "SQL": "SELECT App, Category, Rating FROM playstore WHERE Rating > 4.5 AND Reviews > 1000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many of them have more than 100,000 installs?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Tools' AND Installs > '100,000'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Games' category have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Games' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have more than 1000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4 and what is the average number of reviews for those apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'Business' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most reviewed apps on the Play Store?",
    "SQL": "SELECT App, Reviews FROM playstore ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 user reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have received a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category with more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and have been reviewed more than 10,000 times?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Health & Fitness' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a content rating of 'Everyone' and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE `Content Rating` = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and total number of reviews for the app 'Instagram'?",
    "SQL": "SELECT AVG(T1.Rating), SUM(T1.Reviews) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are in the 'Business' category and have more than 500,000 user reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Business' AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Books and Reference' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Books and Reference'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many apps are there?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the max rating of the playstore",
    "SQL": "SELECT max(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Productivity' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Health and Fitness' category have received a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Health and Fitness' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the 'playstore' table?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Productivity' category and have more than 5,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity' AND Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Instagram' app have in the playstore?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a 4-star rating to the app 'Instagram' and what is the average rating of 'Instagram'?",
    "SQL": "SELECT COUNT(Rating), AVG(Rating) FROM playstore WHERE App = 'Instagram' AND Rating = 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'MyFitnessPal' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'MyFitnessPal'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have more than 1000 reviews and what is their average rating?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have been reviewed in the user_reviews table?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category and how many apps are there in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users has left a positive review for the app 'Spotify Music' and what is the average rating of the app from users with positive reviews?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Spotify Music' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 5.0 and more than 100,000 reviews? Also, display the app's genres and the average sentiment polarity of user reviews for these apps.",
    "SQL": "SELECT T1.App, T1.Genres, AVG(T2.Sentiment_Polarity) as average_sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = 5.0 AND T1.Reviews > 100000 GROUP BY T1.App, T1.Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and belong to the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received positive sentiment in user reviews and what is their average rating?",
    "SQL": "SELECT COUNT(T1.App), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category with more than 100 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are of the 'Family' category and have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and are of the category 'HEALTH_AND_FITNESS'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many apps are there in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and how many reviews does it have?",
    "SQL": "SELECT App, AVG(Rating), COUNT(Reviews) FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.5 and what is the average rating for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have and what is its average rating?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their average reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have a rating greater than 4.5 on the Google Play Store?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and are of the 'Entertainment' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Facebook' app and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have been downloaded more than 5 million times?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '5,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 in the 'Utilities' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Utilities' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users hold a positive sentiment towards the 'Instagram' app on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Instagram' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Sports' category and have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Sports' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the playstore that have reviews greater than 500 and belong to the 'Tools' category?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Reviews > 500 AND Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have received more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have been rated 5.0 in the Google Play Store and their average user reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating = 5.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users had a positive sentiment towards the 'Memo' app, and what is the average rating of the app on the Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Memo' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have received over 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most reviewed apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many apps are there?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the 'playstore' table and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(DISTINCT App), AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category with more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category with more than 100,000 installs?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Installs > '100,000'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Books & Reference' category have a rating above 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Books & Reference' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category and what is the maximum number of reviews for any app in this category?",
    "SQL": "SELECT AVG(Rating), MAX(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Google Maps' have on the Google Play Store and what is the average rating for this app?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'Google Maps'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category with more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest average rating and how many reviews do they have?",
    "SQL": "SELECT App, AVG(Rating) as Avg_Rating, Reviews FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 and are free to download?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Price = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and how many have a rating of less than 4.5?",
    "SQL": "SELECT COUNT(App), COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 and what are the categories of these apps?",
    "SQL": "SELECT COUNT(App), Category FROM playstore WHERE Rating > 4.5 GROUP BY Category",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Entertainment' category have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Entertainment' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and what is the average number of reviews they have received?",
    "SQL": "SELECT App, AVG(Reviews) AS Avg_Reviews FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given positive reviews for the 'Airbnb' app, and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Airbnb' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category with at least 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education' AND Reviews >= 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating of 4.5 or higher and have at least 1000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5 AND Reviews >= 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE Category = 'Tools' GROUP BY Reviews",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and have been installed more than 5 million times?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Installs > '5000000'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and what is their average review count?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many of them are rated 5?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Play Store apps that have been installed more than 1 million times?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '1,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive sentiment for the app 'Candy Crush Saga'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Candy Crush Saga' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Entertainment' category have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Entertainment' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and belong to the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free' AND Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 100,000 installs?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Installs > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Productivity' category with more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a content rating of 'Everyone' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE 'Content Rating' = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique reviews does the app 'Chromium' have, and what is the average rating for these reviews?",
    "SQL": "SELECT COUNT(DISTINCT Reviews), AVG(Rating) FROM playstore WHERE App = 'Chromium'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Social' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Airbnb' have on the Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Airbnb'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have more than 10,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App) , AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Find the app with the highest average rating from the 'playstore' table.",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of user reviews and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category that have a rating greater than 4? Please provide the average number of reviews for these apps.",
    "SQL": "SELECT AVG(Reviews), COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and how many reviews does it have?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating, SUM(Reviews) AS Total_Reviews FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 1000 reviews on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and have more than 100,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating), COUNT(Reviews) FROM playstore GROUP BY App ORDER BY COUNT(Reviews) DESC, AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Family' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Games' category and have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Games' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Instagram' app and how many reviews it has received?",
    "SQL": "SELECT AVG(T1.Rating), T1.Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and belong to the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users with a high positive sentiment towards the app 'Graveyard Keeper' have downloaded the app more than 500 times?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Graveyard Keeper' AND T1.Installs > '500+' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Racing' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Racing'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 3 categories of apps with the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) as AvgRating FROM playstore GROUP BY Category ORDER BY AvgRating DESC LIMIT 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Health and Fitness' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Find the average rating of apps that have received more than 500 reviews and are classified as 'Tools' or 'Business' category.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 500 AND Category IN ('Tools', 'Business')",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' category and have received ratings higher than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Social' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 50,000 reviews and are of type 'Free'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 50000 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher? Please list the app names and their respective ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many reviews do they have in total?",
    "SQL": "SELECT AVG(T1.Rating), SUM(T1.Reviews) FROM playstore AS T1 WHERE T1.Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many such apps exist?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps received the highest rating and how many reviews do they have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category that have more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating > 4.5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating of 4.5 or above in the 'Family' category and what is their average number of reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Category = 'Family' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest user ratings and what are their respective genres?",
    "SQL": "SELECT App, Genres FROM playstore ORDER BY Rating DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is the number of reviews for that app?",
    "SQL": "SELECT App, AVG(Rating), SUM(Reviews) FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive review for the app 'Candy Crush Saga' and what is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Saga' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have left positive reviews for the app 'Candy Crush Saga'?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Saga' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category with more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Educational' category on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Educational'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Facebook' have and what is its average rating?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave the 7 Minute Workout app a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE App = '7 Minute Workout' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0 and what are their average number of reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Entertainment' category and have a rating greater than 4.0? Also, provide the average rating for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Entertainment' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest user ratings and what are the average reviews per user?",
    "SQL": "SELECT App, AVG(Reviews) FROM playstore WHERE Rating = ( SELECT MAX(Rating) FROM playstore )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5.0 and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating = 5.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating and show one user review with the highest sentiment polarity?",
    "SQL": "SELECT T1.Category, AVG(T1.Rating), T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App ORDER BY AVG(T1.Rating) DESC, ABS(T2.Sentiment_Polarity) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 500,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Education' category have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Education' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Medical and Health' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Medical and Health'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a negative review for the app 'Capture It'? How many of these reviews were found to be subjective?",
    "SQL": "SELECT COUNT(T1.Rating), COUNT(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Capture It' AND T2.Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category with more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many apps have a rating higher than 4?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Tools' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category that have more than 100,000 reviews on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher, and how many of these apps are in the 'Family' category?",
    "SQL": "SELECT COUNT(App), COUNT(CASE WHEN Category = 'Family' THEN App ELSE NULL END) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have received more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the most apps with a rating greater than 4.5?",
    "SQL": "SELECT Category FROM playstore WHERE Rating > 4.5 GROUP BY Category ORDER BY COUNT(App) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Communication'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and what is their average number of reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and how many of them are of the 'Finance' category?",
    "SQL": "SELECT COUNT(App), COUNT(CASE WHEN Category = 'Finance' THEN 1 ELSE NULL END) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category? Also, provide the average rating of these apps.",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app received the highest user sentiment in the positive category and what was the average rating for that app?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' ORDER BY COUNT(T2.Sentiment) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Education' category that have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Education' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.0 and have at least 10,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0 AND Reviews >= 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' category that have more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive sentiment towards the app 'Spotify Music'?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Spotify Music' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category and how many reviews do they have in total?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average number of reviews and ratings for apps in the 'Family' category on the Google Play Store?",
    "SQL": "SELECT AVG(Reviews), AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating according to user reviews?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Avg_Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are in the 'Entertainment' category and have a rating greater than 4?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Entertainment' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which categories of apps have the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY Category ORDER BY Avg_Rating DESC LIMIT 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4 and how many user reviews do they have?",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and the number of reviews for the app 'Candy Crush Saga'?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5? List the average number of reviews for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category and how many of them are 5-star rated?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Health & Fitness' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have a rating higher than 4.5 and what is the average size of these apps?",
    "SQL": "SELECT COUNT(DISTINCT App), AVG(Size) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category and how many users have given 5-star ratings for these apps?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Social' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Books and Reference' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Books and Reference'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most reviewed apps on the Play Store, and how many reviews do they have?",
    "SQL": "SELECT App, Reviews FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4 and what is the average review count for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the most popular genre of apps on the play store?",
    "SQL": "SELECT Genres FROM playstore GROUP BY Genres ORDER BY COUNT(App) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 on the Google Play Store and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App) , AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the app 'Photo Editor' with a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(Rating) FROM playstore WHERE App = 'Photo Editor' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category and how many users have reviewed these apps?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and what is the average rating for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated the 'Photo Editor' app with a 4-star rating and how many users rated it with a 5-star rating?",
    "SQL": "SELECT SUM(CASE WHEN Rating = 4 THEN 1 ELSE 0 END) AS FourStarRatings, SUM(CASE WHEN Rating = 5 THEN 1 ELSE 0 END) AS FiveStarRatings FROM playstore WHERE App = 'Photo Editor'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have a rating greater than 4.5 in the 'playstore' table?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category and how many of them have more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'Family' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users who gave a positive review for the Chrome app and what is the average rating of those reviews?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Chrome' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and are free to download?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Price = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Entertainment' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Entertainment' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category and how many apps are there in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Health & Fitness' category have more than 1000 reviews and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have a rating greater than 4.5 on the Google Play Store?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are classified as 'Family' in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category and how many such apps are there?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their categories?",
    "SQL": "SELECT COUNT(App), Category FROM playstore WHERE Rating > 4.5 GROUP BY Category",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 and are free?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Price = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular apps based on the number of reviews?",
    "SQL": "SELECT App, Reviews FROM playstore ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that are categorized as 'Entertainment'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different types of apps are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Type) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Candy Crush Saga' game have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating and what is the average rating?",
    "SQL": "SELECT Category, AVG(Rating) as avg_rating FROM playstore GROUP BY Category ORDER BY avg_rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and the number of reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating on the Google Play Store?",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Entertainment' category have a rating above 4.5 and more than 1,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Entertainment' AND Rating > 4.5 AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have received at least 100 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Reviews >= 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and belong to the 'Productivity' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and what are their genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating >= 4.5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive review for the Instagram app and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Instagram' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have over 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category that have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating of apps that are categorized as 'Utilities'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the top 100 apps with the highest number of reviews?",
    "SQL": "SELECT AVG(Rating) FROM ( SELECT Rating FROM playstore ORDER BY Reviews DESC LIMIT 100 )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and how many user reviews do they have?",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4 or higher and have been installed on more than 1,000,000 devices?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4 AND Installs > '1,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average reviews and ratings for the top 5 games that have the most user reviews?",
    "SQL": "SELECT AVG(Reviews), AVG(Rating) FROM playstore WHERE Category = 'Games' ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and number of reviews for the 'Forest: Sleep Timer' app?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Forest: Sleep Timer'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Lifestyle' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.5 and belong to the 'Entertainment' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews on the Google Play Store?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have left a positive review for the app 'BlueStacks App Player' and what is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'BlueStacks App Player' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating in the 'Tools' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health & Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating above 4.5 and at least 100,000 reviews? Provide the app name, rating, and number of reviews.",
    "SQL": "SELECT App, Rating, Reviews FROM playstore WHERE Rating > 4.5 AND Reviews >= 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and what is their average number of reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a neutral sentiment towards the Sleep as Android app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Sleep as Android' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category with more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and how many have a rating below 5?",
    "SQL": "SELECT COUNT(CASE WHEN Rating = 5 THEN 1 ELSE 0 END) as '5 Star Apps', COUNT(CASE WHEN Rating < 5 THEN 1 ELSE 0 END) as 'Below 5 Star Apps' FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and what is the average review count for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Super Mario Run' app in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Super Mario Run'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that belong to the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Facebook' app and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Health & Fitness' category and have a rating greater than 4.5? Also, list the top 3 apps with the highest rating in this category.",
    "SQL": "SELECT COUNT(App), App FROM playstore WHERE Category = 'Health & Fitness' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Play Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Play Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are marked as 'Free' on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category that have more than 1,000 reviews? Also, list the app names that meet this criteria.",
    "SQL": "SELECT AVG(T1.Rating), T1.App FROM playstore AS T1 WHERE T1.Category = 'Family' AND T1.Reviews > 1000 GROUP BY T1.App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are priced at $1.99?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '$1.99'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category that have received more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive and negative reviews does the app 'Candy Crush Saga' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Candy Crush Saga' AND Sentiment IN ('Positive', 'Negative')",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Who is the app developer for 'Instagram'?",
    "SQL": "SELECT 'Developer' FROM playstore WHERE App='Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and how many user reviews do they have?",
    "SQL": "SELECT COUNT(App), SUM(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Calculator' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Calculator'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Health and Fitness' category and have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Health and Fitness' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5? Also, list the category of each app.",
    "SQL": "SELECT COUNT(App), Category FROM playstore WHERE Rating > 4.5 GROUP BY Category",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category and how many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the '7 Minute Workout' app have?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = '7 Minute Workout' AND Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different apps have positive sentiment in user reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  }
]