[
  {
    "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 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": "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 are 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 there in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps that have received at least 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews >= 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most rated apps from the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have more than 500 reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS AvgRating FROM playstore GROUP BY Category ORDER BY AvgRating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the different genres of apps in the playstore?",
    "SQL": "SELECT DISTINCT Genres FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 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 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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 'Tools' category with 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 applications in the 'playstore' table have a 'Content Rating' of 'Everyone'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE 'Content Rating' = 'Everyone'",
    "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 received positive reviews according to their sentiment analysis?",
    "SQL": "SELECT DISTINCT T2.App FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T1.Sentiment = 'Positive' LIMIT 1",
    "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": "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?",
    "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 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the average rating of all applications in the playstore?",
    "SQL": "SELECT AVG(Rating) 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": "How many reviews does the app 'Facebook' have according to the playstore table?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "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": "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 apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the names of the apps with a rating of 4.5 or higher?",
    "SQL": "SELECT DISTINCT App 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 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 '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 '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 in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many 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 apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "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": "How many unique categories are 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 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are present in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the 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 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "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": "Which apps in the playstore have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized under 'Family'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received positive reviews and have a rating higher than 4?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' AND T1.Rating > 4",
    "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 '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 '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?",
    "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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most rated apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average number of reviews for apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Reviews) 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": "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": "How many unique applications are there 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 have more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 5000",
    "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 all apps in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the genres with the highest average rating?",
    "SQL": "SELECT Genres, AVG(Rating) as AvgRating FROM playstore GROUP BY Genres ORDER BY AvgRating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'playstore' table have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 highest-rated apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 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": "Which 5 apps have the highest rating and what is their average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category on 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 '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 'Books and Reference' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Books and Reference'",
    "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": "How many user reviews are there for the app 'Rovio Roller Coaster Safari'?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Rovio Roller Coaster Safari'",
    "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": "Which apps have received a rating greater than 4.0 and have a 'Content Rating' of 'Everyone'?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND `Content Rating` = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Tools'",
    "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 positive reviews does the app 'U Launcher Prime' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE Sentiment = 'Positive' AND App = 'U Launcher Prime'",
    "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 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are available in the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many distinct apps have been reviewed in the 'playstore' database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 '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 '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 playstore?",
    "SQL": "SELECT AVG(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 user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write a SQL query to find the average rating of all apps in the 'playstore' table.",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in each category according to the playstore table?",
    "SQL": "SELECT Category, COUNT(App) FROM playstore GROUP BY Category",
    "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 apps have been reviewed by users?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews",
    "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 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest average rating and how many user reviews do they 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 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 '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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have 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 '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": "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": "Which apps have a rating above 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average reviews and ratings of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Reviews), AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5? Generate the list along with their genres.",
    "SQL": "SELECT App, Genres FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating in the 'playstore' table?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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": "How many apps are there in the playstore that 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 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 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 received positive sentiment in user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "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": "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 user rating in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'playstore' table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "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.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "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 have reviewed an app with a positive sentiment?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE 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 highest 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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews does the app 'Instagram' have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Instagram'",
    "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 'Photo Editor' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Photo Editor'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS AverageRating FROM playstore GROUP BY Category ORDER BY AverageRating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique applications are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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": "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 '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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest user reviews?",
    "SQL": "SELECT DISTINCT App FROM playstore ORDER BY Reviews DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'playstore' table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Instagram'?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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": "How many apps are in the 'Family' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family'",
    "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": "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 category of apps have 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 all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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": "How many different genres are present in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps in the playstore that have a rating higher than 4?",
    "SQL": "SELECT Category FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for apps with a rating higher than 4.5?",
    "SQL": "SELECT COUNT(T1.Translated_Review) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.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 '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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) 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": "How many apps have a rating higher than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating of the apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 are the names of all apps in the 'playstore' database that have a rating greater than 4?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the different content ratings of apps in the playstore?",
    "SQL": "SELECT DISTINCT `Content Rating` FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a positive sentiment in the user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a positive sentiment in user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "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": "How many apps have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Minecraft Pocket Edition' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Minecraft Pocket Edition'",
    "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 all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 'Utilities' category?",
    "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?",
    "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?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'playstore' database that are categorized as 'ENTERTAINMENT'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "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 average ratings of the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 in the playstore have more than 500,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Reviews > 500000",
    "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 are 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 are the most popular categories of apps on the Google Play Store?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY COUNT(App) DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 highest rated apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are classified as 'Education' in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are present in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "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 are 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 user reviews are there for the app 'Instagram'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the Play Store?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 'Finance' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Finance'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a sentiment of 'Positive' in user reviews?",
    "SQL": "SELECT DISTINCT T1.App 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": "How many distinct apps are there in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have more than 5000 reviews?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Google Maps' have in the playstore?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Google Maps'",
    "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 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Facebook' have according to the playstore database?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5 in the playstore?",
    "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 the 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": "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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are present in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT Genres) 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 that have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews are there 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 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are associated with the app 'Instagram'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Instagram' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Instagram' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "how many apps in the playstore have more than 5000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many distinct apps are in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most popular apps based on reviews?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most rated apps in the 'Communication' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Communication' ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed the application 'Instagram'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Instagram'",
    "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?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "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": "How many positive reviews are there for the app 'Facebook' in the user_reviews table?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Facebook' 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": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Instagram' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Instagram' 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 in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "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": "How many user reviews are there for the app 'Instagram'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the different categories of apps available in the playstore?",
    "SQL": "SELECT 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": "How many reviews does the app 'Facebook' have on the playstore?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "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 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 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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table 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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 are the average ratings 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 are the average ratings 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?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "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": "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 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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Reviews) 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 reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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 apps are in the 'playstore' table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a sentiment of 'Positive' in the user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average reviews for applications in the 'Games' category?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Games'",
    "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 are the average ratings of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and the number of reviews for each genre in the playstore?",
    "SQL": "SELECT AVG(Rating), Reviews, Genres FROM playstore GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 rated apps in the Play Store?",
    "SQL": "SELECT App 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 on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "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": "What are the different categories of apps available on the playstore?",
    "SQL": "SELECT DISTINCT Category FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'Tools' category on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique genres are in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "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": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT 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 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 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 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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 average ratings of apps in the 'Social Networking' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social Networking'",
    "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": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a sentiment of 'Positive'?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which of the following genres has the highest average rating?",
    "SQL": "SELECT Genres, AVG(Rating) AS avg_rating FROM playstore GROUP BY Genres ORDER BY avg_rating DESC LIMIT 1",
    "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 average ratings of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews are there for the app 'Instagram'?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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 all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average user ratings 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 the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are 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 user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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 '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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews does the app 'Facebook' have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "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": "What are the average rating and the number of reviews for the playstore apps?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore",
    "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 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "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 are the top 5 highest rated apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 'Tools' category?",
    "SQL": "SELECT 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": "Which app has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have 50,000 or more reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews >= 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are present 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": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications are available in the 'Tools' category?",
    "SQL": "SELECT 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 different genres of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the different categories of apps available in the playstore?",
    "SQL": "SELECT DISTINCT Category FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 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": "How many user reviews does the 'Google Maps' application have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Google Maps'",
    "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": "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 are the average rating and total number of reviews for each app category in the playstore?",
    "SQL": "SELECT Category, AVG(Rating), SUM(Reviews) FROM playstore 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 have a content rating of 'Everyone' and at least 1000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE `Content Rating` = 'Everyone' AND Reviews >= 1000",
    "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 in the category 'Games'? ",
    "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?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "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 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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "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": "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 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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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": "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 are the average ratings and the number of reviews for each category in the playstore?",
    "SQL": "SELECT AVG(Rating) , Reviews , Category FROM playstore 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": "Which app has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 apps with the highest ratings?",
    "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 '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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 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": "What are the categories of apps with a rating greater than 4.0?",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Rating > 4.0",
    "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 in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps with a rating greater than 4.5?",
    "SQL": "SELECT DISTINCT Category 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 '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 all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'playstore' database?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'com.example.app' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'com.example.app'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average sentiment polarity?",
    "SQL": "SELECT App FROM user_reviews GROUP BY App ORDER BY AVG(Sentiment_Polarity) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 '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 'Tools' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Tools' ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a content rating of 'Everyone' and have received positive reviews?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.`Content Rating` = 'Everyone' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are 'Paid'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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": "How many apps are in the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "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 the 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": "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 '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": "How many reviews does the app 'Yelp' have in the playstore?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Yelp'",
    "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": "How many user reviews are there for each app?",
    "SQL": "SELECT App, COUNT(Translated_Review) FROM user_reviews GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are categorized as 'GAME'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 that have more than 5000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 5000",
    "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": "Which apps have a rating higher than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and how many reviews does it have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most popular apps in the 'Family' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Family' ORDER BY Reviews DESC LIMIT 10",
    "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": "Which apps have a rating higher than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'playstore' table?",
    "SQL": "SELECT COUNT(*) FROM playstore",
    "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 all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the playstore database?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "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": "How many reviews does the app 'Super Mario Bros.' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Super Mario Bros.'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 4.5 or higher?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating >= 4.5",
    "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": "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 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular apps based on the number of reviews?",
    "SQL": "SELECT App 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": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received negative reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5? ",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'",
    "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": "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 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 the apps in the 'Top Paid' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Top Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed the app 'Instagram'?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Instagram'",
    "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 are the top 10 apps with the highest reviews?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Top Free' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Top Free'",
    "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 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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of 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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps in the playstore?",
    "SQL": "SELECT DISTINCT Category FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating above 4.5 and at least 10,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews >= 10000",
    "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 unique apps are there in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 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 all apps in the 'playstore' database?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app with the highest rating in the playstore?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = (SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the average rating of apps in the category of 'utilities'",
    "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?",
    "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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'App Name' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'App Name'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews have a sentiment polarity of more than 0.5?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment_Polarity > 0.5",
    "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 are the average rating and the number of reviews for each category in the playstore?",
    "SQL": "SELECT AVG(Rating), Reviews, Category FROM playstore GROUP BY Category",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the most apps in the playstore?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY COUNT(App) 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 the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the genres of apps that have a rating greater than 4.5?",
    "SQL": "SELECT Genres FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications in the 'playstore' table have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are available in the Playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest rating in the 'playstore' table?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which application has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY 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": "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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app \"Instagram\" have in the playstore table?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have both positive and negative reviews?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE App IN (SELECT App FROM user_reviews WHERE Sentiment = 'Positive') AND App IN (SELECT App FROM user_reviews WHERE Sentiment = '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": "What is the average rating of apps in the 'Educational' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Educational'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write an SQL query to find all unique genres in the playstore database",
    "SQL": "SELECT DISTINCT Genres FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are there in the playstore dataset?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "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 are the top 5 most rated apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 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 are the most common genres of apps in the playstore?",
    "SQL": "SELECT Genres FROM playstore GROUP BY Genres ORDER BY COUNT(*) 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.0 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Business'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have positive sentiment reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE 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 'Business' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Business'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received the highest rating in the playstore?",
    "SQL": "SELECT DISTINCT App 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": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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 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 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 apps with the highest average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have more than 100,000 reviews and what are their average ratings?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Reviews > 100000 GROUP BY App",
    "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 are the top 5 apps with the highest average sentiment polarity score?",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) AS Avg_Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Avg_Sentiment_Polarity DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 user reviews are there for each app in the playstore?",
    "SQL": "SELECT App, COUNT(Translated_Review) FROM user_reviews GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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 apps have received positive reviews?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews exist for the app 'Instagram'?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the playstore have received the most positive reviews?",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN (SELECT App, COUNT(Sentiment) as Positive_Count FROM user_reviews WHERE Sentiment = 'Positive' GROUP BY App) AS T2 ON T1.App = T2.App ORDER BY T2.Positive_Count 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.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "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": "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 priced under $10?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price < '$10'",
    "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 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": "How many apps are in the 'playstore' table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "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 user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table 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 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Productivity'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Social'",
    "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 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 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": "Which apps have received more than 100 reviews?",
    "SQL": "SELECT App FROM playstore WHERE 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 '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 '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": "How many reviews does the app 'Facebook' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are present in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many distinct apps are there in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have positive reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received the highest number of reviews?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Category' 'Family'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "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 are 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": "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.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating in the 'playstore' table?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews does the app 'Facebook' have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "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 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating higher than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive sentiment reviews are there for the app 'Instagram'?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Instagram' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Play Store'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Play Store'",
    "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 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "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": "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": "How many distinct apps have positive reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have been reviewed in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are available on the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have both positive and negative reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive' AND App IN (SELECT App FROM user_reviews WHERE Sentiment = 'Negative')",
    "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": "SQL query to fetch all apps from the playstore table that have a rating greater than 4.5",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Facebook' have according to the playstore database?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "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": "Which category 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": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT DISTINCT App 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": "How many apps are there in the playstore table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "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 all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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": "Which apps have a rating greater than 4.0 and have more than 50,000 user reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND Reviews > 50000",
    "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 rows in the playstore table",
    "SQL": "SELECT COUNT(*) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 'Category' 'Tools'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Instagram'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore are classified as 'Family' and have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "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": "what is the average rating of apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "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": "How many reviews does the app 'Example App' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Example App'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average number of reviews for apps in the 'Games' category?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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": "Which category 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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and how many reviews does it have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "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 average reviews for the apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "how many apps in the play store have positive sentiment in user reviews ?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews does the app 'Spotify Music' have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Spotify Music'",
    "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 different genres are present in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the app 'Super Calculator'?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Super Calculator'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "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 the apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "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": "Which categories of apps have 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 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Super Mario Bros'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Super Mario Bros'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many distinct apps are in the 'user_reviews' table?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and number of reviews for apps in the 'Lifestyle' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest ratings 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 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": "Which app has the highest rating on the Play Store?",
    "SQL": "SELECT App 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": "Find the average rating 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 average rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "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 user reviews do the apps with a rating greater than 4 have?",
    "SQL": "SELECT COUNT(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 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 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 '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?",
    "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 all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different app genres 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 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 4.5 or higher?",
    "SQL": "SELECT App FROM playstore WHERE 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": "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": "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": "How many unique apps are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and have received more than 10,000 reviews?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.5 AND Reviews > 10000",
    "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": "Find the average rating of all apps in the 'playstore' table.",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "SQL query to list the apps with their rating and content rating that have a sentiment of 'Positive'",
    "SQL": "SELECT DISTINCT T1.App, T1.Rating, T1.`Content 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": "Which apps have received the highest user reviews in the 'Tools' category?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'Tools' AND Reviews = (SELECT MAX(Reviews) FROM playstore WHERE Category = 'Tools')",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and are free?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.5 AND Type = 'Free'",
    "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 number of apps in the 'Entertainment' genre with a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Genres = 'Entertainment' AND 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": "what is the most common sentiment for reviews for the app 'com.noshufou.android.su'?",
    "SQL": "SELECT Sentiment FROM user_reviews WHERE App = 'com.noshufou.android.su' GROUP BY Sentiment ORDER BY COUNT(Sentiment) 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 '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 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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": "Which apps have received a rating of 5 and have a user review sentiment of 'Positive'?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating = 5 AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different types of apps are available on the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Type) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what are the names of apps that have more than 100 reviews",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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 '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 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'YourAppName'?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'YourAppName'",
    "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 in the playstore?",
    "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 play store?",
    "SQL": "SELECT AVG(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 are there in the 'playstore' table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "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 different categories of apps available on the playstore?",
    "SQL": "SELECT 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": "How many apps in the 'playstore' table have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average user ratings for games in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Genres = 'Games'",
    "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 user reviews do the top 5 rated apps in the play store have?",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE App IN (SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5)",
    "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 are the average rating 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": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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": "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": "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 have positive reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest average rating and what is their average rating?",
    "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 in the 'playstore' database have a rating above 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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 '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?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are available for each app in the playstore database?",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Play' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Play'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Top Grossing' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Top Grossing'",
    "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 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 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 average rating?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories of apps are available in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "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 apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "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": "How many apps are there in the playstore table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "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": "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": "How many distinct 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 all the apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "how many apps have more than 50,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 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": "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 '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 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 'Free'",
    "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?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 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 '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?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have 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 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 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'ENTERTAINMENT' category in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "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 are 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": "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 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": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT 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 are 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 '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 app has the highest rating in the 'playstore' table?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "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": "How many user reviews are there for the 'Facebook' app?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "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 are available in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write an SQL query to retrieve the number of apps in each category from the playstore table.",
    "SQL": "SELECT Category, COUNT(App) FROM playstore GROUP BY Category",
    "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": "What is the average rating of the 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 the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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": "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?",
    "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 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received the highest ratings on the Google Play Store?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 10",
    "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 are there in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 app has the highest user 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 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 'Top Apps' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Top Apps'",
    "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 average ratings of 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 the apps in the 'Game' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Game'",
    "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 different apps are available in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) 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 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average user ratings of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received 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 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 'Paid' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Paid'",
    "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 apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app with the highest rating have?",
    "SQL": "SELECT Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "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": "Which apps have a rating greater than 4 and what is the average number of reviews for those apps?",
    "SQL": "SELECT App, AVG(Reviews) FROM playstore WHERE Rating > 4 GROUP BY App",
    "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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "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": "How many user reviews are there for the app 'Instagram'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews have a positive sentiment?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Facebook'",
    "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 higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews does the app 'Instagram' have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 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 have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "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": "Which apps have a rating of 4.5 or higher?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE 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": "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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories of apps are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in each genre on the Play Store?",
    "SQL": "SELECT Genres, COUNT(App) FROM playstore GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are there in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings 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 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 apps with the highest ratings?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 5",
    "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": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS AvgRating FROM playstore GROUP BY Category ORDER BY AvgRating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized as 'Family'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Family'",
    "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 are the average reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews does the app 'Minecraft Pocket Edition' have in the playstore?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Minecraft Pocket Edition'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5 and have a Sentiment of 'Positive'?",
    "SQL": "SELECT DISTINCT p.App FROM playstore p JOIN user_reviews u ON p.App = u.App WHERE p.Rating > 4.5 AND u.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 10 most reviewed apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have positive sentiment reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 5 and more reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating = 5 AND Reviews >= 1",
    "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": "How many user reviews are there for the app 'Minecraft'? ",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Minecraft'",
    "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 are the average rating and number of reviews for apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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 'Family' category on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are paid?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price != 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating of 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?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "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": "How many unique apps are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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": "Which Apps have negative sentiment in user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating 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 user reviews have a positive sentiment?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE 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": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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": "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": "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 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 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "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 app 'Facebook' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5 and how many user reviews do they have?",
    "SQL": "SELECT COUNT(Reviews) AS Total_Reviews, COUNT(App) AS Total_apps FROM playstore WHERE Rating > 4.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": "Which app has the highest rating in the 'playstore' table?",
    "SQL": "SELECT App 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 FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a review for the app 'Google Maps'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Google Maps'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Google Chrome' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Google Chrome' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps that have a rating greater than 4?",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE 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": "How many unique apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most common genres of apps in the playstore?",
    "SQL": "SELECT Genres FROM playstore GROUP BY Genres ORDER BY COUNT(*) DESC LIMIT 1",
    "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": "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 received positive reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE 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 are 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 different genres are available in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT DISTINCT App 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 of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "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 app has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "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 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a content rating of 'Everyone' and have more than 5000 reviews?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE 'Content Rating' = 'Everyone' AND Reviews > 5000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most common content ratings for apps in the playstore?",
    "SQL": "SELECT DISTINCT `Content Rating` FROM playstore GROUP BY `Content Rating` ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique 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 '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 user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 apps with the highest reviews?",
    "SQL": "SELECT DISTINCT App FROM playstore ORDER BY Reviews DESC LIMIT 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": "How many user reviews are there for the app 'Facebook'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Facebook'",
    "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": "Which apps have a rating of 5.0?",
    "SQL": "SELECT App FROM playstore WHERE Rating = 5.0",
    "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 unique apps are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "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 reviews does the app 'Facebook' have in the playstore?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different types of apps are 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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are available for the app 'Instagram'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Instagram'",
    "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": "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 are the average rating and number of reviews for apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'Family'",
    "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 '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 have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 rated apps in the Play Store?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 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": "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 '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 user reviews does the app 'Instagram' have?",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps in the playstore with more than 1000 reviews?",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings 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 playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating 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": "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": "How many different apps have negative reviews?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM user_reviews WHERE Sentiment = 'Negative'",
    "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": "Which apps have received positive reviews in the 'user_reviews' table?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average number of reviews for apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Productivity' category in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Productivity'",
    "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 '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?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in each category in the playstore?",
    "SQL": "SELECT Category, COUNT(App) FROM playstore 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 unique categories are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Instagram' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Instagram'",
    "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 more than 10,000 reviews in the 'playstore' table?",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Play Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Play Games'",
    "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 received more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 50000",
    "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 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 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 available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) 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 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 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Facebook' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Facebook' AND Sentiment = 'Positive'",
    "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 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 have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the genres of apps in the playstore that have received a rating higher than 4.5?",
    "SQL": "SELECT Genres FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating in the play store?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the average rating of 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 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 '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 '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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received positive reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "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 '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 are in the 'Games' category?",
    "SQL": "SELECT COUNT(App) 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": "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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' database?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 user reviews are there for the app 'Instagram'?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different apps are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews do the top 5 rated apps have?",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE App IN (SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating of 5.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received the highest average rating according to the playstore table?",
    "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?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "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 '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 '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 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Family'",
    "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": "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?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "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": "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 apps have received more than 10,000 reviews and have a rating greater than 4?",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 10000 AND 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 reviews does the app 'Temple Run' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Temple Run'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Find 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 all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "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 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 apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest sentiment polarity and what are their sentiments?",
    "SQL": "SELECT DISTINCT T1.App, T1.Sentiment, T1.Sentiment_Polarity FROM user_reviews AS T1 ORDER BY Sentiment_Polarity DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are there in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different types of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Type) FROM playstore",
    "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 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 '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 all apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 'Educational' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Educational'",
    "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 '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?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  }
]