[
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the BH Mission Playbook app?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'BH Mission Playbook'",
    "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 the playstore applications?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The average rating of apps in the 'AUTO_AND_VEHICLES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'",
    "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 the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Diario Financiero' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Diario Financiero'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'TRAVEL_AND_LOCAL' category in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "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 'Eversense' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Eversense'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a positive sentiment in their user reviews?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'FOOD_AND_DRINK' category have a rating above 4?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FOOD_AND_DRINK' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Best Car Sounds' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'BEST CAR SOUNDS'",
    "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 all apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are there for the app 'Hotstar'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Hotstar'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'ASOS' app have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'ASOS' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which travel and local app has the highest rating?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most common sentiment in the user reviews for 'Blinkist - Nonfiction Books'?",
    "SQL": "SELECT Sentiment FROM user_reviews WHERE App = 'Blinkist - Nonfiction Books' GROUP BY Sentiment ORDER BY COUNT(Sentiment) 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 games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Homescapes' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Homescapes' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all tools in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating for apps in the Family category?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Itau bank' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Itau bank'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the ES File Explorer have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'ES File Explorer'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Sports' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the travel and local category apps?",
    "SQL": "SELECT DISTINCT `Content Rating` FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "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 a negative sentiment in user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Negative'",
    "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 category of the app 'e-Anatomy'?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'e-Anatomy'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'COMMUNICATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all paid applications in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "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 '8 Ball Pool' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = '8 Ball Pool'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'SOCIAL' category have a rating greater than 4.3?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'SOCIAL' AND Rating > 4.3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app 'Thumbnail Maker'?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Thumbnail Maker'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 3.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 3.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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does 'DV-2019 PHOTO TOOL' belong to?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'DV-2019 PHOTO TOOL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed CBS Sports Fantasy with a positive sentiment?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'CBS Sports Fantasy' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EVENTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'",
    "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 negative reviews does the Candy Crush Soda Saga have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Candy Crush Soda Saga' AND 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": "What is the average rating of apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "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 category does the app candy crush soda saga belong to?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Candy Crush Soda Saga'",
    "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 positive reviews does the app 'Hopper - Watch & Book Flights' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Hopper - Watch & Book Flights' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'PARENTING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Cat Sim Online: Play with Cats app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Cat Sim Online: Play with Cats' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'SHOPPING' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'SHOPPING'",
    "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 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 positive reviews does 'Google Photos' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Google Photos' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'TOOLS' category with a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of weather apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'WEATHER'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the DATING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have 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 games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the size and minimum number of downloads of all free android games in the playstore with rating more than 4.0?",
    "SQL": "SELECT min(Installs), Size FROM playstore WHERE Type = 'Free' AND Rating > 4.0 GROUP BY Size",
    "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": "How many reviews does the 'Cake Shop - Kids Cooking' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Cake Shop - Kids Cooking'",
    "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 in the 'HEALTH_AND_FITNESS' category have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'TRAVEL_AND_LOCAL' category have a rating greater than 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Tools' category have?",
    "SQL": "SELECT COUNT(*) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'TOOLS' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write a query to find the apps with 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 genres are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rated photography app on the Play Store?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PHOTOGRAPHY' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all photography apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the photography category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "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 are there in the 'TOOLS' category with a rating higher than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 app 'Facebook Ads Manager'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Facebook Ads Manager'",
    "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": "Which apps have the highest ratings in the Google Play store?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Cooking Fever app have?",
    "SQL": "SELECT SUM(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE 0 END) as Positive_Reviews FROM user_reviews WHERE App = 'Cooking Fever'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most reviewed apps in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app 'Pacifica - Stress & Anxiety'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Pacifica - Stress & Anxiety'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'BEAUTY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BEAUTY'",
    "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 productivity apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'NEWS_AND_MAGAZINES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'FOX NOW - On Demand & Live TV' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'FOX NOW - On Demand & Live TV' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of books and reference apps on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Books & Reference'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all sports apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the sports games on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most popular category in the playstore based on the number of reviews?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY SUM(Reviews) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'CA UIM Mobile'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'CA UIM Mobile'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.0 and what are their categories?",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ART_AND_DESIGN' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Jigsaw Puzzles Bus Scania BF' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Jigsaw Puzzles Bus Scania BF'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'NEWS_AND_MAGAZINES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all applications in the 'AUTO_AND_VEHICLES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most expensive app in the 'TOOLS' category?",
    "SQL": "SELECT App, Price FROM playstore WHERE Category = 'TOOLS' AND Price != 'Free' AND Price != '0' ORDER BY Price DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most common type of content rating in the playstore?",
    "SQL": "SELECT `Content Rating` FROM playstore GROUP BY `Content Rating` ORDER BY COUNT(`Content 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 is the average rating of the playstore applications?",
    "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 all apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Weather' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'WEATHER'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'BUSINESS' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Blogger' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Blogger' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Flat Pack' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Flat Pack'",
    "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": "How many positive reviews does the Golf GPS Rangefinder: Golf Pad app have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Golf GPS Rangefinder: Golf Pad' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which game has the highest user rating?",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(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' table?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'playstore' table have?",
    "SQL": "SELECT SUM(Reviews) 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 HEALTH_AND_FITNESS category have in total?",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are available for the 'Aab e Hayat Full Novel'?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Aab e Hayat Full Novel'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category 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 is the average rating of apps in the 'LIBRARIES_AND_DEMO' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore",
    "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 games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all educational apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games on the playstore with a price greater than $1?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Price > '$1'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the app 'Ancestry' have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Ancestry' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "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 app with the most reviews",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating?",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the chess game for kids have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Chess for Kids - Play & Learn' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'PERSONALIZATION' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'AUTO_AND_VEHICLES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app 'Nusenda CU\u2013 Mobile Banking'",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Nusenda CU\u2013 Mobile Banking'",
    "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 highest rating of any app in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the WEATHER category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'WEATHER'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 'HOUSE_AND_HOME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most popular app in the 'HOUSE_AND_HOME' category based on the number of reviews?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HOUSE_AND_HOME' 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 positive reviews does the 'Cy-Ranch' app have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Cy-Ranch' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the sports games available in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "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 positive reviews does the app 'Fishdom' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Fishdom' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'SAY-U'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'SAY-U'",
    "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 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 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FOOD_AND_DRINK' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Weather Crave' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Weather Crave'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Anthem BC Anywhere' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Anthem BC Anywhere' 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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the TRAVEL_AND_LOCAL category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the '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 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'DRAGON BALL LEGENDS' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'DRAGON BALL LEGENDS' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'House and Home' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the app name with the highest review count in playstore",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'PERSONAL' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'PERSONAL'",
    "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 paid apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does 'Hangouts' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Hangouts' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does the app 'Footej Camera' belong to?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Footej Camera'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the playstore have more than 5 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'FarmersOnly Dating' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'FarmersOnly Dating'",
    "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 negative reviews does the Gboard - the Google Keyboard have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Gboard - the Google Keyboard' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does 'The Game of Life' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'The Game of Life'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the CK \u521d\u4e00 \u5341\u4e94 app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'CK \u521d\u4e00 \u5341\u4e94'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does 'Easy Cv maker 2018' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Easy Cv maker 2018' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'BUSINESS' category in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Asteroids 3D live wallpaper' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Asteroids 3D live wallpaper' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'ColorNote Notepad Notes' have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'ColorNote Notepad Notes' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app ESPN have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'ESPN' AND Sentiment = 'Positive'",
    "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 in the playstore have a rating above 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the app 'BG Cricket'?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'BG Cricket'",
    "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 Personalization category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "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": "How many reviews does the app 'Annonces.ci' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Annonces.ci'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What category does the HTC Sense Input-AR app belong to in the playstore?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'HTC Sense Input-AR'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative sentiment in the user reviews for the LINE Launcher app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment = 'Negative' AND App = 'LINE Launcher'",
    "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 positive reviews does the playstore app have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'News & Magazines' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'News & Magazines'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does the app 'RadPad: Apartment Finder App' belong to?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'RadPad: Apartment Finder App'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Agar.io app have?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'Agar.io' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Fallout Shelter' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Fallout Shelter' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'A.J. Green Wallpapers 4 Fans' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'A.J. Green Wallpapers 4 Fans'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app 'AK 47 Guns Wallpaper'?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'AK 47 Guns Wallpaper'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the communication category apps on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "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 highest rating of an app in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'AP Flashcards' app on the Playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'AP Flashcards'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps that have a rating greater than 4.0?",
    "SQL": "SELECT Category FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'DATING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Travel and Local' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the GasBuddy app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'GasBuddy: Find Cheap Gas' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of sports apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the Scientific Calculator Free app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Scientific Calculator Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which tool with the highest rating in the Play Store has the most user reviews?",
    "SQL": "SELECT T1.App FROM playstore AS T1 JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'TOOLS' ORDER BY T1.Rating DESC, T1.Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews do 'CNN Breaking US & World News' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'CNN Breaking US & World News' AND Sentiment = 'Positive'",
    "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": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating of more 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 'AUTO_AND_VEHICLES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Egg, Inc.' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Egg, Inc.'",
    "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 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the HD Widgets app have?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'HD Widgets' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the number of reviews for the app 'BK Formula Calculator 2'?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'BK Formula Calculator 2'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest-rated app in the 'BUSINESS' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' 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 positive reviews does the app 'File Viewer for Android' have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'File Viewer for Android' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of Disney Crossy Road?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Disney Crossy Road'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most common 'Content Rating' in the playstore table?",
    "SQL": "SELECT `Content Rating` FROM playstore GROUP BY `Content Rating` ORDER BY COUNT(`Content Rating`) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating among games in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the DATING category on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PARENTING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the size of the app ScriptSave WellRx Rx Discounts?",
    "SQL": "SELECT Size FROM playstore WHERE App = 'ScriptSave WellRx Rx Discounts'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the names of all the apps 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 paid sports apps are there in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Paid' AND Category = 'SPORTS'",
    "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 rating of the 'CJ Browser - Fast & Private' app from the 'playstore' table?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'CJ Browser - Fast & Private'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rated medical app in the playstore?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'FINANCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does 'Experian - Free Credit Report' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Experian - Free Credit Report' AND Sentiment = 'Positive'",
    "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": "Which apps have positive reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the BH Connect app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'BH Connect'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'BF Movies Fun' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'BF Movies Fun'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore app 'Couch to 10K Running Trainer'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Couch to 10K Running Trainer'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the applications in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app that has the highest number of reviews?",
    "SQL": "SELECT Category FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating given to the app 'Scale Models DB'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Scale Models DB' 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": "How many reviews does the app 'Extreme Coupon Finder' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Extreme Coupon Finder'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many videos can be played with the app 'Video Player HD'?",
    "SQL": "SELECT COUNT(DISTINCT Translated_Review) FROM user_reviews WHERE App = 'Video Player HD'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have downloaded the app 'Duet'?",
    "SQL": "SELECT SUM(CAST(REPLACE(trim(Installs, '+'), ',', '') AS int)) FROM playstore WHERE App = 'Duet'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which tools apps have a rating higher than 4.0?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore are categorized as 'HOUSE_AND_HOME'?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'R\u00e1dio Sol Nascente DF' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'R\u00e1dio Sol Nascente DF'",
    "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": "What is the average rating of apps in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Talabat: Food Delivery app on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Talabat: Food Delivery'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of applications 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 games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many family apps are there in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Ex Quotes' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Ex Quotes'",
    "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 'G-NetWiFi Pro' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'G-NetWiFi Pro'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the 'General culture' app?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'General culture'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the game 'Agar.io' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Agar.io' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app with the highest number of reviews?",
    "SQL": "SELECT Category FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications are in the 'NEWS_AND_MAGAZINES' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Google Maps' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Google Maps'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'BGKontakti London BG Kontakti' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'BGKontakti London BG Kontakti'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Puzzle' genre in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Puzzle%'",
    "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 all apps in the 'Travel and Local' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'DATING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of dating apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the 'EW Gate' app on the playstore?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'EW Gate'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are categorized as 'Negative'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the app with the highest rating in the 'FINANCE' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "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 category has the most applications 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 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 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Yidio: TV Show & Movie Guide' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Yidio: TV Show & Movie Guide'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the app 'Dino War: Rise of Beasts'?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'Dino War: Rise of Beasts'",
    "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": "What is the average rating of all apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have negative sentiment reviews in the playstore?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Negative' AND App IN (SELECT DISTINCT App FROM playstore)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does 'AC Mobile Control' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'AC Mobile Control' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the app '8 Ball Pool' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = '8 Ball Pool' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does 'News: DW Hausa' belong to in the Playstore?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'News: DW Hausa'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Beauty Camera - Selfie Camera have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment = 'Positive' AND App = 'Beauty Camera - Selfie Camera'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app 'Weather' in the playstore?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Weather'",
    "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 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 1",
    "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": "What is the average rating of dating apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 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 fitness apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the DATING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Casinos & Gambling' category have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE Category = 'CASINOS & GAMBLING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does the app 'FO BOULANGER' belong to?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'FO BOULANGER'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of free games in the Family category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'VH1' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'VH1'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app in the 'Communication' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app with the most positive reviews?",
    "SQL": "SELECT Rating FROM playstore WHERE App = (SELECT App FROM user_reviews WHERE Sentiment = 'Positive' GROUP BY App ORDER BY COUNT(Sentiment) DESC LIMIT 1)",
    "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 app has the highest rating in the playstore?",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)",
    "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": "Which applications have a positive sentiment in their 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 apps are in the ENTERTAINMENT category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the free games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app with the category 'NEWS_AND_MAGAZINES' have?",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the playstore have a rating greater than 4?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the game 'Fo Fo Fish'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Fo Fo Fish'",
    "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": "Which family app has the highest rating?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'Klara weather'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Klara weather'",
    "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 '8fit Workouts & Meal Planner' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = '8fit Workouts & Meal Planner' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free games are in the FAMILY category with a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the maximum number of reviews for any app in the playstore?",
    "SQL": "SELECT max(Reviews) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of sports games on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app '100+ C Programs'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = '100+ C Programs'",
    "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 'WEATHER' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'WEATHER'",
    "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": "How many apps are there in the 'MAPS_AND_NAVIGATION' category?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'",
    "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 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "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": "Which app has a negative review with a polarity less than -0.3?",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Negative' AND T2.Sentiment_Polarity < -0.3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Contacts' app have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Contacts' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the Maps & Navigation category have in the playstore?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'",
    "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 is the highest rating of an app in the 'BUSINESS' category?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating of a dating app in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does the app 'Hopper - Watch & Book Flights' belong to?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Hopper - Watch & Book Flights'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the LIFESTYLE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Wallpapers FN F2000' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Wallpapers FN F2000'",
    "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 Google Keep app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Google Keep' AND Sentiment = 'Positive'",
    "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": "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 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 rating of the app 'Turnotronik CL'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Turnotronik CL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 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 'DATING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'CE Airbus' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'CE Airbus'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the app name and its content rating for the app 'DT'?",
    "SQL": "SELECT App, `Content Rating` FROM playstore WHERE App = 'DT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of the apps in the COMMUNICATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app with the highest rating in the playstore?",
    "SQL": "SELECT Category FROM playstore WHERE Rating = (SELECT MAX(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 the playstore applications?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of weather apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'WEATHER'",
    "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 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the FINANCE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are classified as Positive in the 'playstore' database?",
    "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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'DATING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games have received a positive sentiment in user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive' AND App IN (SELECT App FROM playstore WHERE Category = 'GAME')",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'NEWS_AND_MAGAZINES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "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 'Google Play' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Google Play'",
    "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 all games in the playstore?",
    "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 '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 PERSONALIZATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rated app in the playstore with at least 1,000,000 installs?",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '1,000,000+' AND Rating = ( SELECT MAX(Rating) FROM playstore )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the LIBRARIES_AND_DEMO category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the health and fitness apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the Sports category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all medical apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "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 photography apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Lifestyle' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Lifestyle'",
    "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": "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 highest content rating for apps in the 'playstore' table?",
    "SQL": "SELECT MAX(`Content Rating`) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'LIBRARIES_AND_DEMO' category in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all social network apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "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 the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Who has received the most reviews on the app store?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which is the most popular app category in terms of total reviews?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY SUM(Reviews) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating of apps in the 'AUTO_AND_VEHICLES' category?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'",
    "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 content rating for the app V-CUBE Seminar Mobile?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'V-CUBE Seminar Mobile'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SHOPPING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 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 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 dating apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "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": "Which apps have a rating greater than 4?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'ZEDGE\u2122 Ringtones & Wallpapers' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'ZEDGE\u2122 Ringtones & Wallpapers'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Cool Reader' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Cool Reader'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all medical apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative review for the app with the highest rating?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment = 'Negative' AND App IN (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 rating of the 'Bu Hangi Firma?' app from the playstore?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Bu Hangi Firma?'",
    "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 games in the 'Casino' genre have a rating of 4.5 or higher?",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Genres = 'Casino' AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of BT Church in the playstore?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'BT Church'",
    "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": "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 received a 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 the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Fruits Bomb' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Fruits Bomb' AND Sentiment = 'Positive'",
    "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 do users have for the app 'Candy Pop Story'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Candy Pop Story' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FOOD_AND_DRINK' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the DATING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of sports apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'ART_AND_DESIGN' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the app 'Be A Legend: Soccer' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Be A Legend: Soccer' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all finance apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "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 'ART_AND_DESIGN' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Ah Ha Block' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Ah Ha Block'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the fertility app 'Fertility Friend Ovulation App' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Fertility Friend Ovulation App'",
    "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 the app 'Facetune - Ad Free'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Facetune - Ad Free'",
    "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 in the playstore have a 'Business' category and no ratings? How many such apps are there?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'BUSINESS' AND Rating IS NULL",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest rating and what is their category?",
    "SQL": "SELECT App, Category FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'DATING' category on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the game 'Home Street \u2013 Home Design Game' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE Sentiment = 'Negative' AND App = 'Home Street \u2013 Home Design Game'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the Health & Fitness category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Health & Fitness'",
    "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 positive reviews does Adobe Acrobat Reader have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Adobe Acrobat Reader' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Dictionary - WordWeb app have?",
    "SQL": "SELECT COUNT(*) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Dictionary - WordWeb' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app `FAHREDD\u0130N er-R\u00c2Z\u0130 TEFS\u0130R\u0130` and what is the sentiment of its user reviews?",
    "SQL": "SELECT T1.Genres, T2.Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'FAHREDDIN er-R\u00c2ZI TEFS\u0130R\u0130'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the ART_AND_DESIGN category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "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 that have been downloaded more than 5,000 times?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '5,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'DATING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which educational apps have a rating higher than 4.0?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the DATING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the PRODUCTIVITY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the app with the highest rating?",
    "SQL": "SELECT `Content Rating` FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the app Fresh EBT - Food Stamp Balance?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Fresh EBT - Food Stamp Balance'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 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 'Clash Royale' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Clash Royale'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore applications?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'COMMUNICATION' category?",
    "SQL": "SELECT COUNT(*) 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 the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Travel and Local' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app 'Candy Crush Jelly Saga'?",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'Candy Crush Jelly Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated 'FK Rad' app more than 1 review?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'FK Rad' AND Reviews > 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 reviews does the 'Weather forecast' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Weather forecast'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Travel and Local' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Dr. Panda Restaurant 2' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Dr. Panda Restaurant 2'",
    "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 Sports category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'db.Mobil App' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'db.Mobil App'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the playstore with content rating 'Teen'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE `Content Rating` = 'Teen'",
    "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 positive reviews does the 'Anatomy Learning - 3D Atlas' app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Anatomy Learning - 3D Atlas' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FINANCE' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most popular video player app in the playstore based on the number of reviews?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'VIDEO_PLAYERS' ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of books and reference apps on the Google Play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Books & Reference'",
    "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 AX Player -Nougat Video Player have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'AX Player -Nougat Video Player'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews do we have for 'Checkers \u2714\ufe0f'?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE Sentiment = 'Negative' AND App = 'Checkers \u2714\ufe0f'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the photography category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the game 'Dog Sim Online: Raise a Family' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Dog Sim Online: Raise a Family'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'iScore5 AP Psych' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'iScore5 AP Psych'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the playstore with a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Barbie\u2122 Fashion Closet' app have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Barbie\u2122 Fashion Closet' AND Sentiment = 'Positive'",
    "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 'Map My Ride GPS Cycling Riding' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Map My Ride GPS Cycling Riding'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which library and demo app has the highest rating?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What category is the app 'DM \u05d4\u05e4\u05e7\u05d5\u05ea'?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'DM \u05d4\u05e4\u05e7\u05d5\u05ea'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of games are available in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore WHERE Category = 'GAME'",
    "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 health and fitness applications in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EVENTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'",
    "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 'SHOOTING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOOTING'",
    "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 products are there in the playstore table?",
    "SQL": "SELECT COUNT(App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps are in the Photography category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Type = '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": "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 PERSONALIZATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of paid apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'NEWS_AND_MAGAZINES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "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 number of reviews for the app 'BS TRACK CLIENT'?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'BS TRACK CLIENT'",
    "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 'FAMILY' category in the playstore?",
    "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 playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'FK Radnicki Nis' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'FK Radnicki Nis'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'EDUCATION' category have a rating of 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'EDUCATION' AND Rating = 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of shopping apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "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 all educational apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Florida 511' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Florida 511'",
    "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 photography apps in the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of books and reference apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the BEAUTY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BEAUTY'",
    "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 '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 PHOTOGRAPHY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the meditation studio app?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'Meditation Studio'",
    "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 is the average rating of books and reference apps in the Google Play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Books & Reference'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app with the highest rating in the 'playstore' table?",
    "SQL": "SELECT Category FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'COMICS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMICS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of dating apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'F-Stop Gallery' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'F-Stop Gallery'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which categories are 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 FOOD_AND_DRINK category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) as Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app 'Offline Maps & Navigation' in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Offline Maps & Navigation'",
    "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 product rating of the 'Ultimate Calculator for CR' app?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Ultimate Calculator for CR'",
    "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 Gmail have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Gmail'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Hot Wheels: Race Off app have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Hot Wheels: Race Off' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'MAPS_AND_NAVIGATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore applications?",
    "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 greater than 4.0 in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the content rating of the app that has the most reviews",
    "SQL": "SELECT `Content Rating` FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have downloaded the 'Helix Jump' app?",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE App = 'Helix Jump'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the LIFESTYLE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps 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 EDUCATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does the 'Community by C Space' app belong to?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Community by C Space'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest positive sentiment in user reviews?",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' ORDER BY T2.Sentiment_Polarity DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most common content rating for games in the playstore?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE Category = 'GAME' GROUP BY `Content Rating` ORDER BY COUNT(`Content Rating`) DESC LIMIT 1",
    "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 all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most common sentiment for user reviews of the 'Health and Nutrition Guide' app?",
    "SQL": "SELECT Sentiment FROM user_reviews WHERE App = 'Health and Nutrition Guide' GROUP BY Sentiment ORDER BY COUNT(Sentiment) DESC LIMIT 1",
    "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 'Granny' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Granny'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'NEWS_AND_MAGAZINES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'FANDOM for: DC' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'FANDOM for: DC'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Calorie Counter - MyNetDiary app have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Calorie Counter - MyNetDiary' AND Sentiment = 'Positive'",
    "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 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH AND FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH AND FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HOUSE_AND_HOME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "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": "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": "What is the average rating of the app with the highest number of reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = (SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 500,000 reviews in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the photo apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Photography'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games have a content rating of 'Teen'?",
    "SQL": "SELECT App FROM playstore WHERE 'Content Rating' = 'Teen' AND Type = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Best CG views' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Best CG views'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games on the Google Play Store?",
    "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": "How many paid apps are in the playstore?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Paid'",
    "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 reviews and ratings of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Reviews), AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews are there for the app 'BBVA Spain'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'BBVA Spain' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which social apps have the highest ratings?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'SOCIAL' 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 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 all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'DW Audio'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'DW Audio'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app 'Quiz for Clash Royale\u2122'?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Quiz for Clash Royale\u2122'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 in the playstore table?",
    "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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the '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": "Which app has the highest user rating?",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category of the app 'Cordova BG Geolocation'?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Cordova BG Geolocation'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rated app in the FINANCE category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' ORDER BY Rating DESC LIMIT 1",
    "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": "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 highest rated app in the health and fitness category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' 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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of productivity apps on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FINANCE' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FINANCE'",
    "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 all the games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'EVENTS' category and have a non-null rating?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'EVENTS' AND Rating IS NOT NULL",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'TOOLS' category have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating of an app in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which family apps have a rating above 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.5",
    "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": "How many reviews does the app 'Mukwonago AH' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Mukwonago AH'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the sentiment of the review for 'Duolingo: Learn Languages Free'?",
    "SQL": "SELECT Sentiment FROM user_reviews WHERE App = 'Duolingo: Learn Languages Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'converter video to mp3' have?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'converter video to mp3' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "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 family app has the highest rating?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' 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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "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 the 'Pok\u00e9mon TV' app in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Pok\u00e9mon TV'",
    "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 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'travel_and_local' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "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 positive reviews does the app 'Cooking Channel' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Cooking Channel' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the different genres in the playstore app table?",
    "SQL": "SELECT DISTINCT Genres FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HOUSE_AND_HOME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the app 'Video Status'?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'Video Status'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all sports games on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "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 finance apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the playstore app 'Temple Run 2'?",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'Temple Run 2'",
    "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 app has the most reviews?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'Baseball Boy!' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Baseball Boy!' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a neutral sentiment in user reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "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 DATING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games have a rating above 4.5?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4",
    "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 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative sentiment reviews are there for EasyBib: Citation Generator?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'EasyBib: Citation Generator' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which is the most popular app among users according to the number of reviews?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews do the 'Add Text To Photo' app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Add Text To Photo' AND Sentiment = 'Positive'",
    "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 reviews does the app 'TV.AE' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'TV.AE'",
    "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 medical apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "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 the app 'Movie DB' in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Movie DB'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the TRAVEL_AND_LOCAL category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "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 maximum rating of games in the 'GAME' category?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category does 'weather HD' fall under in the playstore?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'weather HD'",
    "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 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "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": "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 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 category of the app 'Tomo A.i. Pet Chat Bot'?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Tomo A.i. Pet Chat Bot'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'CWT To Go' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'CWT To Go' 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 'FINANCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games are in the 'GAME' category and have more than 10,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Reviews > 10000",
    "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 shopping apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'Ay Y\u0131ld\u0131z Duvar Ka\u011f\u0131tlar\u0131'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Ay Y\u0131ld\u0131z Duvar Ka\u011f\u0131tlar\u0131'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the medical apps in the play store?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL' LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average number of reviews and ratings for all apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Reviews), AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What category is 'FE Civil Engineering Exam Prep' in the playstore?",
    "SQL": "SELECT Category FROM playstore WHERE App = 'FE Civil Engineering Exam Prep'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games have a rating greater than 4.0?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIBRARIES_AND_DEMO' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ART_AND_DESIGN' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Duolingo app have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Duolingo: Learn Languages Free' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews does the app 'Sway Medical' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Sway Medical'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of medical apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'YouTube Kids' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'YouTube Kids' AND Sentiment = 'Positive'",
    "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 different app 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 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": "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 in the 'playstore' table?",
    "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 Photography category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all medical apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "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 medical apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the rating of the app 'The wall' in the playstore ?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'The wall'",
    "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 all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have no rating?",
    "SQL": "SELECT App FROM playstore WHERE Rating IS NULL",
    "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' table?",
    "SQL": "SELECT AVG(Rating) 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 reviews does the app 'CB Trader' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'CB Trader'",
    "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 highest average rating of apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the content rating of the game 'Escaping the Prison'?",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'Escaping the Prison'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the USPS MOBILE\u00ae app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'USPS MOBILE\u00ae'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have positive reviews in the 'user_reviews' table?",
    "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 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'EzCalculator' have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'EzCalculator' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are available in the 'FAMILY' category?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'FAMILY'",
    "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": "How many apps are in the 'FINANCE' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of books and reference apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Books & Reference'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app '10 Best Foods for You' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = '10 Best Foods for You' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Camera FV-5 Lite app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Camera FV-5 Lite'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'ESLock File Recovery Lite' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'ESLock File Recovery Lite'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed the app 'Golden Dictionary (EN-AR)'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Golden Dictionary (EN-AR)'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of dating apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the max rating of apps in the dating genre",
    "SQL": "SELECT max(Rating) FROM playstore WHERE Genres = 'Dating'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does 'Bubble Witch 3 Saga' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Bubble Witch 3 Saga' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'HTC Weather' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'HTC Weather' AND Sentiment = 'Positive'",
    "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 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 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'DK Readers' in the playstore?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'DK Readers'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Blinkist - Nonfiction Books' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Blinkist - Nonfiction Books'",
    "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 all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "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 positive reviews does the app 'Fly Delta' have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Fly Delta' AND Sentiment = 'Positive'",
    "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": "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 games in the playstore have a rating above 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of news and magazines apps in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating among all categories?",
    "SQL": "SELECT Category, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY Category ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Calorie Counter - Macros' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Calorie Counter - Macros'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the Texas Bar-B-Q Rewards have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Texas Bar-B-Q Rewards'",
    "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 apps have a content rating of 'Everyone' and have at least 10,000,000 installs?",
    "SQL": "SELECT App FROM playstore WHERE 'Content Rating' = 'Everyone' AND Installs = '10,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of events applications in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps are in the Family category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'AlReader -any text book reader' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'AlReader -any text book reader' 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": "Which apps have both a rating greater than 4 and a negative user sentiment?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating > 4 AND T2.Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating received by any app in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app in the playstore has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app 'Helix Jump' and what is the average rating of all apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(T2.Rating), T1.Genres FROM playstore AS T1 INNER JOIN playstore AS T2 ON T1.Category = T2.Category WHERE T1.App = 'Helix Jump' AND T2.Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews do you have for the Sway Medical app?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Sway Medical' AND Sentiment = 'positive'",
    "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 reviews does the app with category 'FAMILY' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games have a rating greater than 4.2?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.2 AND Category = 'GAME'",
    "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 is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the playstore app 'MARVEL Strike Force' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'MARVEL Strike Force'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of 'FANDOM: Arrow and The Flash' on the Play Store?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'FANDOM: Arrow and The Flash'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the MEDICAL category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the most popular medical app in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL' AND Installs = (SELECT MAX(Installs) FROM playstore WHERE Category = 'MEDICAL')",
    "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 apps have a rating greater than 4?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'DATING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews do Candy Crush Saga have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Candy Crush Saga' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SHOPPING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "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 '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 games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are available in the Play Store?",
    "SQL": "SELECT COUNT(App) 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 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 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications in the playstore are of the category 'GAME'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME'",
    "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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app LEADS FA have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'LEADS FA'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Eyewitness Travel Phrase Book' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Eyewitness Travel Phrase Book'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the playstore with a content rating of 'Everyone'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE `Content Rating` = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most common sentiment expressed in user reviews for the app 'Gyft - Mobile Gift Card Wallet'?",
    "SQL": "SELECT Sentiment FROM user_reviews WHERE App = 'Gyft - Mobile Gift Card Wallet' 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 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of weather apps in the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'WEATHER'",
    "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 playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app with the highest average rating?",
    "SQL": "SELECT Genres 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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PERSONALIZATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the BBWCupid - BBW Dating App have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'BBWCupid - BBW Dating App' AND Sentiment = 'Negative'",
    "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 the 'Analog Clock AW-7' app from the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Analog Clock AW-7'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the genres of the app 'Ay Y\u0131ld\u0131z Duvar Ka\u011f\u0131tlar\u0131'?",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'Ay Y\u0131ld\u0131z Duvar Ka\u011f\u0131tlar\u0131'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The Congregation app has what rating?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'BMH-BJ Congregation'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the photography category in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.0 and have positive user reviews?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating > 4.0 AND T2.Sentiment = 'Positive'",
    "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 does the app 'Fancy' have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Fancy'",
    "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 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TRAVEL_AND_LOCAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BZ Berner Zeitung E-Paper' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'BZ Berner Zeitung E-Paper'",
    "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 paid apps are available in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the MAPS_AND_NAVIGATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the VIDEO_PLAYERS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Crunchyroll - Everything Anime' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Crunchyroll - Everything Anime'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games are in the playstore?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all sports apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "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 the 'Dezeen Magazine RSS Reader' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Dezeen Magazine RSS Reader'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the total number of reviews for all apps in the 'playstore' table?",
    "SQL": "SELECT SUM(Reviews) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher 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 'PARENTING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SHOPPING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FAMILY' category with a rating of 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 games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'All Mental disorders' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'All Mental disorders' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'FK' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'FK'",
    "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": "How many negative reviews does the app CATS: Crash Arena Turbo Stars have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'CATS: Crash Arena Turbo Stars' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Game of Thrones: Conquest\u2122' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Game of Thrones: Conquest\u2122'",
    "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 users have downloaded the ByssWeather for Wear OS app?",
    "SQL": "SELECT Installs FROM playstore WHERE App = 'ByssWeather for Wear OS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'FAMILY' category have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.0",
    "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": "Which apps have both a rating greater than 4 and at least 100,000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4 AND Reviews >= 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating for a video player in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games in the 'Casual' genre have a rating greater than 4.0?",
    "SQL": "SELECT App FROM playstore WHERE Genres = 'Casual' AND 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": "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 can I find the number of apps with a rating greater than 3 in the playstore table?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating > 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have no reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Reviews = 0",
    "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 all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the playstore have?",
    "SQL": "SELECT SUM(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE 0 END) FROM user_reviews",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive review for the 'Book of AK-47'?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Book of AK-47' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of 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 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "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 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the app 'DRAGON BALL LEGENDS' have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'DRAGON BALL LEGENDS' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app 'Beautiful Widgets Pro' and how many positive reviews does it have?",
    "SQL": "SELECT T1.Genres, SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) AS Positive_Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Beautiful Widgets Pro'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'The Secret Daily Teachings' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'The Secret Daily Teachings'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all paid apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SHOPPING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "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 'HOUSE_AND_HOME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "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 available in the Travel and Local category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the most reviewed app from the playstore ",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have negative sentiment reviews in the playstore?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app in the playstore 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 all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'COMICS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMICS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table are rated higher than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does 'Galaxy Attack: Alien Shooter' have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment = 'Positive' AND App = 'Galaxy Attack: Alien Shooter'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'WEATHER' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'WEATHER'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the game category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does 'POCKET ATLAS OF CT HEAD' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'POCKET ATLAS OF CT HEAD'",
    "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 games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the game 'Super Hero M Craft Run' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Super Hero M Craft Run'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the app 'Blossom Blast Saga' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Blossom Blast Saga' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating on the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY 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 in the 'LIFESTYLE' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app with the highest rating in the playstore?",
    "SQL": "SELECT Genres FROM playstore ORDER BY Rating DESC LIMIT 1",
    "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 all medical applications in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PERSONALIZATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many games are there in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME'",
    "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 both a positive user sentiment and a rating above 4.0?",
    "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.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'DATING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which family app has the highest rating?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the total number of positive reviews for the \"Doctor Pets\" app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Doctor Pets' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is the average rating for that app?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the most popular game app on the playstore?",
    "SQL": "SELECT App FROM playstore WHERE Genres = 'Games' AND Rating > 4 ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating and number of reviews for the app 'DN.VR' in the 'playstore' table?",
    "SQL": "SELECT Rating, Reviews FROM playstore WHERE App = 'DN.VR'",
    "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 in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Holy Quran Mehmet Emin Ay' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Holy Quran Mehmet Emin Ay'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the 'playstore' table?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "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 'Opera Mini - fast web browser' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Opera Mini - fast web browser'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'NEWS_AND_MAGAZINES' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "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 positive reviews does the 'Ay Y\u0131ld\u0131z Analog Saat' app have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Ay Y\u0131ld\u0131z Analog Saat' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps in the 'FOOD_AND_DRINK' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which productivity apps have a rating greater than 4?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PRODUCTIVITY' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the game 'Zombie Tsunami' have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Zombie Tsunami' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of photography apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "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 App has the highest average rating from 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 'PARENTING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'",
    "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 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the category and rating of the app 'DB Manager'?",
    "SQL": "SELECT Category, Rating FROM playstore WHERE App = 'DB Manager'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Bad Piggies' have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Bad Piggies'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the reviews and rating of the app 'TappyToon Comics & Webtoons'?",
    "SQL": "SELECT Reviews, Rating FROM playstore WHERE App = 'TappyToon Comics & Webtoons'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Sports' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all 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 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Sports' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the app 'FD Mobile' have in the user_reviews table?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'FD Mobile' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Education'",
    "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 games have a positive sentiment in their reviews?",
    "SQL": "SELECT DISTINCT App FROM user_reviews WHERE Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rated app in the playstore that is not a free app?",
    "SQL": "SELECT App FROM playstore WHERE Type != 'Free' 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 rating of the app 'Pregnancy & Baby Tracker'?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Pregnancy & Baby Tracker'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Couch to 10K Running Trainer' app have?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Couch to 10K Running Trainer' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the ART_AND_DESIGN category apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the playstore have a rating higher than 4.0?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique genres are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all productivity apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "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 'SHOPPING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "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 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  }
]