[
  {
    "db_id": "app_store",
    "question": "What is the category of the application with the most reviews having a rating of 4.8 or higher?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) AS Count FROM playstore JOIN user_reviews ON playstore.App = user_reviews.App WHERE Rating >= 4.8 GROUP BY Category ORDER BY Count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which free sports app has the most positive comments?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'SPORTS' AND T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY COUNT(T2.Sentiment) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of business category apps and how many apps have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating), COUNT(*) AS Count FROM playstore WHERE Category = 'BUSINESS' AND Installs > '1,000,000' GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What category does the App have?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = ''"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps have the most positive reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY COUNT(T2.Translated_Review) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the average and total reviews for all Family apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) as Average_Reviews, SUM(Reviews) as Total_Reviews FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the SOCIAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of ratings for all applications in the 'FOOD_AND_DRINK' category?",
    "evidence": "",
    "SQL": "SELECT SUM(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'VIDEO_PLAYERS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the category of FAMILY have more than 10 million installs and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Installs LIKE '10%[+]M' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular lifestyle apps in the playstore, and what are the common features among them?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Category FROM playstore AS T1 ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'BUSINESS' category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'BUSINESS' AND Installs LIKE '%+10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of apps that have more than 100,000 installs in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) / (SELECT COUNT(*) FROM playstore WHERE Category = 'GAME') * 100 FROM playstore WHERE Category = 'GAME' AND Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the SHOPPING category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the highest rating among free apps?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps under the category of 'Entertainment'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have at least 1 million installs in the NEWS_AND_MAGAZINES category and how many installs do they have?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' AND Installs LIKE '1%+00%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app with a content rating of 'Everyone'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps with more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of medical apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average sentiment polarity scores of all apps that are categorized under `AUTO_AND_VEHICLES`?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN (SELECT App FROM playstore WHERE Category = 'AUTO_AND_VEHICLES')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories with the most number of reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, COUNT(*) AS Total_Reviews FROM playstore GROUP BY Category ORDER BY Total_Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the `EVENTS` category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'EVENTS' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the arcade category has the most installs?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Genres = 'Arcade' GROUP BY T1.App ORDER BY T1.Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications under 'GAME' category with more than 100,000 installs and what is their respective review?",
    "evidence": "",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Category = 'GAME' AND Installs > '100,000' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a rating greater than 4.5 and their corresponding install counts?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all gaming apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating for the apps in the shopping category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Rating FROM playstore WHERE Genres = 'Shopping'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free applications in the Maps & Navigation category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of video player apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "Which app with more than 1000 installs has the highest rating?",
    "evidence": "",
    "SQL": "SELECT App, MAX(Rating) FROM playstore WHERE Installs >= '1000+' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular app?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps that belong to the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the lowest rating in the communication category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'COMMUNICATION' AND Rating = (SELECT MIN(Rating) FROM playstore WHERE Category = 'COMMUNICATION')"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common categories for apps with an average rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) as count FROM playstore WHERE Rating > 4.0 GROUP BY Category ORDER BY count DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of video players and editors on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the productivity apps that have an average rating more than 4.1?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'PRODUCTIVITY' AND Rating > 4.1"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of reviews for Bilingual Dictionary Audio App?",
    "evidence": "",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Bilingual Dictionary Audio App'"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rating for an application under the Finance category?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "Which dating app with a free type has at most 4.3 rating and is not installed by 1000+ users?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND Rating <= 4.3 AND Installs NOT LIKE '%+1000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10,000 installs in the Finance category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' AND Installs LIKE '%,10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the `SOCIAL` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps with 10,000+ installs have more positive sentiment than negative sentiment?",
    "evidence": "",
    "SQL": "SELECT (SELECT COUNT(*) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Installs = '10,000+' AND T1.Sentiment = 'Positive') / (SELECT COUNT(*) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Installs = '10,000+' AND T1.Sentiment = 'Negative') * 100"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that belong to the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "Which app falls under the category of shopping and has a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SHOPPING' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the SHOPPING category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs > '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'SHOPPING' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the apps in the Shopping category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the finance category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'FINANCE' AND Installs LIKE '%10,000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of reviews for the app 'To-U - free EV public charging'?",
    "evidence": "",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'To-U - free EV public charging'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of free apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Photography apps with more than 50,000 installs, and what percentage of these apps have a sentiment subjectivity score above 0.8?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), CAST(COUNT(CASE WHEN T2.Sentiment_Subjectivity > 0.8 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Photography' AND T1.Installs > '50,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Social category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews of 'DM EVOLUTION'?",
    "evidence": "",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'DM EVOLUTION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most rated communication apps and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS average_rating FROM playstore WHERE Category = 'COMMUNICATION' GROUP BY App ORDER BY average_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all travel apps in the playstore with over 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '1,000,000+' AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name and category of the app that has the highest number of installs and belongs to the category of 'TOOLS'?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Category FROM playstore WHERE Category = 'TOOLS' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which App has the highest number of installs in the 'Education' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'Education' GROUP BY App ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are categorized as 'FAMILY' and have a rating above 4.0, and what is their size?",
    "evidence": "",
    "SQL": "SELECT App, Size FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have 1,000,000+ installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps in the MAPS_AND_NAVIGATION category have more than 10,000 installs and are not of the 'Maps' genre?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION' AND Type = 'Free' AND Installs = '10,000+' AND Genres NOT LIKE '%Maps%'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a size larger than 10M and are installed more than 100,000,000 times?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Size > '10M' AND Installs > '100,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'MEDICAL' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all FAMILY apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has the highest number of reviews and the average rating is more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews = (SELECT MAX(Reviews) FROM playstore) AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What category do apps like 'Bubble' fall under?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Bubble'"
  },
  {
    "db_id": "app_store",
    "question": "What is the top app in Books & Reference category based on the number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of apps with 'Medical' category that have more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'MEDICAL' AND Installs LIKE '%,1,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all apps in the COMMUNICATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the DATING category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Puzzle category have more than 1 million installs and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) AS avg_rating FROM playstore WHERE Category = 'Puzzle' AND Installs LIKE '%,1,000,000%' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the category 'TOOLS'? ",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Finance apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the types of apps that users have expressed positive sentiment about in the AUTO_AND_VEHICLES category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Type FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'AUTO_AND_VEHICLES' AND T2.Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the Tool category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the categories of the apps that have more than 10,000 installations?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category FROM playstore AS T1 WHERE T1.Installs LIKE '%10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews received by apps in the Adventure game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that have been installed more than 50000000 times and are suitable for users aged 12 and above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '50,000,000+' AND 'Content Rating' = 'Teen' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have at least 1,000,000 installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%+1000000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps categorized as TOOLS and what are the corresponding genres for these apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Size), Genres FROM playstore WHERE Category = 'TOOLS' GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all productivity apps with the word 'List' in their name?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY' AND App LIKE '%List%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have both rating of 4.7 and more than 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.7 AND Installs > '500,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the translator app?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'The translator'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the Apps that have more than 1 million installs and belongs to the Comics genre?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,1,000,000+' AND Genres = 'Comics'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have more than 5,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 video players in the playstore sorted by their ratings?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Rating FROM playstore AS T1 INNER JOIN (SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 5) AS T2 ON T1.App = T2.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the strategy game category by total number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'STRATEGY' GROUP BY App ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the apps in the `BOOKS_AND_REFERENCE` category that have more than 1,000 reviews and a rating greater than 3.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Reviews > 1000 AND Rating > 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the AUTO_AND_VEHICLES category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the 'ENTERTAINMENT' category apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have 100,000+ installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the free app that has the most installs?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Type = 'Free' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of free apps that have received more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Free' AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps with content rating of teens have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = '0' AND Installs > '10,000' AND \"Content Rating\" = 'Teen'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What type of apps have users expressed a sentiment with high subjectivity about?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Sentiment_Subjectivity FROM user_reviews WHERE Sentiment_Subjectivity > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with less than 500 installs and belong to the Communication category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Installs < '500+' AND Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of Free apps in the 'BOOKS_AND_REFERENCE' category?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Type = 'Free' AND Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1 million installations?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free applications in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps under the category of HEALTH_AND_FITNESS have more than 1000 reviews and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Reviews > 1000 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of installations and average rating of music apps?",
    "evidence": "",
    "SQL": "SELECT COUNT(Installs), AVG(Rating) FROM playstore WHERE Type = 'Music'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top three categories with highest rating for apps with more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS AVG_Rating FROM playstore WHERE Installs LIKE '%+%' GROUP BY Category ORDER BY AVG_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest ratings in the EDUCATION category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Category = 'EDUCATION' ORDER BY T1.Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average download size of free apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(REPLACE(REPLACE(Size, ',', ''), '+', '') AS REAL)) FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps with more than 1,000,000 installs, categorized by number of installs?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.Installs) AS Count FROM playstore AS T1 WHERE T1.Installs LIKE '%1,000,000+' GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free games in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all sports Apps that have received more negative reviews than positive reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) AS PosReviews, SUM(CASE WHEN T2.Sentiment = 'Negative' THEN 1 ELSE 0 END) AS NegReviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'SPORTS' GROUP BY T1.App HAVING NegReviews > PosReviews"
  },
  {
    "db_id": "app_store",
    "question": "Which applications have a size greater than 100MB and a rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Size LIKE '%MB' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installations for all apps in the shopping category?",
    "evidence": "",
    "SQL": "SELECT SUM(CAST(SUBSTRING(T1.Installs, INSTR(T1.Installs, '+') + 1) AS INTEGER)) AS Total_Installations FROM playstore AS T1 WHERE T1.Genres = 'Shopping'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps have more than 1,000,000 installs and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Price = 0 AND Installs >= '1,000,000' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app that has 10+ installs and is free?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Installs = '10+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "Which photography app has more than 10,000,000 installs and an average rating greater than 3.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres = 'Photography' AND Installs LIKE '%10,000,000+' AND Rating > 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for free applications in the communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps in the Health & Fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the productivity category with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'PRODUCTIVITY' AND T1.Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the app called 'DaBang - Rental Homes in Korea'?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'DaBang - Rental Homes in Korea'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the 'Basket Manager 2018 Free' app?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'Basket Manager 2018 Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the most popular free app?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE Type = 'Free' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Photography Apps that cost money?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'PHOTOGRAPHY' AND T1.Price != '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps with the most installs among the social media category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='SOCIAL' AND Type='Free' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have the highest rating and more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore) AND Installs LIKE '1%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the NEWS_AND_MAGAZINES category, ordered by the number of installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a content rating of 'Everyone' and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE 'Content Rating' = 'Everyone' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular free apps in the playstore by number of installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type = 'Free' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total size of apps that are of the type free and their category is travel and local?",
    "evidence": "",
    "SQL": "SELECT SUM(Size) FROM playstore WHERE Type = 'Free' AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps belong to the 'HOUSE_AND_HOME' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HOUSE_AND_HOME' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the total installs of the apps in the FINANCE category?",
    "evidence": "",
    "SQL": "SELECT SUM(T1.Installs) FROM playstore AS T1 WHERE T1.Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with free size and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Size = 'Free' GROUP BY T1.App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the number of installs and content rating of all video players apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT T1.Size, T1.\"Content Rating\" FROM playstore AS T1 WHERE T1.Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the 'PERSONALIZATION' category have a rating of 4.8?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PERSONALIZATION' AND Rating = 4.8"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for dating apps with more than 10,000 installs and a price of 0?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING' AND Installs > '10,000+' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps from the Education category have more than 50 installs and have a positive review with sentiment polarity greater than 0.5?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'EDUCATION' AND T1.Installs > '50' AND T2.Sentiment_Polarity > 0.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for paid apps in the communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Type = 'Paid' AND Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the health and fitness apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular app in the Tools category with a rating above 3.5?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'TOOLS' AND T1.Rating > 3.5 GROUP BY T1.App ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000 reviews in the Communication category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'COMMUNICATION' AND Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'NEWS_AND_MAGAZINES' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have been installed more than 10 million times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%M%' AND Installs LIKE '%10%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 photography apps with the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PHOTOGRAPHY' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps whose price is free and category is MEDICAL?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = '0' AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with the 'GAME' category and more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Installs LIKE '%1%M%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the communication category with the highest user satisfaction ratings?",
    "evidence": "",
    "SQL": "SELECT DISTINCT p.App, p.Rating FROM playstore p WHERE p.Category = 'COMMUNICATION' ORDER BY p.Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 applications with the most installs from the EDUCATION category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Business category with more than 1,000,000 installs have a content rating of 'Everyone'?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'BUSINESS' AND T1.Installs LIKE '%1,000,000+' AND T1.\"Content Rating\" = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 1,000 installs and are free, and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS avg_rating FROM playstore AS T1 WHERE T1.Installs > '1,000+' AND T1.Type = 'Free' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs for FAMILY apps with rating more than 4.0?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the most common category for apps that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) as count FROM playstore WHERE Installs LIKE '%100,000%' GROUP BY Category ORDER BY count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the Sports category?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Category = 'SPORTS' GROUP BY T1.App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps from the 'Sports' category have a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) * 100.0 / (SELECT COUNT(*) FROM playstore WHERE Category = 'SPORTS' AND Rating >= 4.0) FROM playstore WHERE Category = 'SPORTS' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Sports category with a minimum rating of 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Rating >= 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the business category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS' AND Installs > '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the News and Magazines category, sorted by the number of reviews?",
    "evidence": "",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' AND Type = 'Free' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the AUTO_AND_VEHICLES category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps has the most installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Arcade genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Arcade%'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps have more than 10,000 installs and a rating of at least 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '10,000+' AND Rating >= 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What entertainment apps have more than 100,000 installs and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '100,000+' AND Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for the app with the most number of installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App IN (SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Apps that have a price and a review count of more than 10,000?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price IS NOT NULL AND Installs > '10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of free apps in the playstore have an average rating of 4.5 or above and at least 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT (COUNT(*)/(SELECT COUNT(*) FROM playstore WHERE Price = '0' AND Rating >= 4.5)) * 100.0 AS Percentage FROM playstore WHERE Price = '0' AND Rating >= 4.5 AND Installs LIKE '%100,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "Which Playstore apps have a rating of at least 4.1 and more than 1,000,000 installs, and what is their genre?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Genres FROM playstore AS T1 WHERE T1.Rating >= 4.1 AND T1.Installs LIKE '%1,000,000+' GROUP BY T1.App, T1.Genres"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Apps in the social category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'SOCIAL' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which categories of apps have the most number of free apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category, COUNT(*) FROM playstore AS T1 WHERE T1.Type = 'Free' GROUP BY T1.Category ORDER BY COUNT(*) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all social media apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have been installed by users who have also reviewed them positively?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '100+' AND T2.Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with 'PHOTOGRAPHY' category have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the 'TOOLS' category have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Installs = '10+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of video players with more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '10,000+' AND Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated medical apps?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'MEDICAL' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps have a rating greater than or equal to 4.0 and belong to the Productivity category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Rating >= 4.0 AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the puzzle genre?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore WHERE Genres = 'Puzzle' GROUP BY App ORDER BY COUNT(Reviews) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of 4.7 rated Apps in the health and fitness genre have more than 10,000 reviews?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(App) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore WHERE Rating = 4.7 AND Genres = 'Health & Fitness') FROM playstore WHERE Rating = 4.7 AND Genres = 'Health & Fitness' AND Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of all free apps in the Events category and how many have more than 1 million downloads?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Size), COUNT(*) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'EVENTS' AND T1.Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps in the travel and local category with at least 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'TRAVEL_AND_LOCAL' AND T1.Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of 'HD Themes Toyota Cruiser 200' app and its size in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating, Size FROM playstore WHERE App = 'HD Themes Toyota Cruiser 200'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the dating category with more than 1,000,000 installs and how many of them have more positive sentiment reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), COUNT(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE NULL END) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'DATING' AND T1.Installs LIKE '%,1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps in the productivity category that have an average rating more than 4.2?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PRODUCTIVITY' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rating apps under the lifestyle category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'LIFESTYLE' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated game in the 'GAME' category and how many installs it has?",
    "evidence": "",
    "SQL": "SELECT Rating, Installs FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the Be like Me - Hay Nhu Toi app and in which category is it categorized?",
    "evidence": "",
    "SQL": "SELECT Size, Category FROM playstore WHERE App = 'Be like Me - Hay Nhu Toi'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the SHOPPING category with a rating of 4.1?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'SHOPPING' AND Type = 'Free' AND Rating = '4.1'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Business apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'Bar-B-Q Recipes' app in the 'FOOD_AND_DRINK' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK' AND App = 'Bar-B-Q Recipes'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of all apps which have a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all racing games in the play store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Racing'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most downloaded finance apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS TOTAL_DOWNLOADS FROM playstore WHERE Category = 'FINANCE' GROUP BY App ORDER BY COUNT(*) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%50,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the apps that have more than 10,000 installs and their price is zero?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%+,00%' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the `LIBRARIES_AND_DEMO` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of puzzle games that have more than 1,000 installs and are priced at $9.99?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Type = 'Paid' AND T1.Price = '$9.99' AND T1.Installs LIKE '%1,000%' AND T1.Type = 'Game' AND T1.Genres LIKE '%Puzzle%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games that belong to the 'ACTION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories of apps that have been updated after year 2018?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) as Count FROM playstore WHERE CAST(SUBSTR('Last Updated', -4, 4) AS INTEGER) >= 2018 GROUP BY Category ORDER BY Count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have been installed more than 1 million times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the LIFESTYLE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that have over 10000000 installs and have a rating of 4.8?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%10,000,000+' AND Rating = 4.8"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with most installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps in the Education category have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' AND Type = 'Free' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that belong to the 'PERSONALIZATION' category and have a minimum of 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PERSONALIZATION' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the category 'GAME'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What video players and editors with the lowest rating and fewer than 100,000 installs have a free version?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'VIDEO_PLAYERS' AND Type = 'Free' AND Installs < '100,000+' AND Rating IN (SELECT MIN(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS' AND Type = 'Free' AND Installs < '100,000+')"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the family app that has more than 1 million installs and has a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1,000,000+' AND Rating >= 4.0 AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the Family category with average rating greater than 4 and more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'FAMILY' AND T1.Rating > 4 AND T1.Installs > '100,000' ORDER BY T1.Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the TOOLS category and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular category in terms of the number of installs, and what is the average rating for those apps?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) FROM playstore AS T1 GROUP BY T1.Category ORDER BY COUNT(T1.Installs) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 categories of apps with the most reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, COUNT(Reviews) AS total_reviews FROM playstore GROUP BY Category ORDER BY total_reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for productivity apps that have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'PRODUCTIVITY' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What apps are free and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free tools apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 500 installs in the PRODUCTIVITY category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%500%' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app with the most installations?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+%' ORDER BY (SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%+%' LIMIT 1) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the shopping apps that have more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '10,000,000+' AND Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with most positive user reviews?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) as Count FROM user_reviews GROUP BY App ORDER BY Count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the FAMILY category that have received more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'FAMILY' AND Installs LIKE '%,000,000+' ORDER BY CAST(SUBSTR(Installs, 1, length(Installs)-3) AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps belong to the MEDICAL category and have more than 1000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL' AND Reviews > 1000"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of reviews for the 'Mint: Budget, Bills, Finance' app?",
    "evidence": "",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Mint: Budget, Bills, Finance'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the free apps that belong to the Productivity category with a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'PRODUCTIVITY' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular free app in the Health and Fitness category with a minimum of 100 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Installs LIKE '%100+' AND Price = 'Free' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the sports apps with at least 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100,000+' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular tools apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND `Content Rating` = 'Everyone' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the average sentiment polarity scores of apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the category of EDUCATION?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular app in ART_AND_DESIGN category with the most total installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'ART_AND_DESIGN' ORDER BY CAST(SUBSTR(Installs, INSTR(Installs, '+') + 1) AS INTEGER) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating that belong to the Tools category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of genres of the app BW Taxi?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'BW Taxi'"
  },
  {
    "db_id": "app_store",
    "question": "What category of apps has the highest average rating among all apps?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 GROUP BY T1.Category ORDER BY Average_Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Medical category that have more than 1,000 reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'MEDICAL' AND T1.Reviews > 1000 GROUP BY T1.App ORDER BY COUNT(T1.App) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What free app from the family category has the most reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'FAMILY' GROUP BY T1.App ORDER BY COUNT(T2.Sentiment) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the free applications in the 'Shopping' category having a rating of 4.7?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'SHOPPING' AND Type = 'Free' AND Rating = 4.7"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed apps in the DATING category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'DATING' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest number of installations from the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'GAME' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps with more than 10,000 installs and a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Genres FROM playstore AS T1 WHERE T1.Installs LIKE '10,000%' AND T1.Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What category has the most number of free apps?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.App) FROM playstore AS T1 WHERE T1.Price = '0' GROUP BY T1.Category ORDER BY COUNT(T1.App) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with only 10M in size and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) FROM playstore WHERE Size = '10M'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category with the most number of apps that have average rating of more than 4?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.App) as Count FROM playstore AS T1 GROUP BY T1.Category HAVING AVG(T1.Rating) > 4 ORDER BY Count DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of apps in the productivity category with at least 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT ROUND(AVG(CASE WHEN Installs LIKE '%,%' AND Installs LIKE '%10,000%' THEN 1 ELSE 0 END)) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app that has the most reviews, and what is its genre?",
    "evidence": "",
    "SQL": "SELECT T1.Rating, T1.Genres FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY COUNT(T2.Translated_Review) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the PRODUCTIVITY category with more than 10,000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PRODUCTIVITY' AND Type = 'Free' AND Reviews > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the entertainment category that are free and have more than 5,000,000 downloads?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Type = 'Free' AND Installs = '5,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the photography apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of music category apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MUSIC' AND Installs LIKE '%10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for apps in the 'Business' category?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "Which free family-oriented apps have a content rating of Everyone?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'FAMILY' AND T1.\"Content Rating\" = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 100 000 installs and average rating above 4.0, and what are their corresponding content ratings?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.`Content Rating` FROM playstore AS T1 WHERE T1.Installs LIKE '%+%' AND T1.Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Photography apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most expensive apps that users dislike?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Price FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity <= 0 AND T1.Price = (SELECT MAX(Price) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the productivity category with over 1 million installs and the content rating of 'Everyone'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY' AND Installs = '1,000,000+' AND 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps with at least 1000 installs and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Installs LIKE '%+1000%' GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the category with the highest average rating among free apps?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Type = 'Free' GROUP BY T1.Category ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have been updated in the last 6 months and what is the average sentiment of these apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Sentiment_Polarity) FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE CAST(SUBSTR('Last Updated', -4, 4) AS INTEGER) >= ( (strftime('%Y', 'now') - 1) * 12 + strftime('%m', 'now') ) ) GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the HEALTH_AND_FITNESS category with a rating of 4.5 or more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the free tools apps that have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the photo editing apps and how many reviews does each app have?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T1.Reviews) FROM playstore AS T1 WHERE T1.Category = 'PHOTOGRAPHY' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the free apps in the COMICS category?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Type = 'Free' AND Category = 'COMICS'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app with the most positive sentiment have and what is the sentiment polarity of it?",
    "evidence": "",
    "SQL": "SELECT T1.Category, T2.Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App ORDER BY T2.Sentiment_Polarity DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the gaming category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres = 'Gaming' GROUP BY App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps that are in the `EDUCATION` category and have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION' AND Installs LIKE '%,100,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the highest number of installs and are free?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs = (SELECT MAX(Installs) FROM playstore) AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the TRAVEL_AND_LOCAL category have more than 10,000 installs and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Installs = '10,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of sports apps?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE CATEGORY = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Photography category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total installs of apps with genre Productivity and rating 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT SUM(T1.Installs) FROM playstore AS T1 WHERE T1.Genres = 'Productivity' AND T1.Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the application with the highest total installs?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Installs = (SELECT MAX(Installs) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Food & Drink' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Food & Drink'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Family apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which comedy App has more than 1,000,000 installs and what is its rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'COMICS' AND Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the 'HEALTH_AND_FITNESS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(REPLACE(Size, 'M', '') AS REAL)) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most downloaded free apps in the business category?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'BUSINESS' GROUP BY T1.App ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the Photography category with more than 5,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Type = 'Free' AND Installs > '5,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the category of Libraries and Demo?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of apps in the 'Role Playing' category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Type = 'Role Playing' AND Size = '1.1M'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest number of installs that are business apps?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'BUSINESS' ORDER BY T1.Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps that are free, have more than 1 million installs, and are categorized as 'FAMILY'?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free' AND Installs > '1,000,000' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the BBC News app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'BBC News'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have more than 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the finance category have more than 500,000 installs and a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'FINANCE' AND T1.Installs LIKE '%500,000+' AND T1.Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the COMMUNICATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps from the TOOL category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(SIZE AS REAL)) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the reviews of apps with category photo and content rating everyone, and what is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT Translated_Review, AVG(Rating) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'PHOTOGRAPHY' AND T2.\"Content Rating\" = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the SHOPPING category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app CV Templates 2018 and how many installs it has?",
    "evidence": "",
    "SQL": "SELECT Rating, Installs FROM playstore WHERE App = 'CV Templates 2018'"
  },
  {
    "db_id": "app_store",
    "question": "Which sports apps have more than 10,000 installs and have an average rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Installs LIKE '%+10,000%' AND T1.Rating > 4.5 AND T1.Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "Which free app in the Family category has the highest number of installations?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'FAMILY' ORDER BY T1.Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total size of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT SUM(CAST(SIZE as INTEGER)) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all dating apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '100,000+' AND Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for health and fitness apps with 10M+ installs and their average rating?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) AS avg_reviews, AVG(Rating) AS avg_rating FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are in the Parenting category with 5-star rating and more than 1 million reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PARENTING' AND Rating = 5.0 AND Reviews > 1000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Photography category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the app 'Moonlight GO Weather EX'?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'Moonlight GO Weather EX'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating that have been reviewed more than 1 million times?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS AVG_rating FROM playstore AS T1 GROUP BY T1.App HAVING COUNT(T1.Reviews) > 1000000 ORDER BY AVG_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for health and fitness apps priced $1.99 or more?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Price >= '$1.99'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the LIBRARIES_AND_DEMO category have more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' AND Installs LIKE '%1,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "Which game apps have more than 1,000,000 installs and have a positive sentiment in their reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'GAME' AND T1.Installs > '1,000,000+' AND T2.Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free games in the action genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Genres LIKE '%Action%'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app Florida State Gameday belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Florida State Gameday'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with the highest ratings and their category?",
    "evidence": "",
    "SQL": "SELECT App, Category, Rating FROM playstore WHERE Price = 0 AND Rating > 4.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Installs = (SELECT MAX(Installs) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of travel apps with free installation and more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000,000+%' AND Type = 'Free' AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of apps with free price in the PRODUCTIVITY category?",
    "evidence": "",
    "SQL": "SELECT COUNT(*)/ (SELECT COUNT(*) FROM playstore WHERE Category = 'PRODUCTIVITY') * 100 FROM playstore WHERE Price = '0' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What apps with more than 1000 installs and size less than 20MB are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1000+' AND Size < '20M' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 1000000 installs and have a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs like '%1,000,000+' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of sports apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS' AND Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are free and have more than 100 reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Price = '0' AND T1.Reviews > 100"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'ENTERTAINMENT' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What are the paid apps with 1 million installs or more from the family category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' AND Type = 'Paid' AND Installs LIKE '%,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps in the finance category by average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'FINANCE' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps that have more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%50,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the category 'EDUCATION'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 50 million installs and belong to the 'MEDICAL' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL' AND Installs LIKE '%+50 million'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app \"R Programming Tutorial\" and how many installs does it have?",
    "evidence": "",
    "SQL": "SELECT T1.Category, T1.Installs FROM playstore AS T1 WHERE T1.App = 'R Programming Tutorial'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps under the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Auto & Vehicles' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What category of apps has the highest number of installations?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.App) FROM playstore AS T1 GROUP BY T1.Category ORDER BY COUNT(T1.App) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What category has the highest average rating of apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of 'PLAYBULB X'?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'PLAYBULB X'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Travel & Local category that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Installs LIKE '%100+%' ORDER BY LENGTH(Installs) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of free apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are free and have a genre of 'Personalization'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0' AND Genres = 'Personalization'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'Shopping' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps having 'Health & Fitness' as their category and having more than 10 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'HEALTH_AND_FITNESS' AND T1.Installs LIKE '%+10%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that are in the GAME category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the HOUSE_AND_HOME category that have a price of free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most reviews, and how many installs each has, in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT App, Installs, COUNT(*) AS Reviews FROM playstore WHERE Category = 'TOOLS' GROUP BY App, Installs ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Communication category that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the sports category with more than 10 000 installs and a high rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Type = 'Free' AND Installs LIKE '%+%' AND Rating > 4.0 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What free apps with size greater than 50M have the most positive sentiment?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Size > '50M' AND T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY COUNT(T2.Sentiment) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Simulation category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps in the DATING category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'DATING' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Finance apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1,000,000 installs under the LIFESTYLE category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs = '1,000,000+' AND Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications with the highest number of installations, categorised by their content rating?",
    "evidence": "",
    "SQL": "SELECT *, COUNT(*) AS Installs FROM playstore AS T1 INNER JOIN (SELECT App, COUNT(*) AS Installs FROM user_reviews GROUP BY App ORDER BY Installs DESC LIMIT 5) AS T2 ON T1.App = T2.App GROUP BY T1.\"Content Rating\""
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for apps with a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Adventure category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the 'Shopping' category with more than 1,000,000 installs and their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'SHOPPING' AND T1.Installs LIKE '%1,000,000+' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Finance category apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of FAMILY category apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating more than 4 and more than 5000 reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4 AND Reviews > 5000"
  },
  {
    "db_id": "app_store",
    "question": "What are the best rated apps with at least 10,000+ installs in the health and fitness category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating > (SELECT AVG(Rating) FROM playstore) AND Installs LIKE '10,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Tools category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T1.Rating) AS AvgRating FROM playstore AS T1 WHERE T1.Category = 'TOOLS' GROUP BY T1.App ORDER BY AvgRating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with over 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the free medical apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have more installs than 1,000,000?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games with installs greater than 5 million?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '5,000,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the category of 'SOCIAL'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the Family category with at least 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Installs LIKE '%,1,000,000%' ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top three apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What type of apps are available in the AUTO_AND_VEHICLES category?",
    "evidence": "",
    "SQL": "SELECT Type FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity for productivity apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'PRODUCTIVITY' AND CAST(REPLACE(REPLACE(T1.Installs, ',', ''), '+', '') AS INTEGER) > 100000"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps that have been reviewed more than 2 times and have a rating greater than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews > 2"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that belong to the SPORTS category and have a rating of 4.4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'SPORTS' AND Rating = '4.4'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in 'Game' category with more than 1,000,000 installs and their ratings?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'GAME' AND T1.Installs LIKE '%1,000,000%' ORDER BY T1.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the app which is categorized as 'Education'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for dating apps and what category are they typically found in?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), T1.Category FROM playstore AS T1 WHERE T1.Category = 'DATING' GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with a size of more than 1MB?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Size LIKE '%M+' AND Size != 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What category has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS average_rating FROM playstore GROUP BY Category ORDER BY average_rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of genres of all applications in the 'NEWS_AND_MAGAZINES' category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Genres FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' AND Installs LIKE '%,1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which free applications have a content rating of 'Everyone' and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND 'Content Rating' = 'Everyone' AND Installs > '10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of 4.5 and are in the business category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating = 4.5 AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'Events' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'EVENTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps that belong to the category 'GAME'? Only include apps that have received reviews from users",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Navigation apps from the 'MAPS_AND_NAVIGATION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'MAPS_AND_NAVIGATION' AND T1.Type = 'Navigation'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 2 categories in the Photography genre with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, AVG(Rating) AS Average_Rating FROM playstore WHERE Genres = 'Photography' GROUP BY Category ORDER BY Average_Rating DESC LIMIT 2"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Health & Fitness apps that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Installs LIKE '%,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app with the highest number of reviews?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category FROM playstore AS T1 INNER JOIN (SELECT App, COUNT(*) AS ReviewCount FROM user_reviews GROUP BY App ORDER BY ReviewCount DESC LIMIT 1) AS T2 ON T1.App = T2.App"
  },
  {
    "db_id": "app_store",
    "question": "What free apps in the 'PERSONALIZATION' category have an average rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PERSONALIZATION' AND Type = 'Free' AND Rating > 4.0 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of apps in the Productivity category have more negative reviews than positive reviews?",
    "evidence": "",
    "SQL": "SELECT CAST((( SELECT COUNT(*) Po FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'PRODUCTIVITY' AND T2.Sentiment = 'Positive' ) - ( SELECT COUNT(*) Ne FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'PRODUCTIVITY' AND T2.Sentiment = 'Negative' )) AS REAL) * 100 / ( SELECT COUNT(*) NUM FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'PRODUCTIVITY' )"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of FOOD AND DRINK Apps with a price of 0?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the social apps that have at least 1 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%1,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What category does 'i am rich' belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'i am rich'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the GAME category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the weather category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'WEATHER' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for AT&T FamilyMap\u00ae and AP Mobile - Breaking News?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE App = 'AT&T FamilyMap\u00ae' OR App = 'AP Mobile - Breaking News'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of applications in the Business category that have a rating above 4.2?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'BUSINESS' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for the shopping apps that are free and have a rating of at least 3?",
    "evidence": "",
    "SQL": "SELECT COUNT(T1.Installs) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'SHOPPING' AND T1.Type = 'Free' AND T1.Rating >= 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of applications with a sentiment review greater than 0.5, sorted by sentiment polarity in descending order?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App IN ( SELECT App FROM user_reviews WHERE Sentiment_Polarity > 0.5 ORDER BY Sentiment_Polarity DESC )"
  },
  {
    "db_id": "app_store",
    "question": "Which free Finance Apps have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs > '10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps have an average rating above 4.1?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating > 4.1"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the app 'Vonage Mobile\u00ae Call Video Text'?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'Vonage Mobile\u00ae Call Video Text'"
  },
  {
    "db_id": "app_store",
    "question": "What type of apps are there with the largest size range?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Type, MIN(Size) AS MinSize, MAX(Size) AS MaxSize FROM playstore GROUP BY Type ORDER BY (MaxSize - MinSize) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What apps are under the category of `SHOPPING` and have more than 50,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SHOPPING' AND Installs LIKE '%,500,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the GAME category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of positive reviews for the app 'EP Lab Digest'?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'EP Lab Digest' AND Sentiment = 'Positive'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the productivity app with a rating of 4.5 and at least 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.5 AND Installs LIKE '%+100,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps with free download option in the category 'TOOLS'?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore AS T1 WHERE T1.Category = 'TOOLS' AND T1.Type = 'Free' ORDER BY T1.Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of Game Apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(size) FROM playstore WHERE category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with most installs under Business category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' AND Installs = (SELECT MAX(Installs) FROM playstore WHERE Category = 'BUSINESS')"
  },
  {
    "db_id": "app_store",
    "question": "What apps have been reviewed more than 20 million times?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews > 20000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of positive and negative reviews for all apps in the medical category?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore, user_reviews WHERE playstore.App = user_reviews.App AND Category = 'MEDICAL' GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1 million installs in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Installs LIKE '%1+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have a category of 'COMMUNICATION' and have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'COMMUNICATION' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the top free app in the family category with more than 5000000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free' AND Installs = '5,000,000+' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the HOUSE_AND_HOME category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HOUSE_AND_HOME' AND Installs LIKE '%,1,000,000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free video player apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps in the DATING category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories of apps that have a high number of installs and how many installs do these apps have?",
    "evidence": "",
    "SQL": "SELECT T1.Category, SUM(CAST(REPLACE(REPLACE(T1.Installs, ',', ''), '+', '') AS INTEGER)) AS Install_Count FROM playstore AS T1 GROUP BY T1.Category ORDER BY Install_Count DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the 'Sports' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games that have more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%50,000%' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest rating in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the HEALTH_AND_FITNESS category with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Installs LIKE '%+1,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the Health & Fitness category?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T2.Translated_Review) AS Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'HEALTH_AND_FITNESS' GROUP BY T1.App ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps that belong to the 'SHOPPING' category and have more than 4.5 rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SHOPPING' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the Family category have more than 10,000 installs and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'FAMILY' AND T1.Installs LIKE '%10,000+' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are all the genres of Apps that have content rating as Everyone?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the beauty category have more than 1,000,000 installs and are free?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Category = 'BEAUTY' AND T1.Installs LIKE '%,1,000,000+' AND T1.Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of WDAMAGE: Car Crash Engine?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'WDAMAGE: Car Crash Engine'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are free and belong to the weather category and state their content rating?",
    "evidence": "",
    "SQL": "SELECT App, 'Content Rating' FROM playstore WHERE Type = 'Free' AND Category = 'WEATHER'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that are free and are under 50MB size in the family category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Size LIKE '%<50MB%' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free photography apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the highest rated free apps?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) AS average_rating FROM playstore AS T1 WHERE T1.Type = 'Free' GROUP BY T1.Category ORDER BY average_rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories for apps with more than 10000000 installs?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Installs > '10,000,000+' GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the personalization category that have more than 10,000 installs and are paid?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Category = 'PERSONALIZATION' AND T1.Installs LIKE '%10,000+' AND T1.Type = 'Paid' ORDER BY T1.Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the tools category with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Installs = '1,000+' OR Installs > '1,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps with a rating of 4.5 or above and more than 1,000,000 installs, and how many apps fall under this criteria?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category, COUNT(T1.App) FROM playstore AS T1 WHERE T1.Rating >= 4.5 AND T1.Installs LIKE '%1,000,000+' GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore apps have more than 10,000,000 installs and what is their category?",
    "evidence": "",
    "SQL": "SELECT App, Category FROM playstore WHERE Installs LIKE '%10,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app with the highest rating?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating IN (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What are the ratings of apps in the finance category with at least 1000 installs?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category = 'FINANCE' AND Installs >= '1,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which free business apps have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs > '100,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games with installs over 1,000,000?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,000,000+' AND Type = 'Free' AND Genres LIKE '%GAME%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of Dating apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What type of apps are available in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT Type FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'FAMILY' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 10 million installs and free to download, and what are their genres?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, T1.Genres FROM playstore AS T1 WHERE T1.Installs LIKE '%+%' AND T1.Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10,000 installs and are free, along with their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Installs > '10,000+' AND T1.Type = 'Free' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Apps with the most installs and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'FAMILY' category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' GROUP BY App ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free video players?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the total number of reviews for games in the Business category?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Category = 'BUSINESS' AND Type = 'Free' AND Genres = 'Games'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps that are in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Social' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Social'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Air Traffic application in the MAPS_AND_NAVIGATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Air Traffic' AND Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore that have more positive sentiment than negative sentiment and more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity > 0 AND T1.Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of free games in the puzzle genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Genres = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of Gunship Modern Combat 3D and how many users have given it a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT T1.Category, COUNT(T1.App) FROM playstore AS T1 WHERE T1.App = 'Gunship Modern Combat 3D' AND T1.Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Stream - Live Video Community application?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Stream - Live Video Community'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 genres with the highest total Sentiment polarity score among the apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT T1.Genres, SUM(T2.Sentiment_Polarity) AS Total_Score FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '%,%' GROUP BY T1.Genres ORDER BY Total_Score DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that have a rating of more than 4.0 and have reviews more than 100,000?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Rating > 4.0 AND Reviews > 100000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 paid apps in the finance category by their number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Paid' AND Category = 'FINANCE' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the ART_AND_DESIGN category with a good sentiment?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ART_AND_DESIGN' AND Price = 0 AND App IN (SELECT App FROM user_reviews WHERE Sentiment_Polarity > 0.5 ORDER BY Sentiment_Polarity DESC LIMIT 5)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have the highest number of installs and what is the total sentiment subjectivity of these apps?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Installs LIKE '%,%' GROUP BY T1.App ORDER BY T1.Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps belonging to the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of free apps with 'Everyone' content rating having at least 5,000 installs?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN T1.`Content Rating` = 'Everyone' AND T1.`Type` = 'Free' AND T1.Installs LIKE '5%' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.App) FROM playstore AS T1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Libraries & Demo category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a high rating and a category of Communication?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'COMMUNICATION' AND Rating > 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Auto & Vehicles' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps with a family category have at least 100,000 installs and their content rating is Teen?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' AND Installs LIKE '%100,000+' AND 'Content Rating' = 'Teen'"
  },
  {
    "db_id": "app_store",
    "question": "Which categories have apps with more than 1,000,000 installs and at least 4.4 ratings?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Category FROM playstore AS T1 WHERE T1.Installs LIKE '%1,000,000+' AND T1.Rating > 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the PRODUCTIVITY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the games category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have 'weather' as a genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%weather%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps in the WEATHER category with 50,000,000+ installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Genres FROM playstore WHERE Category = 'WEATHER' AND Installs = '50,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the Strategy genre?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres LIKE '%Strategy%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free sports Apps with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs > '1,000+' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of photography apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000%' AND Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps by rating in finance category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps belong to the 'Shopping' category and have more than 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,500,000+' AND Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all apps under the `FAMILY` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of free apps in the entertainment category that have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Installs LIKE '%1,000,000+' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the count of apps in the HEALTH_AND_FITNESS category that have more than 1000 installs and at least 2.5 rating?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Installs LIKE '%1,000+%' AND Rating > 2.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular app in the Entertainment category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'Entertainment' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the SPORTS category and what are the genres associated with them?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating), Genres FROM playstore WHERE Category = 'SPORTS' GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of free apps with more than 1,000,000 installations that have a rating of 4.5 or higher, and belong to the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Free' AND Installs = '1,000,000+' AND Rating >= 4.5 AND Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular free game that has the highest number of installs among all games in the photography category and what is its rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, T1.Installs FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'PHOTOGRAPHY' AND T1.Installs = (SELECT MAX(T2.Installs) FROM playstore AS T2 WHERE T2.Type = 'Free' AND T2.Category = 'PHOTOGRAPHY')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games that belong to the action genre and have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Action' AND Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the social category with over 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'SOCIAL' AND T1.Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of an app in the 'BUSINESS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the social category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000,000+' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the family category have at least 5,000 installs and are free to download?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' AND Installs = '5,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of medical apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL' AND Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free games in the 'Strategy' category with more than 10 million downloads?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Category = 'Strategy' AND Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps belonging to the Strategy genre and what percentage of reviews for these Apps have a sentiment polarity of 0.4 or higher?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), CAST(COUNT(CASE WHEN T2.Sentiment_Polarity >= 0.4 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Strategy'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free gaming apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total rating of the apps in the Communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all free apps in the Health and Fitness category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore GROUP BY App ORDER BY CAST(SUBSTR(Installs, 1, INSTR(Installs, '+')-1) AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps with a content rating of Teen?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE \"Content Rating\" = 'Teen'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the puzzle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PUZZLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most reviews in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Total_Reviews FROM playstore WHERE Category = 'PRODUCTIVITY' GROUP BY App ORDER BY Total_Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has the highest total installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which paid app with the highest average rating also has a genre of 'ACTION'",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN (SELECT App, AVG(Rating) AS AvgRating FROM playstore WHERE Type = 'Paid' GROUP BY App) AS T2 ON T1.App = T2.App WHERE T1.Genres LIKE '%ACTION%' ORDER BY T2.AvgRating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of business apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs > '100,000+' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of the app HDFC Bank MobileBanking?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'HDFC Bank MobileBanking'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the SOCIAL category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SOCIAL' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps categorized as 'DATING'?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular educational app with a free version?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Genres LIKE '%Educational%' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed education apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'EDUCATION' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for all apps that are free to download and cost less than 10 dollars?",
    "evidence": "",
    "SQL": "SELECT SUM(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) FROM playstore WHERE Type = 'Free' AND Price < '10.00'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of applications having more positive reviews than negative reviews?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN Reviews - (SELECT COUNT(*) FROM user_reviews WHERE Sentiment = 'Negative') > 0 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.Reviews) FROM playstore AS T1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the PRODUCTIVITY category that have the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'PRODUCTIVITY' GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the LIFESTYLE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of users that has reviewed the 'AH! Soundboard' app?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews AS T1 WHERE T1.App = 'AH! Soundboard'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of the application 'Chinese Chess / Co Tuong'?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'Chinese Chess / Co Tuong'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the HEALTH_AND_FITNESS app with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'HEALTH_AND_FITNESS' ORDER BY T1.Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Tools category with more than 1 million installs have a free type?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'TOOLS' AND Installs LIKE '%,1,000,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the applications in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the most installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,%' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the app with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) FROM playstore AS T1 GROUP BY T1.Category ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the `TOOLS` category and have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Installs LIKE '%100,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of BUSINESS apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest rating in the 'WEATHER' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'WEATHER' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app BGKontakti London BG Kontakti?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'BGKontakti London BG Kontakti'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the SHOPPING category with a rating higher than 4.0 and their total reviews?",
    "evidence": "",
    "SQL": "SELECT App, SUM(Reviews) FROM playstore WHERE Category = 'SHOPPING' AND Rating > 4.0 GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the category of LIFESTYLE which have a price of $0?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps from the Business category with more than 5,000 installs and at least 4 stars?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' AND Type = 'Free' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 5000 AND Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the photography category have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Installs LIKE '%10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the minimum size of all apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT MIN(Size) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the FINANCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the app that has the highest number of installs in the 'Video Players & Editors' category and what is its average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS' GROUP BY App ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the application that falls under the SPORTS category and has a rating of 4.8?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Rating = 4.8"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the GAME category with a rating higher than 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'GAME' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all family apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of free applications in the category of Health and Fitness?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Installs) FROM playstore AS T1 WHERE T1.Category = 'HEALTH_AND_FITNESS' AND T1.Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps with 4-star rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = 0 AND Rating = 4.0 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Apps that are of the type 'Free' in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the free apps in the ENTERTAINMENT category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the GAME category has a rating of 4.7 or above?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'GAME' AND Rating >= 4.7"
  },
  {
    "db_id": "app_store",
    "question": "Which apps belong to the 'FOOD_AND_DRINK' category and have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FOOD_AND_DRINK' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Photography category with over 1 million installs and average rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Installs > '1,000+' AND Rating > 4.0 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for the apps in the 'SOCIAL' category and with a rating more than 4.0?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Category = 'SOCIAL' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have been reviewed positively with installs more than 100,000,000?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%,+100000000' AND Rating > 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps having more than 5,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs LIKE '%,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with rating more than 4.5 and have more than 500000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating > 4.5 AND Installs LIKE '%+500000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Food & Drink category with more than 10,000 installs and a rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FOOD_AND_DRINK' AND Installs > '10,000+' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games categorized under 'Action' and 'Strategy'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category IN ('Action', 'Strategy')"
  },
  {
    "db_id": "app_store",
    "question": "Which free app in the 'GAME' category has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS average_rating FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'GAME' GROUP BY T1.App ORDER BY average_rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed games by rating?",
    "evidence": "",
    "SQL": "SELECT App, SUM(Installs) as Total_Installs, AVG(Rating) as Avg_Rating FROM playstore WHERE Type = 'Game' GROUP BY App ORDER BY Total_Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the category `PARENTING`?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating and the total Sentiment subjectivity score of apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT T1.Rating, SUM(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'TOOLS' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular Apps with a rating above 4.2 that have not been reviewed?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating > 4.2 AND Reviews IS NULL"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of finance apps that have 100,000,000+ installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '100,000,000+' AND Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for free apps that falls under the 'Business' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular app in the family category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Installs > '1,000,000' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest average rating in the FOOD_AND_DRINK category?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Category = 'FOOD_AND_DRINK' GROUP BY T1.App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the popular shopping apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the BBC News app belong to?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE App = 'BBC News'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular game with the highest rating and how many times has it been installed?",
    "evidence": "",
    "SQL": "SELECT App, Rating, Installs FROM playstore WHERE Type = 'Game' AND Rating = (SELECT MAX(Rating) FROM playstore) ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for all apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the top 5 apps by installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs = ( SELECT MAX(Installs) FROM playstore ) ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Type = 'Paid' AND T1.Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Puzzle' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of music apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000,000+' AND Type = 'Free' AND Genres = 'Music'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total count of games with a rating of 4.5 and above that have not been updated since 2019?",
    "evidence": "",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5 AND SUBSTR('Last Updated', -4) <= '2019'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of the apps that have more than 100,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Installs = '100,000,000+' GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 puzzle games with most installs from the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Type='Free' AND Genres LIKE '%Puzzle%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews of all free apps?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the puzzle genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Puzzle%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 2 apps with more than 100,000 installs and a rating more than 4.5 out of 5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '100,000' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 2"
  },
  {
    "db_id": "app_store",
    "question": "What apps have been rated 4.0 and are in the category of Personalization, and also have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.0 AND Category = 'PERSONALIZATION' AND Installs = '10+000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of reviews for free apps that belong to the category of 'FAMILY'?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories of apps with highest average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, AVG(Rating) AS average_rating FROM playstore GROUP BY Category ORDER BY average_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the TOOLS category have more than 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Installs = '500,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of games in the `ACTION` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with free installation?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Parenting category by number of installations?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'PARENTING' ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the beauty category has the highest number of reviews and what is its rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'BEAUTY' GROUP BY T1.App ORDER BY T1.Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular applications from the category HEALTH_AND_FITNESS with a rating above 4.5?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Frequency FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating > 4.5 GROUP BY App ORDER BY Frequency DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest average rating in the category of Social apps?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, AVG(Rating) AS average_rating FROM playstore WHERE Category = 'SOCIAL' GROUP BY App ORDER BY average_rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the photography category has the most reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Genres = 'Photography' GROUP BY T1.App ORDER BY COUNT(T1.App) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the category of 'FAMILY' has the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps in the HEALTH_AND_FITNESS category are 5 star rated?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Category = 'HEALTH_AND_FITNESS' AND Rating = 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of all the free apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all sports apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of 4 and have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 100000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = 0 AND Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the FOOD_AND_DRINK category that have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'FOOD_AND_DRINK' AND Installs LIKE '%,1,000,000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps that belong to the finance category and have a rating of 4.0 or higher?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'FINANCE' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest total Sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY SUM(T2.Sentiment_Polarity) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "How many applications in the 'TOOLS' category have more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'TOOLS' AND Installs = '10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are medical apps and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'MEDICAL' AND T1.Installs LIKE '%,1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have a price of 0?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the VIDEO_PLAYERS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the average rating above 4 and number of installs more than 100,000?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating, Installs FROM playstore WHERE Rating > 4 AND Installs LIKE '%,%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the games in the play store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with a price of 0?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with more than 100 installs under the 'Productivity' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND Installs = '100+' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the WEATHER category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type='Free' AND Category='WEATHER' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What category is the app 'World Racers family board game' classified under?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'World Racers family board game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free weather apps with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs > '1,000' AND Category = 'WEATHER'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for the app 'Programming Hub, Learn to code'?",
    "evidence": "",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Programming Hub, Learn to code'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in EDUCATION category with a rating greater than 4.2?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'EDUCATION' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs of free gaming apps?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps by number of installs and which category do they belong to?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs, T1.Category FROM playstore AS T1 ORDER BY T1.Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of free applications with a rating 4.0 or above have more than 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN Rating >= 4.0 AND Installs LIKE '%,500,000+' THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(App) PER FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average review number for apps that are free to download?",
    "evidence": "",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories with the average rating above 4.5 for applications that have received more than 100,000 reviews?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE Reviews > 100000 GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for games categorized as 'Strategy' and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Installs LIKE '%+10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all photography apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all productivity apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "Which game apps with at least 100,000 installs and price range $0.99-$1.99 have an average rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS average_rating FROM playstore WHERE Category = 'GAME' AND Installs >= '100,000+' AND Price BETWEEN '0.99' AND '1.99' GROUP BY App HAVING AVG(Rating) >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of medical apps have a rating less than 4?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN T1.Rating < 4 THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the top-rated app in the finance category and what is its sentiment polarity?",
    "evidence": "",
    "SQL": "SELECT T1.App, T2.Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FINANCE' AND T1.Rating = (SELECT MAX(Rating) FROM playstore WHERE Category = 'FINANCE')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Education genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Genres LIKE '%Education%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the free game with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'GAME' GROUP BY T1.App ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PRODUCTIVITY' GROUP BY App ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of free apps in the FAMILY category with a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What category does Pet Lovers Dating belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Pet Lovers Dating'"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated free game in the FAMILY category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free' AND Installs > '1,000,000' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of applications that have more than 1 million installs and have a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Installs LIKE '%,1,000,000+' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the app \"Adblock Fast\"?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'Adblock Fast'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the most popular education apps with a rating higher than 4.1?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' AND Rating > 4.1 ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the 'COMMUNICATION' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'COMMUNICATION' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps from the lifestyle category have an average rating greater than 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIFESTYLE' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the SPORTS category with the most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'SPORTS' GROUP BY App ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of reviews for apps in the 'DATING' category are positive?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN U.Sentiment = 'Positive' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(U.App) FROM user_reviews AS U INNER JOIN playstore AS P ON U.App = P.App WHERE P.Category = 'DATING' AND U.Sentiment IS NOT NULL"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 10,000 installs and their categories?",
    "evidence": "",
    "SQL": "SELECT App, Category FROM playstore WHERE Installs > '10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Puzzle games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Genres = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 business apps with the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'BUSINESS' GROUP BY App ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'LIFESTYLE' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps with the highest rating in the Communication category?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'COMMUNICATION' ORDER BY T1.Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the health and fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of more than 4.5 and their reviews are more than 1 million?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Reviews > 1000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of free apps in the gaming category?",
    "evidence": "",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that belong to the LIFESTYLE category and have more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'LIFESTYLE' AND Installs > '50,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of all the video player apps?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have more than 1000000 installs and what are their sizes?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, Size FROM playstore WHERE Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free travel apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are suitable for kids and have been reviewed more than 1,000,000 times?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE `Content Rating` = 'Everyone' AND Reviews > 1000000"
  },
  {
    "db_id": "app_store",
    "question": "What apps with the rating above 4.0 and size less than 50M have more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND Size < '50M' AND Installs > '10000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most highly rated app in the 'FAMILY' category with a free version?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Price = 0 ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps with a size of 50MB or less?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Size = '50MB or less'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of application with 10000+ installs having a content rating of 'Everyone' and a size of '32M'?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Installs = '1,000+' AND 'Content Rating' = 'Everyone' AND Size = '32M'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are free and have the size less than 10MB?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Size < '10MB'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps with the 'Role Playing' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Role Playing'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 communication apps with more than 1000 installs and a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'COMMUNICATION' AND Installs = '1000+' AND Rating > 4.5 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the maximum number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the game genre have more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs != '1' AND Genres = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with average ratings of 4.5 or higher in the Maps & Navigation category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories with the most installs for applications with a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(Installs) as InstallsCount FROM playstore WHERE Rating = 4.5 GROUP BY Category ORDER BY InstallsCount DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that are free and have more than 10,000 installs? What is the average rating of these apps?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs LIKE '%1,000,000%' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the family category with more than 10,000 installs and a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' AND Installs > '10,000+' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a price of $0 and what is the category of each?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Category FROM playstore AS T1 WHERE T1.Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the entertainment apps with a rating of 4.5 and more having more installs than 100000?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ENTERTAINMENT' AND Rating >= 4.5 AND Installs > '100,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for all apps that have a price?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Price != '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the paid apps with more than 10,000 installs and their respective categories?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Category FROM playstore WHERE Price = 'Paid' AND Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "Which entertainment apps have more than 5,000 installs and what are their average ratings?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Installs > '5,000+' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the finance category and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'FINANCE' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the 5 highest rated apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'PRODUCTIVITY' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the dating category with more than 100,000 installs have a rating of 4.5 and above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'DATING' AND Installs LIKE '%,100000%' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the family category with highest rating and what is the sentiment polarity of their translated reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, T2.Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FAMILY' ORDER BY T1.Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the apps in the 'Finance' category and what is their average rating in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of all apps in the 'GAME' category with a rating higher than 4.4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating > 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games with a size more than 100MB?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Size > '100MB' AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of free medical apps that have more than 10 reviews?",
    "evidence": "",
    "SQL": "SELECT T1.Category FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'MEDICAL' AND T1.Reviews > 10 GROUP BY T1.Category"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the tools category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Price = 0 GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the 'SOCIAL' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'SOCIAL' ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in Travel & Local category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the action genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Genres LIKE '%Action%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for Tools apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications with the highest rating in the game category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Rating FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest ratings in the category FAMILY and how many reviews do they have?",
    "evidence": "",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Category='FAMILY' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the most installs in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the business category with rating 4.5 have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'BUSINESS' AND T1.Rating = 4.5 AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 applications in the family category with a high rating above 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.2 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most installed educational apps among the free apps?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.Installs) AS Installs FROM playstore AS T1 WHERE T1.Type = 'Free' GROUP BY T1.App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the sizes of all apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories of apps that have at least 1 million installs and have a average rating greater than 4.1?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS avg_rating FROM playstore WHERE Installs LIKE '%,1,000,000%' GROUP BY Category ORDER BY avg_rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all games in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of free apps with a content rating of 'Everyone'?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Type = 'Free' AND 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular free apps in the lifestyle category that have 100,000+ installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIFESTYLE' AND Type = 'Free' AND Installs = '100+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps with more than 1,000,000 installs and their respective average ratings?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE Installs > '1,000,000' GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installs of apps with a rating of 4.0 or higher in the 'Adventure' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Installs) FROM playstore WHERE Category = 'Adventure' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of applications that are free and falls under the Game category having more than 100000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Free' AND Category = 'GAME' AND Installs > '100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average number of installations for the paid applications in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT AVG(SUBSTR(Installs, -3)) FROM playstore WHERE Type = 'Paid' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of all apps in the simulation category which have at least 1000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'SIMULATION' AND Installs = '1,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for Medical apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of 5-star reviews on the app 'ZenUI Safeguard'?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'ZenUI Safeguard' AND Sentiment = 'Positive' AND Sentiment_Polarity = 1.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps with the most installations in the education category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE Category = 'EDUCATION' AND Type = 'Free' GROUP BY App ORDER BY CAST(SUBSTR(Installs, INSTR(Installs, '+') + 1) AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have a rating above 4.0 and have received more than 1 million reviews and are in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating > 4.0 AND Reviews > 1000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the FAMILY category have a rating of 4.4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' AND Rating = 4.4"
  },
  {
    "db_id": "app_store",
    "question": "How many apps in the social category have over 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Installs LIKE '%,1,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories in the health and fitness app genre with more than 100000 installs and their average rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) FROM playstore WHERE Type = 'Health & Fitness' AND Installs = '100,000+' GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with more than 5000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,5,000+%' AND Price = 0"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the 'Games' category have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'Games' AND Installs LIKE '%+100000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most reviewed app in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps in the 'Strategy' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Genres LIKE '%Strategy%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the applications with 1,000+ installs from the 'BUSINESS' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' AND Installs LIKE '%1,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the puzzle games in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are classified under productivity and have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PRODUCTIVITY' AND Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that are free to download and have more than 1,000,000 installs, and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Installs LIKE '%,000,000+' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top genres for the Comcis Reader app?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'Comics Reader'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which free news app has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'NEWS_AND_MAGAZINES' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the application names of the apps with 10,000,000+ installs in the 'PERSONALIZATION' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 WHERE T1.Category = 'PERSONALIZATION' AND T1.Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What apps under the category of `GAME` have more than 100,000 installs and a rating above 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Installs LIKE '%100,000+' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps with more than 100,000,000 installs and what is the most popular free app in this category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), T1.App FROM playstore AS T1 WHERE T1.Type = 'Free' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 100000000 ORDER BY T1.Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of CE Smart?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'CE Smart'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the BOOKS_AND_REFERENCE category have more than 1 million installs and what is the total sentiment subjectivity of these apps?",
    "evidence": "",
    "SQL": "SELECT SUM(T2.Sentiment_Subjectivity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'BOOKS_AND_REFERENCE' AND T1.Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price range for apps with a specific genre of 'MEDICAL'?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Price FROM playstore WHERE Genres = 'Medical'"
  },
  {
    "db_id": "app_store",
    "question": "What are the total number of apps in the 'DATING' category with a price of free?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'DATING' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a content rating of Everyone and how many installs they have?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Installs FROM playstore WHERE \"Content Rating\" = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "Which category has the most number of apps that have more than 1 million installs and a rating of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) AS num_apps FROM playstore WHERE Installs LIKE '%,000+' AND Rating >= 4 GROUP BY Category ORDER BY num_apps DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which applications have more than 50 million installs and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%50,000,000+' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app with the highest number of installs in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category = 'TOOLS' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of free apps in the Business category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'BUSINESS' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs of free apps in the Medical category?",
    "evidence": "",
    "SQL": "SELECT SUM(T1.Installs) FROM playstore AS T1 WHERE T1.Category = 'MEDICAL' AND T1.Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the 'GAME' category with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Type = 'Free' AND Installs LIKE '%10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the COMMUNICATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for free applications with a category of 'EDUCATION'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps that have both 'Productivity' and 'Utilities' genres?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Genres LIKE '%Productivity%' AND Genres LIKE '%Utilities%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in Photography category that are free and have content rating as Everyone?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Type = 'Free' AND 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with a rating of 3.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating >= 3.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of paid applications in 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(CAST(replace(Price, '$', '') AS REAL)) FROM playstore WHERE Type = 'Paid' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for the apps with a price greater than $0?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Price > '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the highest average rating and how many installs they have?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating), T1.Installs FROM playstore AS T1 ORDER BY AVG(T1.Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "How many apps with a free price tag in the Finance category have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'FINANCE' AND Price = '0' AND Installs LIKE '%,1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 best-selling apps in the PHOTOGRAPHY category with a sentiment polarity greater than 0.4?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'PHOTOGRAPHY' AND T2.Sentiment_Polarity > 0.4 ORDER BY T1.Price * CAST(REPLACE(REPLACE(T1.Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of the apps in the shopping category are free?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(CASE WHEN Type = 'Free' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(App) FROM playstore WHERE Genres = 'Shopping'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 apps in the Puzzle genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres LIKE '%Puzzle%' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps with a rating of 4.4 or above have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating >= 4.4 AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 installed apps that are free and rated high in Finance category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' AND Price = 0 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the finance apps that have a rating of 4.8 or higher and have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'FINANCE' AND Rating >= 4.8 AND Installs LIKE '%10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Productivity category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PRODUCTIVITY' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of the top selling shopping app?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Type = 'Shopping' AND Installs = (SELECT MAX(Installs) FROM playstore WHERE Type = 'Shopping')"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for News & Magazines category apps with rating 3.5?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' AND Rating = 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest number of reviews and the average rating more than 3.5 out of 5?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App HAVING AVG(Rating) > 3.5 AND Reviews = (SELECT MAX(Reviews) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app called 'Galaxy Attack: Alien Shooter'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Galaxy Attack: Alien Shooter'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 genres of apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT Genres, COUNT(*) as count FROM playstore GROUP BY Genres ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of education apps with more than 100000 reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION' AND Reviews > 100000"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in 'books and reference' category with average rating over 4.0?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the applications in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the app 'Toca Life: City'?",
    "evidence": "",
    "SQL": "SELECT Price FROM playstore WHERE App = 'Toca Life: City'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps which have a rating of 4.0 and above in the finance category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.0 AND Category = 'Finance'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 Applications with the highest number of installs in the Action & Adventure genre?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Genres = 'Action & Adventure' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the family category with the highest total sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FAMILY' GROUP BY T1.App ORDER BY SUM(T2.Sentiment_Polarity) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for the Business apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the number of installs for applications having a rating of 4.9 and priced as free?",
    "evidence": "",
    "SQL": "SELECT Installs FROM playstore WHERE Rating = 4.9 AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs of all apps in the tools category with a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 Apps in the Racing category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, COUNT(T1.Installs) AS Installs FROM playstore AS T1 WHERE T1.Category = 'Racing' GROUP BY T1.App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps with more than 10,000 installs and what is the percentage ratio of positive sentiment reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating), CAST(COUNT(CASE WHEN Sentiment = 'Positive' THEN 1 ELSE NULL END) AS REAL) * 100 / COUNT(Sentiment) FROM playstore INNER JOIN user_reviews ON playstore.App = user_reviews.App WHERE playstore.Installs LIKE '%+10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of reviews for apps with a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT SUM(Reviews) FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Travel & Local category?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1,000,000 installs and which categories they belong to?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, Category FROM playstore WHERE Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications that are free and belongs to the category FAMILY?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with no reviews and a free type?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Reviews = 0 AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family-oriented apps in the 'entertainment' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Genres LIKE '%Entertainment%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of free apps with 'Finance' category among all free apps?",
    "evidence": "",
    "SQL": "SELECT COUNT(T1.App) / (SELECT COUNT(*) FROM playstore WHERE Price = '0') * 100 FROM playstore AS T1 WHERE Category = 'FINANCE' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1,000,000 installs in the 'GAME' category that have a rating more than 4.2?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'GAME' AND Installs LIKE '1,000,000+' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the `PERSONALIZATION` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of all games in the puzzle genre that are free to download?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Type = 'Free' AND Genres = 'Puzzle'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have a rating of at least 4.5 and what is the total number of installs for those apps?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest rating in the beauty category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BEAUTY' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps by total installs and their corresponding sentiment subjectivity?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Subjectivity) AS Total_Sentiment_Subjectivity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Total_Sentiment_Subjectivity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of all the apps under the category 'LIFESTYLE'?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the most installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Simulation genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free games from the 'GAME' category that have more than 1,000 installs and a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'GAME' AND Type = 'Free' AND Installs > '1,000' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What type of apps are available in the 'Education' category, in descending order of the number of reviews?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(Reviews) FROM playstore GROUP BY Category ORDER BY COUNT(Reviews) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 1,000,000 installs and how many of these apps have received only 5-star ratings?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T1.Rating) FROM playstore AS T1 WHERE T1.Installs LIKE '%1,000,000%' GROUP BY T1.Rating"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the 'Education' category with the most installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Personalization category with the most installs?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Category = 'PERSONALIZATION' ORDER BY T1.Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app 'BS MAPS' belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'BS MAPS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps that belong to 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of apps with rating more than 4?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Rating > 4 GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the free apps in the 'Entertainment' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Apps that are free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What Photography app has the lowest total Sentiment subjectivity score?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres = 'Photography' GROUP BY T1.App ORDER BY SUM(T2.Sentiment_Subjectivity) ASC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps belonging to the game category and having more than 100000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Installs LIKE '%100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps in the Productivity category have been installed more than 50,000,000 times and have a minimum rating of 4.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PRODUCTIVITY' AND Type = 'Free' AND Installs > '50000000' AND Rating >= '4.0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the NEWS_AND_MAGAZINES category that have more than 10,000 installs and have a rating higher than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' AND Installs = '10,000+' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the finance apps with a rating of 4.5 or higher that have more than 1,000,000 installs and are priced at 0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FINANCE' AND Rating >= 4.5 AND Installs = '1,000,000+' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the app V BTS Wallpaper?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Price FROM playstore WHERE App = 'V BTS Wallpaper'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that are free and have over 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app 'Arrhythmias and Dysrhythmias' belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Arrhythmias and Dysrhythmias'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps under the business category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'BUSINESS' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the category of ENTERTAINMENT which have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Installs LIKE '%+10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 1 million installations in the MAPS_AND_NAVIGATION category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%1,000,000+' AND Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price range of the App Learn C++ and does it belong to the category of PERSONALIZATION?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.Price, T1.Category FROM playstore AS T1 WHERE T1.App = 'Learn C++' AND T1.Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all free apps in the `LIFESTYLE` category with a rating of 4.0 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIFESTYLE' AND Type = 'Free' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the list of apps that have an average rating of 4.5 and are in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'FAMILY' AND Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of apps that have 1000+ installs and rating above 3.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '1%+' AND Rating > 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 Apps from the Finance category with the highest total Sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, SUM(T2.Sentiment_Polarity) as Total_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FINANCE' GROUP BY T1.App ORDER BY Total_Polarity DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres that have free apps with installs more than 10,000,000?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Type = 'Free' AND Installs != '' AND CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) > 10000000 GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free applications with more than 5,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that fall under the personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the tools apps?",
    "evidence": "",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that are free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the Photography category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Genres = 'Photography' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are priced free in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for apps in the Simulation category with a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'Simulation' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "Which app has the highest rating in the PARENTING category and what is its average sentiment polarity score?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'PARENTING' GROUP BY T1.App ORDER BY T1.Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "How many medical apps have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'MEDICAL' AND Installs = '1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 paid apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Price != 0 GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which music and audio App has the largest size and how many people have installed it?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Size, T1.Installs FROM playstore AS T1 WHERE T1.Genres = 'MUSIC_AND_AUDIO' GROUP BY T1.App, T1.Size, T1.Installs ORDER BY T1.Size DESC"
  },
  {
    "db_id": "app_store",
    "question": "What genre of app has the average rating above 4.2 from 5000 or more reviews?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Size = '7.3M' AND Reviews >= 5000 AND Rating > 4.2 GROUP BY Genres"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the sustainability@BU app and how many users have installed it?",
    "evidence": "",
    "SQL": "SELECT Size, Installs FROM playstore WHERE App = 'sustainability@BU'"
  },
  {
    "db_id": "app_store",
    "question": "Which game app has most installs and how many installs does it have?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Installs FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Type = 'GAME' ORDER BY CAST(REPLACE(REPLACE(T1.Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What category has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) FROM playstore AS T1 GROUP BY T1.Category ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of applications in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with ratings between 4.5 and 4.7, excluding the 'Arts & Design' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating BETWEEN 4.5 AND 4.7 AND Category != 'Arts & Design'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of dating apps with more positive sentiment than negative sentiment?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity > 0 AND T1.Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are in the Finance category and have a price of 0?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with the highest average rating in the BEAUTY category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BEAUTY' AND Type = 'Free' GROUP BY App ORDER BY AVG(Rating) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that have been installed more than 50,000 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,50,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of free apps with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Type = 'Free' AND Installs LIKE '1,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories with the highest average rating among apps with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT T1.Category, AVG(T1.Rating) FROM playstore AS T1 WHERE Installs LIKE '%+%' GROUP BY T1.Category ORDER BY AVG(T1.Rating) DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of HEALTH_AND_FITNESS apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with the most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the weather category that have more than 100,000 installs and have an average rating more than 4.0?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'WEATHER' AND Type = 'Free' AND Installs > '100,000' AND Rating > '4.0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of weather apps with a price tag greater than $1?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore AS T1 WHERE T1.Price > '$1.00' AND T1.Genres = 'Weather'"
  },
  {
    "db_id": "app_store",
    "question": "What is the percentage of free apps in the travel category?",
    "evidence": "",
    "SQL": "SELECT CAST(COUNT(*) AS REAL) * 100 / (SELECT COUNT(*) FROM playstore) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of lifestyle apps?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Genres = 'Lifestyle'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app with the most positive sentiment reviews belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE Sentiment = 'Positive' GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps in the Family category with over 100,000,000+ installs and free to download?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FAMILY' AND Installs = '100,000,000+' AND Type = 'Free' ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of social media apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 10,000,000 installs in the WEATHER category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'WEATHER' AND Installs > '10,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the arcade category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Genres LIKE '%Arcade%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the apps with more than 100,000 installs that are free and rated at least 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%+100,000%' AND Type = 'Free' AND Rating >= 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'EDUCATION' type applications?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "Which paid apps in the sports category have the most installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'SPORTS' AND Type = 'Paid' ORDER BY Installs DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Tools category that have more than 10 million installs and are free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Installs = '10,000,000+' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for all the free books and reference apps?",
    "evidence": "",
    "SQL": "SELECT SUM(CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER)) AS Total_Installs FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the size of the app 'Associated Credit Union Mobile'?",
    "evidence": "",
    "SQL": "SELECT Size FROM playstore WHERE App = 'Associated Credit Union Mobile'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of all free MAPS_AND_NAVIGATION apps in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Type = 'Free' AND Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Sports category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS AvgRating FROM playstore WHERE Category = 'SPORTS' GROUP BY App ORDER BY AvgRating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of installs of applications in the lifestyle category having a free price tag?",
    "evidence": "",
    "SQL": "SELECT COUNT(Installs) FROM playstore WHERE Category = 'LIFESTYLE' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free travel apps that have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%+10M%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Dating apps with a minimum of 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%1,000,000+' AND Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the apps in the PHOTOGRAPHY category?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of all apps in the PERSONALIZATION category that are paid?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Category = 'PERSONALIZATION' AND Type = 'Paid'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the library and demo category with a minimum of 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' AND Type = 'Free' AND Installs LIKE '10,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have received more than 50,000 installs and have a content rating of 'Everyone'?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Installs LIKE '%50,000,000+' AND 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average sentiment polarity score of the Hi-Smart AC app in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.Category = 'TOOLS' AND T2.App = 'Hi-Smart AC'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of users give a positive sentiment to FAMILY apps with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN T2.Sentiment = 'Positive' THEN 1 ELSE 0 END) * 100 / SUM(CASE WHEN T2.Sentiment IS NOT NULL THEN 1.0 ELSE 0 END) AS REAL) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FAMILY' AND T1.Installs > '1,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of free apps with a minimum rating of 4.0 that falls under the category of 'LIFESTYLE'?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Price = '0' AND Rating >= 4.0 AND Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular app, 'Instagram', in the COMMUNICATION category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Instagram' AND Category = 'COMMUNICATION' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which sports apps have at least 100,000 installs and a content rating of Everyone and have a rating of more than 4.2?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs LIKE '%100,000%' AND \"Content Rating\" = 'Everyone' AND Rating > 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the most frequently mentioned genre in the database?",
    "evidence": "",
    "SQL": "SELECT Genres, COUNT(*) FROM playstore GROUP BY Genres ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps categorized as TRAVEL_AND_LOCAL?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app with the highest number of reviews?",
    "evidence": "",
    "SQL": "SELECT T1.Category FROM playstore AS T1 INNER JOIN (SELECT App, COUNT(*) as num_reviews FROM user_reviews GROUP BY App ORDER BY num_reviews DESC LIMIT 1) AS T2 ON T1.App = T2.App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the PLAYSTORE and their corresponding ratings?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of apps with a size greater than 10 MB?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Size > '10MB'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest rated apps in the ENTERTAINMENT category?",
    "evidence": "",
    "SQL": "SELECT T1.App, T1.Rating FROM playstore AS T1 WHERE T1.Category = 'ENTERTAINMENT' ORDER BY T1.Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games with more than 100,000 installs in the simulation genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%100,000+' AND Genres = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free video player apps that are installed by more than 1 million users?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the free apps with a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the most installed application in the LIFESTYLE category?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Category = 'LIFESTYLE' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What category does the Bacterial Vaginosis app belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Bacterial Vaginosis \ud83c\uddfa\ud83c\uddf8'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of productivity apps that are free and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,1,000,000,+%' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the popular apps in the NEWS_AND_MAGAZINES category with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' AND Installs LIKE '%,100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What percentage of games have at least 100,000 installs and a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT CAST(SUM(CASE WHEN Reviews > 100000 THEN 1 ELSE 0 END) AS REAL) * 100 / COUNT(App) FROM playstore WHERE Type = 'GAME' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the ART_AND_DESIGN category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the EDUCATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the library apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with a content rating of 'Everyone'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'gps tracker cg'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'gps tracker cg'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of applications that have more than 10,000,000 installs and has a positive sentiment review with a sentiment polarity more than 0.3?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Installs = '10,000,000+' AND App IN (SELECT App FROM user_reviews WHERE Sentiment = 'Positive' AND Sentiment_Polarity > 0.3)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps under the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps by category under the product category",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'PRODUCTIVITY' ORDER BY Category, App LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that belong to the category 'GAME'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family category apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category and size of the app named DN - Di\u00e1rio de Not\u00edcias?",
    "evidence": "",
    "SQL": "SELECT Category, Size FROM playstore WHERE App = 'DN - Di\u00e1rio de Not\u00edcias'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 installed apps in 'TOOLS' category with ratings above 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0 ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for apps in the Entertainment category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average rating and total installs of all paid apps with a content rating of 'Everyone'?",
    "evidence": "",
    "SQL": "SELECT AVG(T1.Rating), AVG(T1.Installs) FROM playstore AS T1 WHERE T1.Type = 'Paid' AND T1.'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Shopping apps that are free and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the apps in the dating category with more than 50,000 installs and less than 5 stars?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Genres = 'Dating' AND Installs LIKE '%,50,000+' AND Rating < 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have more than 50 installs and their corresponding average rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, AVG(Rating) AS Average_Rating FROM playstore WHERE Installs LIKE '50+' GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for all free applications in the family category?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that fall under the 'Communication' category and have a rating more than 4?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Category = 'COMMUNICATION' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average price of free apps in the Lifestyle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Price) FROM playstore WHERE Type = 'Free' AND Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories for applications that have been reviewed with a sentiment polarity greater than 0.4?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App IN ( SELECT App FROM user_reviews WHERE Sentiment_Polarity > 0.4 ORDER BY Sentiment_Polarity DESC LIMIT 3 )"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for health and fitness apps that are free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most frequently used category in the Education genre that has a rating of 4.8 or more?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) FROM playstore WHERE Category IN (SELECT Category FROM playstore WHERE Rating >= 4.8 AND Genres = 'Education') GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps that have been installed more than 10,000,000 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs > '10000000'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Entertainment category that are free to install and have a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'ENTERTAINMENT' AND Type = 'Free' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 applications with the highest number of reviews in the Finance category?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(Reviews) AS CountReviews FROM playstore WHERE Category = 'FINANCE' GROUP BY App ORDER BY CountReviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the Family category have reviews more than 1,000 and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Reviews > 1000 AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the \"Communication\" category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the finance apps that have positive reviews and have more than 10000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'FINANCE' AND Installs LIKE '%,10,000+' AND (SELECT COUNT(*) FROM user_reviews WHERE App = playstore.App AND Sentiment = 'Positive') > 0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most reviewed apps in the 'Communication' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'COMMUNICATION' ORDER BY Reviews DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What category of apps has the highest average rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps are free and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps have more than 10,000,000 installs and a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,000,000+' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps that are free and have more than 10,000 installs in the COMMUNICATION category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'COMMUNICATION' AND Type = 'Free' AND Installs LIKE '%,10000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have a rating of 4.4 or above?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Rating >= 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games that are installed more than 10,000,000 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for applications that have been updated after 2018 in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND SUBSTR('Last Updated', -4) > '2018'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Photography category which have more than 1 million installs and what is their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Installs = '1,000+' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps that have been reviewed by more than 100,000 users and have a rating of 4.3 or above?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Reviews > 100000 AND Rating >= 4.3"
  },
  {
    "db_id": "app_store",
    "question": "Which GAME app has the highest average rating in the 'Playstore' database?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'GAME' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the App in the Games category with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all house and home apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have more positive sentiment reviews and their respective average ratings?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) AS Avg_Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY Avg_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Parenting category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of the tools category apps?",
    "evidence": "",
    "SQL": "SELECT AVG(SIZE) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that belong to the 'Tools' category with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,1,000,000+' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps with installs more than 10 million have a sentiment polarity of 0.3?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Free' AND T1.Installs > '10,000,000+' AND T2.Sentiment_Polarity = 0.3"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps that have an average rating of at least 4.5 and more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Rating >= 4.5 AND Installs > '100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that is free to install and has more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Installs = '100+' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 free applications in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the 100 most downloaded apps in the finance category that have an average rating greater than 4.2?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'FINANCE' AND T1.Rating > 4.2 ORDER BY AVG(T1.Rating) DESC LIMIT 100"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that belong to the 'FAMILY' category and have more than 100,000 installs? Please list out their average rating.",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS average_rating FROM playstore WHERE Category = 'FAMILY' AND Installs LIKE '%+100000%' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories of apps with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating for free apps of the category family?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the total reviews of all apps categorized under Action and Games and what is the average sentiment polarity of these reviews?",
    "evidence": "",
    "SQL": "SELECT SUM(T1.Reviews), AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Genres IN ('Action', 'Games')"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of apps that have the `VIDEO_PLAYERS` category and more than 5000 installs?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Rating FROM playstore WHERE Category = 'VIDEO_PLAYERS' AND Installs LIKE '5,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most installed free app in the productivity category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'PRODUCTIVITY' AND Type = 'Free' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average size of entertainment apps with more than 10,000,000 installs that have not been updated since 2019?",
    "evidence": "",
    "SQL": "SELECT AVG(Size) FROM playstore WHERE Installs > '10,000,000+' AND SUBSTR('Last Updated', -4) < '2019'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free finance apps in the Play Store with a content rating of 'Everyone' and more than 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'FINANCE' AND Type = 'Free' AND Installs = '500,000+' AND 'Content Rating' = 'Everyone'"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps that belong to the 'PARENTING' category have the highest average rating?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Type = 'Free' AND T1.Category = 'PARENTING' GROUP BY T1.App ORDER BY Average_Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What paid app has the most positive sentiment reviews?",
    "evidence": "",
    "SQL": "SELECT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Type = 'Paid' AND T2.Sentiment = 'Positive' GROUP BY T1.App ORDER BY COUNT(T2.Sentiment) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with highest ratings in the business category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Tools category that have more than 1,000 installs and what are their average ratings?",
    "evidence": "",
    "SQL": "SELECT DISTINCT T1.App, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'TOOLS' AND T1.Installs > '1,000+' GROUP BY T1.App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are categorized as PERSONALIZATION and have positive reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PERSONALIZATION' AND EXISTS (SELECT 1 FROM user_reviews WHERE user_reviews.App = playstore.App AND user_reviews.Sentiment = 'Positive')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the lifestyle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with an install base of over 500,000?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,500,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the `TOOLS` category that have more than 1 million installs and have an average rating above 4?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'TOOLS' AND Installs LIKE '%1,000,000+' AND Rating > 4 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the apps from the FAMILY category with the highest average rating and how many reviews did they get?",
    "evidence": "",
    "SQL": "SELECT T1.App, AVG(T1.Rating), COUNT(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'FAMILY' GROUP BY T1.App ORDER BY AVG(T1.Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top free apps in the 'SHOPPING' category with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'SHOPPING' AND Installs = '100,000+' AND Type = 'Free' ORDER BY Installs DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of parenting apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Type = 'Free' AND Genres LIKE '%Parenting%'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the communication category with the most installations?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'COMMUNICATION' GROUP BY App ORDER BY COUNT(App) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with at least 100,000 installs and their categories?",
    "evidence": "",
    "SQL": "SELECT App, Category FROM playstore WHERE Installs LIKE '%100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'following' with a size of less than 50M?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'following' AND Size < '50M'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the `FAMILY` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the productivity category that have been reviewed by at least 10,000 users and have a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Category = 'PRODUCTIVITY' AND Price = '0' AND Reviews >= 10000 AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most downloaded apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' GROUP BY App ORDER BY CAST(REPLACE(REPLACE(Installs, ',', ''), '+', '') AS INTEGER) DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with the highest rating in the gaming category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='GAME' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the travel and local category that are free and have more than 1 million installs are rated 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Type = 'Free' AND Installs LIKE '%1,000,000+' AND Rating >= 4.5"
  }
]