[
  {
    "question": "What is the average rating of the Theme for Android 7.0 app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Theme for Android 7.0'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'COMMUNICATION' category? Please provide the average rating of these apps.",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and what are their average review counts?",
    "SQL": "SELECT App, AVG(Reviews) FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what are their names?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which books and reference apps have the highest rating on the Google Play Store and what are their sentiments from the user reviews?",
    "SQL": "SELECT T1.App, T1.Rating, T2.Translated_Review, T2.Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'BOOKS_AND_REFERENCE' AND T1.Rating = ( SELECT MAX(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a positive sentiment review and what is their average rating?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5 and what is their price?",
    "SQL": "SELECT App, Price FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most popular apps in the 'Tools' category with a rating greater than 4.0? List their names and average rating.",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0 GROUP BY App ORDER BY Average_Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Family' genre and have a rating greater than 4? List the names of these apps along with their ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Genres = 'Family' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'TOOLS' category and what is the average rating of these apps?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps that have received more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'TOOLS' category have more than 500,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Please provide the average rating of the ZOOKEEPER DX TouchEdition app and the number of reviews it has.",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'ZOOKEEPER DX TouchEdition'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "how many user reviews with a negative sentiment are there for the 'Fresh EBT - Food Stamp Balance' app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE Sentiment = 'Negative' AND App = 'Fresh EBT - Food Stamp Balance'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive review for the Badoo - Free Chat & Dating App?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Badoo - Free Chat & Dating App' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Education' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the ART_AND_DESIGN category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Insave-Download for Instagram' app have on the Google Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Insave-Download for Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'MEDICAL' category and how many apps have a rating higher than 4.0?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'MEDICAL' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'PHOTOGRAPHY' category with a rating greater than 4.0?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category and how many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews do 'Farm Heroes Saga' have with a positive sentiment?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'Farm Heroes Saga' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the BJ\u2019s Mobile App have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'BJ\u2019s Mobile App' AND Rating > 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the FOX NOW - On Demand & Live TV app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'FOX NOW - On Demand & Live TV' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Darkness Rises app have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Darkness Rises' AND Rating > 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FAMILY' category and have a rating greater than 4? Please list the names of these apps along with their ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the COMMUNICATION category and how many of them have a rating higher than 3.5?",
    "SQL": "SELECT AVG(Rating), COUNT(Rating) FROM playstore WHERE Category = 'COMMUNICATION' AND Rating > 3.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category and how many apps are in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different types of apps are there on the playstore and what is the average rating for each type?",
    "SQL": "SELECT TYPE, AVG(Rating) FROM playstore GROUP BY TYPE",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users hold a positive sentiment towards the FP Market app? What is its genre on the Google Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment), T1.Genres FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'FP Market' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories of apps are in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Barbie\u2122 Fashion Closet app?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Barbie\u2122 Fashion Closet' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the LIFESTYLE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Photo & Video' category and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Photo & Video'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH_AND_FITNESS' category and how many such apps are there?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of productivity apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many games have a rating above 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating on the Google Play Store and how many reviews does it have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which game has the highest rating and how many reviews does it have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' database have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average size in megabytes?",
    "SQL": "SELECT COUNT(App), AVG(REPLACE(SUBSTR(Size, 1, INSTR(Size, 'M') - 1), ',', '')) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the COMMUNICATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'SPORTS' category? Please provide a review for each app if available.",
    "SQL": "SELECT DISTINCT T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized as 'Tools' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users holds neutral attitude towards the HTC Weather app? Indicate the app's rating on the Google Play Store.",
    "SQL": "SELECT COUNT(T1.Rating), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'HTC Weather' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the Family category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the GAME category and have a rating greater than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4 and have at least 1000 reviews?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4 AND Reviews >= 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all family category apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are rated higher than 4.0 and have more than 500,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Rating > 4.0 AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the fitness apps in the Playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Fitness'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating and what is the average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5? List their names.",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'TOOLS' category and have a rating of 4.0 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Rating >= 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the American Airlines app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'American Airlines'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users had positive reviews for the app DC Comics?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'DC Comics' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated the Meditation Pomodoro app 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE App = 'Meditation Pomodoro' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment towards the Candy Crush Soda Saga app? Indicate the translated review for each positive user.",
    "SQL": "SELECT COUNT(T2.Sentiment), T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Soda Saga' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FINANCE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps that have more than 1,000,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Sokoban Land DX' app have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Sokoban Land DX' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'BUSINESS' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the CATEGORY EVENTS ?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized as 'GAME' and what is the average rating of these games?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating), COUNT(Reviews) AS Total_Reviews FROM playstore GROUP BY App ORDER BY Total_Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the Carousell: Snap-Sell, Chat-Buy app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Carousell: Snap-Sell, Chat-Buy'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and total number of reviews for the 'Home Scouting\u00ae MLS Mobile' app?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE App = 'Home Scouting\u00ae MLS Mobile'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the ' FAMILY ' category and how many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the abeoCoder app and how many users have given reviews for it?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE App = 'abeoCoder'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received the highest rating and how many reviews do they have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and what is that rating?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'Family' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are listed as 'Free' on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 categories of apps with the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS AvgRating FROM playstore GROUP BY Category ORDER BY AvgRating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'BUSINESS' category have a rating above 3 and how many reviews do they have?",
    "SQL": "SELECT App, Reviews FROM playstore WHERE Category = 'BUSINESS' AND Rating > 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'EVENTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the LIFESTYLE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write a query to find the average rating of apps that are of type 'Free' and have been downloaded more than 1,000,000 times.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs > '1,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that are free and have more than 1 million reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Reviews > 1000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the PHOTOGRAHY category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Camera app have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Camera' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating above 4.0 and have more than 100,000 reviews? List their genres and content ratings.",
    "SQL": "SELECT Genres, `Content Rating` FROM playstore WHERE Rating > 4.0 AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all finance apps on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 apps with the highest rating in the 'Family' category and their respective ratings?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps have received positive sentiment reviews?",
    "SQL": "SELECT COUNT(DISTINCT 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'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the SHOPPING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the PERSONALIZATION category, and which apps have a rating higher than the average?",
    "SQL": "SELECT AVG(Rating) AS avg_rating, App FROM playstore WHERE Category = 'PERSONALIZATION' HAVING Rating > avg_rating",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and the number of reviews for all apps in the COMMUNICATION category?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written positive reviews for the 'Florida HSMV Driver License' app? Additionally, what is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Florida HSMV Driver License' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the medical apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique genres are there in the playstore table?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category that are free to download?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a content rating of 'Everyone' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE `Content Rating` = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have been downloaded over 100 million times? What is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Installs = '100,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category and how many of these apps have more than 500 reviews?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive review for the FG Finder app?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'FG Finder' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps with a rating of 4.5 or higher are there in the Travel and Local category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 3 apps with the highest reviews on the Play Store?",
    "SQL": "SELECT App, Reviews FROM playstore ORDER BY Reviews DESC LIMIT 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category with more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users holds positive attitude towards the Pocket RxTx Pro app? Indicate the app's rating on the Google Play Store.",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Pocket RxTx Pro' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users who have given a positive sentiment towards the 'Honkai Impact 3rd' app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Honkai Impact 3rd' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Homescapes app, and how many reviews does it have?",
    "SQL": "SELECT AVG(T1.Rating), T1.Reviews FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Homescapes'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH & FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'BUSINESS' category? List all the translated reviews for each app with a positive sentiment.",
    "SQL": "SELECT DISTINCT Translated_Review FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE Category = 'BUSINESS' ) AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating? Show the average rating of that category.",
    "SQL": "SELECT Category, AVG(Rating) as Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the `Be you GO Launcher Theme` app on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Be you GO Launcher Theme'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Casual' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Casual'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category and how many of these apps have more than 10,000 reviews?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'HEALTH_AND_FITNESS' AND T1.Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Galway Gift app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Galaxy Gift' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'GAME' category have a rating higher than 4.5 and have over 1 million reviews?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating > 4.5 AND Reviews > 1000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app 'CE Smart' and what is the average rating of all apps in the same category?",
    "SQL": "SELECT T1.Genres, AVG(T1.Rating) FROM playstore AS T1 WHERE T1.App = 'CE Smart' OR T1.Category = ( SELECT Category FROM playstore WHERE App = 'CE Smart' )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the EO Hub app have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'EO Hub' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category with more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and what is the average rating of these games?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative review for the Freeme Launcher\u2014Stylish Theme app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Freeme Launcher\u2014Stylish Theme' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category and how many apps are there in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FOOD_AND_DRINK category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the CATEGORY 'SHOPPING' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Superbrothers Sword & Sworcery game on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Superbrothers Sword & Sworcery'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and are free?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the Petals 3D live wallpaper app with a rating between 4 and 5? What is the average size of this app?",
    "SQL": "SELECT COUNT(T1.Rating), AVG(REPLACE(trim(T1.Size, 'M'), ',', '')) FROM playstore AS T1 WHERE T1.App = 'Petals 3D live wallpaper' AND T1.Rating BETWEEN 4 AND 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that have more than 50 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Reviews > 50",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a positive sentiment in their reviews and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that are of type 'Paid'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating in the 'playstore' table?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps are there in the playstore?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have left a positive review for the 2048(AI) game and what is the average rating of this game based on the reviews?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = '2048(AI)' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the Sports category with more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the HD Themes Toyota Cruiser 60 app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'HD Themes Toyota Cruiser 60'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what can we get for free on the play store",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Travel and Local' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'PERSONALIZATION' category have a rating of at least 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'PERSONALIZATION' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a positive sentiment review and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Social' category have a rating higher than 4? Also, provide the average rating for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'SOCIAL' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have over 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH AND FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category that have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'DATING' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category and how many apps have a rating higher than 4.5?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'EDUCATION' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Provide the average rating of apps that have over 100 reviews.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and how many reviews does the app with the highest rating have?",
    "SQL": "SELECT AVG(T1.Rating), T2.Reviews FROM playstore AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T1.Category = 'TOOLS' AND T1.Rating = ( SELECT MAX(Rating) FROM playstore WHERE Category = 'TOOLS' )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category with more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'playstore' table have a rating greater than 4.0 and what are their categories?",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the total number of reviews and average rating of the app 'FRONTLINE COMMANDO: D-DAY'?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'FRONTLINE COMMANDO: D-DAY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Easy Hair Style Design app and what is the average rating of these users?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Easy Hair Style Design' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category and how many of them are priced above $10?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'GAME' AND Price > '$10'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Digit Save Money Automatically' app have?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Digit Save Money Automatically' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the BEAUTY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BEAUTY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0? What is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Ei-ij Spelling Dutch' app and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Ei-ij Spelling Dutch'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and are available on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating among those with a content rating of 'Everyone'?",
    "SQL": "SELECT App FROM playstore WHERE `Content Rating` = 'Everyone' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games available on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and number of reviews for apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating in the playstore?",
    "SQL": "SELECT Category, AVG(Rating) AS avg_rating FROM playstore GROUP BY Category ORDER BY avg_rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'VIDEO_PLAYERS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written a positive review for the PUBG MOBILE app? Also, provide the average rating of the app based on the reviews.",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'PUBG MOBILE' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher? Provide the average number of reviews for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and number of reviews for apps in the category 'BUSINESS'?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Game' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which game category has the highest average rating?",
    "SQL": "SELECT Category FROM playstore WHERE Category = 'GAME' GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a neutral sentiment towards the '\u0130\u015fCep' app and what is its rating on the Google Play Store?",
    "SQL": "SELECT COUNT(T1.Rating), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = '\u0130\u015fCep' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment towards the app 'EY Conferences' and what is the rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'EY Conferences' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'MAPS_AND_NAVIGATION' category and what is the average rating for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Family' category and how many of them have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH AND FITNESS' category and how many positive reviews do they have?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T2.Sentiment) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'HEALTH AND FITNESS' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the ART_AND_DESIGN category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 4.5 or higher and at least 10,000 reviews?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Rating >= 4.5 AND Reviews >= 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating on the Google Play Store?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'DEER HUNTER 2018' game?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'DEER HUNTER 2018'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS avg_rating FROM playstore GROUP BY Category ORDER BY avg_rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a content rating of 'Teen' and what is their average rating?",
    "SQL": "SELECT AVG(T1.Rating), T1.App FROM playstore AS T1 WHERE T1.`Content Rating` = 'Teen'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Instagram' app in the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a 'Rating' greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 3.5? Please list their names and genres.",
    "SQL": "SELECT App, Genres FROM playstore WHERE Rating > 3.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps are available in the playstore and what is their average rating?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that belong to the 'GAME' category and have more than 5 million reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 5000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Drunks Dz - Algeria app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Drinks Dz - Algeria' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most rated applications in the playstore?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category? Please list one negative review for each app, if there's any.",
    "SQL": "SELECT AVG(T1.Rating), T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'TOOLS' AND T2.Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and are of type 'Free'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of sports apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PHOTOGRAPHY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are marked as 'Paid' on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive user reviews exist for the 'DC All Access' app?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'DC All Access' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category and what is the total number of apps in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FINANCE' category? ",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the Prestige AH app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Prestige AH' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment about the BlackJack 21 Pro app?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'BlackJack 21 Pro' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Dare EMS Protocols' app on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Dare EMS Protocols'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the SPORTS category and what is the maximum number of reviews for these apps?",
    "SQL": "SELECT AVG(Rating), MAX(Reviews) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'EVENTS' category have a rating greater than 3?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'EVENTS' AND Rating > 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of medical apps available on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category? Also, list the apps with a rating higher than 4.0.",
    "SQL": "SELECT AVG(Rating), App FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.0 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all medical apps in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the total number of reviews and average rating for the app 'PopStar'?",
    "SQL": "SELECT COUNT(Reviews), AVG(Rating) FROM playstore WHERE App = 'PopStar'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5? Provide the average rating for these apps.",
    "SQL": "SELECT AVG(Rating), App FROM playstore WHERE Rating > 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating in the 'BUSINESS' category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written positive reviews for the Age of Conquest: N. America app and what is the average rating of these users?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Age of Conquest: N. America' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the Photography category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and total reviews for the 'Diary with lock password' app?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE App = 'Diary with lock password'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories of apps are there in the Play Store?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.0 and belong to the 'utilities' category? How many reviews does each of these apps have?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.0 AND Category = 'utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY Category ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The average rating of apps in the Music & Audio category. ",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MUSIC & AUDIO'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PARENTING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is its category?",
    "SQL": "SELECT App, Category FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized as 'GAME' and have a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different categories of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Category) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the COMMUNICATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Education'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and the count of reviews for the 'GlassesOff' app?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'GlassesOff'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the Play Store have a content rating of 'Everyone' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE `Content Rating` = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category with more than 1 million reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 1000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH AND FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and what is the average size of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Size) FROM playstore WHERE Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category? Please list one positive review for each app, if available.",
    "SQL": "SELECT AVG(T1.Rating), T2.Translated_Review FROM playstore AS T1 LEFT JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'BUSINESS' AND T2.Sentiment = 'Positive' GROUP BY T1.App LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have been reviewed with a rating greater than 4.0 and what are their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category with at least 5 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Reviews >= 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps with a rating above 4.0 have been downloaded over 10 million times?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating > 4.0 AND Installs LIKE '%10 million+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Sports' category and how many apps are there in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'DATING' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the AutoCAD - DWG Viewer & Editor app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'AutoCAD - DWG Viewer & Editor'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are rated higher than 4.0 on the Google Play Store?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that are not free?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type != 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category and how many of them have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'GAME' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or above in the playstore and what are their respective genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating >= 4.5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'TOOLS' category and have a rating greater than 4.0? List the average rating of these apps.",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps with a rating greater than 4.5 are there in the 'FAMILY' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have over 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews are there for the 'Facebook' app on the Google Play Store?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and how many apps are there in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'free' type and a rating greater than 4.0?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Type = 'Free' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the MUTV - Manchester United TV app and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'MUTV - Manchester United TV' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'K PLUS' app in the 'FINANCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'K PLUS' AND Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the DATING category and how many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have neutral sentiments towards the app Tastely and what is its rating on the Google Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Tastely' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and what is their average size?",
    "SQL": "SELECT COUNT(App), AVG(Size) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Ghost Snap AR Horror Survival game and what is its rating on the Google Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Ghost Snap AR Horror Survival' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'LIFESTYLE' category have been installed over 10,000 times?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'LIFESTYLE' AND Installs > '10,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'ENTERTAINMENT' category have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'FAMILY' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are available in the FAMILY category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4 and what is their average review count?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are categorized as 'GAME' and have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the DATING category have more than 200,000 reviews and what is their average rating?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'DATING' AND Reviews > 200000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and have been downloaded more than 1 million times? List the app names, ratings, and the number of downloads for these apps.",
    "SQL": "SELECT App, Rating, Installs FROM playstore WHERE Rating > 4.5 AND Installs > '1,000,000' LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what is their average size?",
    "SQL": "SELECT COUNT(App), AVG(REPLACE(Size, 'M', '')) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating and what is the average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what are their average reviews?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the Finance category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Tagged - Meet, Chat & Dating' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Tagged - Meet, Chat & Dating'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating above 4.0 and what is the average number of reviews for these apps?",
    "SQL": "SELECT AVG(Reviews), App FROM playstore WHERE Rating > 4.0 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative sentiment towards the Bloomberg Professional app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Bloomberg Professional' AND T2.Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH & FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH & FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the FP Markets app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'FP Markets'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive rating for the Google PDF Viewer app?",
    "SQL": "SELECT COUNT(Rating) FROM playstore WHERE App = 'Google PDF Viewer' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'BUSINESS' category and what is the average rating for those apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'GAME' category have a rating above 4.0, and what are the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Category = 'GAME' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average sentiment polarity among user reviews and what is the average sentiment polarity?",
    "SQL": "SELECT App, AVG(Sentiment_Polarity) AS Average_Polarity FROM user_reviews GROUP BY App ORDER BY Average_Polarity DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written positive reviews for the Video Editor app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Video Editor' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Harry Potter and the Chamber of Secrets' app on the Google Play Store?",
    "SQL": "SELECT AVG(T1.Rating) FROM playstore AS T1 WHERE T1.App = 'Harry Potter and the Chamber of Secrets'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the games category in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews do the Birmingham City FC app have and what is its genre?",
    "SQL": "SELECT COUNT(T2.Sentiment), T1.Genres FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Birmingham City FC' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category that are free to download?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Amazon Appstore' have? What is its rating?",
    "SQL": "SELECT Reviews, Rating FROM playstore WHERE App = 'Amazon Appstore'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.0 and are categorized under 'GAME'? List their prices.",
    "SQL": "SELECT App, Price FROM playstore WHERE Rating > 4.0 AND Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are there in the playstore database?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'FAMILY' category have a rating of 4.5 or higher and what are their genres?",
    "SQL": "SELECT App, Genres FROM playstore WHERE Category = 'FAMILY' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Create A Superhero HD' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Create A Superhero HD'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 and are in the 'utilities' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 4.5 AND Category = 'UTILITIES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many reviews do they have in total?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating in the TRAVEL_AND_LOCAL category?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4? What is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all free apps in the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a positive sentiment review and what is their average rating?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category and how many apps fall into this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 5000 reviews and are of type 'Free'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 5000 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have been downloaded more than 10 million times and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Installs = '10,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all free games in the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps received a perfect 5-star rating?",
    "SQL": "SELECT App FROM playstore WHERE Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating given to an app in the playstore?",
    "SQL": "SELECT MAX(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a content rating of 'Everyone' and what are their average ratings?",
    "SQL": "SELECT AVG(Rating), App FROM playstore WHERE 'Content Rating' = 'Everyone' GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'GAME' category and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app 'HPlus'? ",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'HPlus'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the app 'Ex Quotes'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Ex Quotes'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users hold a positive sentiment towards the app 'Flickr'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Flickr' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Lifestyle' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Lifestyle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category? Please also provide a list of the app names that have the highest reviews.",
    "SQL": "SELECT AVG(Rating), App FROM playstore WHERE Category = 'ENTERTAINMENT' GROUP BY App ORDER BY Reviews DESC LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are there in the playstore? List one app for each genre.",
    "SQL": "SELECT COUNT(DISTINCT Genres), App FROM playstore GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are 'Free' in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'Books and Reference' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS AND REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'GAME' category have a rating above 3.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 3.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the Guns of Glory app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Guns of Glory' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category that have more than 100,000 installs?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Installs > '1,000,000'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Calorie Counter - MyFitnessPal app? Indicate the app's rating on the Google Play Store.",
    "SQL": "SELECT COUNT(T1.Rating), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Calorie Counter - MyFitnessPal' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rating of an app in the 'GAME' category on the Google Play Store?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received reviews with a sentiment polarity between 0.5 and 1?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment_Polarity BETWEEN 0.5 AND 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps have been reviewed on the Play Store with a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the JOANN - Crafts & Coupons app have on the Google Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'JOANN - Crafts & Coupons'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a 'Free' type and a 'Content Rating' of 'Everyone'?",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND 'Content Rating' = 'Everyone'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the Deep Breathe BP app have, and what is its average rating?",
    "SQL": "SELECT Reviews, AVG(Rating) FROM playstore WHERE App = 'Deep Breathe BP'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating of 5 and what are their respective genres?",
    "SQL": "SELECT COUNT(App), Genres FROM playstore WHERE Rating = 5 GROUP BY Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5.0 and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating = 5.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are some examples of apps with a rating higher than 4.0, and what is their genre?",
    "SQL": "SELECT App, Genres FROM playstore WHERE Rating > 4.0 LIMIT 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest user reviews and what is their average rating?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a 'Free' type and an average rating greater than 4.0?",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type = 'Free' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the 'Draw a Stickman: EPIC 2' app with 5 stars?",
    "SQL": "SELECT COUNT(Rating) FROM playstore WHERE App = 'Draw a Stickman: EPIC 2' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest rating and their average reviews?",
    "SQL": "SELECT App, AVG(Reviews) FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Labs on Demand app?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Labs on Demand' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive sentiment towards the CDL Practice Test 2018 Edition app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'CDL Practice Test 2018 Edition' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'BL-ED: From BLUE to RED' app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'BL-ED: From BLUE to RED'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users hold a negative sentiment towards the Emmanuella Funny Videos 2018 app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Emmanuella Funny Videos 2018' AND T2.Sentiment_Polarity < 0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a neutral review to the Golden Dictionary (EN-AR) app and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(Sentiment_Polarity), AVG(Rating) FROM user_reviews AS T1 INNER JOIN playstore AS T2 ON T1.App = T2.App WHERE T2.App = 'Golden Dictionary (EN-AR)' AND Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users had a neutral sentiment towards the Call Blocker & Blacklist app? Provide the average rating of the app.",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Call Blocker & Blacklist' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have left positive reviews for the 'dk Verk' app, and what is its average rating?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'dk Verk' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps with a rating greater than 4.0 and how many such apps are there in each category?",
    "SQL": "SELECT Category, COUNT(App) FROM playstore WHERE Rating > 4.0 GROUP BY Category",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'PERSONALIZATION' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users has the game 'Doomsday Preppers\u2122' received a rating of 5 on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE App = 'Doomsday Preppers\u2122' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of app has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY Category ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'WEATHER' category have more than 1,000,000 installs?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'WEATHER' AND Installs > '1,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH_AND_FITNESS' category that have more than 100 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Reviews > 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'HEALTH_AND_FITNESS' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'High Blood Pressure Symptoms' have on the Google Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'High Blood Pressure Symptoms'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the number of reviews for the app Cube BR LWP simple? ",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Cube BR LWP simple'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many games have a rating of 4.5 or higher in the Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'COMMUNICATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all free apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.5? Display the app names and their respective ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category and how many apps are there in that category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what are their average number of reviews?",
    "SQL": "SELECT AVG(Reviews), COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category and how many users have rated it?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the top 3 most reviewed apps in the 'FAMILY' category and what are their average ratings?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) AS Average_Rating FROM playstore AS T1 WHERE T1.Category = 'FAMILY' GROUP BY T1.App ORDER BY T1.Reviews DESC LIMIT 3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Hemnet app? Also, provide the translated review and the sentiment polarity for each positive review.",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), Translated_Review, Sentiment_Polarity FROM user_reviews AS T2 WHERE App = 'Hemnet' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are in the 'SPORTS' category and have a rating greater than 4.0?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which social media app has the highest rating and how many reviews does it have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore WHERE Category = 'SOCIAL' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Break the Egg app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Break the Egg' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the Personalization category and what is the app with the highest rating in this category?",
    "SQL": "SELECT AVG(Rating), App FROM playstore WHERE Category = 'PERSONALIZATION' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'TOOLS' category have a rating higher than 4.0 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.0? Show the average number of reviews for these apps.",
    "SQL": "SELECT AVG(Reviews), App FROM playstore WHERE Rating > 4.0 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Mobile Security & Anti-Virus' category apps on the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MOBILE SECURITY & ANTI- VIRUS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'DreamMapper' app from user reviews?",
    "SQL": "SELECT AVG(Sentiment_Polarity) FROM user_reviews WHERE App = 'DreamMapper'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users had a positive sentiment towards the `Bikinibottom` app and what is its average rating?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Bikinibottom' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Fitness & Nutrition' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FITNESS &amp; NUTRITION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category that have more than 5 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Reviews > 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have more than 10,000 reviews and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and how many reviews do they have in total?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are there in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'LIBRARIES_AND_DEMO' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category? Please provide one translated review with a positive sentiment for an app in this category, if available.",
    "SQL": "SELECT AVG(Rating), T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FAMILY' AND T2.Sentiment = 'Positive' LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category and how many reviews do they have in total?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all sports apps on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have received a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FOOD_AND_DRINK' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App) , AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The app Fallout Shelter received one translated review with positive sentiment. Can you show me the translated review for Fallout Shelter?",
    "SQL": "SELECT Translated_Review FROM user_reviews WHERE App = 'Fallout Shelter' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps in the 'BUSINESS' category have a rating greater than 4.0? List their names and ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'BUSINESS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FAMILY' category and have a rating higher than 4?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher in the 'GAME' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all free apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many applications in the 'PERSONALIZATION' category have a rating of '5' and what is the average rating of these applications?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized as 'GAME' and have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a rating of 4.5 or higher to the Glide - Video Chat Messenger app, and what was the average rating of these users?",
    "SQL": "SELECT COUNT(T1.Rating), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Glide - Video Chat Messenger' AND T1.Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free games on the Play Store have been rated above 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Rating > 4.5 AND Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are categorized as 'ENTERTAINMENT'? Show the result with 2 decimal places.",
    "SQL": "SELECT ROUND(AVG(Rating), 2) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Games' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many games have a rating higher than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Games' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'Games'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and are of the type 'Paid'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0 AND Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category and how many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(*) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a negative sentiment towards the Google Classroom app, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Google Classroom' AND T2.Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'Content Rating' of 'Adult' and how many have a 'Content Rating' of 'Everyone'?",
    "SQL": "SELECT COUNT(CASE WHEN `Content Rating` = 'Adult' THEN 1 END) AS 'Adult Content Rating', COUNT(CASE WHEN `Content Rating` = 'Everyone' THEN 1 END) AS 'Everyone Content Rating' FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0? Also, list the names of these apps.",
    "SQL": "SELECT COUNT(App), App FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'LIBRARIES_AND_DEMO' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Personalization' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated the Golfshot: Golf GPS + Tee Times app positively with a rating of 5?",
    "SQL": "SELECT COUNT(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Golfshot: Golf GPS + Tee Times' AND T2.Sentiment = 'Positive' AND T1.Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.0 and have received more than 1 million reviews? Please list the translated reviews for each app if available.",
    "SQL": "SELECT DISTINCT Translated_Review FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE Rating > 4.0 AND Reviews > 1000000 )",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The average rating of apps that have more than 1000 reviews",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated 'Millionaire Quiz Free: Be Rich' app 4.5 or above and what is the average rating of these users?",
    "SQL": "SELECT COUNT(Rating), AVG(Rating) FROM playstore WHERE App = 'Millionaire Quiz Free: Be Rich' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 50000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore that have more than 100 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the most popular app genres based on the number of apps in each genre?",
    "SQL": "SELECT Genres, COUNT(App) FROM playstore GROUP BY Genres ORDER BY COUNT(App) DESC",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games have a rating of at least 4.0 and have had over 100,000 reviews? Please list the game names along with their rating and reviews.",
    "SQL": "SELECT App, Rating, Reviews FROM playstore WHERE Category = 'GAME' AND Rating >= 4.0 AND Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have a price of more than 0?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price > 0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the rating of the app 'Fun Cube 2' in the playstore",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Fun Cube 2'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Category' genre that have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Category' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.5 and what are their genres?",
    "SQL": "SELECT App, Genres FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The ______ app has received the highest rating. What is the rating of this app?",
    "SQL": "SELECT Rating FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the app 'Fate/Grand Order (English)' have and what is its category?",
    "SQL": "SELECT Reviews, Category FROM playstore WHERE App = 'Fate/Grand Order (English)'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PHOTOGRAPHY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different types of apps are in the 'Games' category?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all games on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Travel and Local' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its category?",
    "SQL": "SELECT App, Category FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have received a rating of 4.0 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating on the Google Play Store?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free applications are there in the play store that have more than 1000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating in the 'TOOLS' category and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'TOOLS' ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'Play Games' in the 'Family' category?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Play Games' AND Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps are available in the 'TOOLS' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The app Fuelio: Gas log & costs has a translated review stating 'Nice App!!'. How many reviews has this app received that are positive in sentiment?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Fuelio: Gas log & costs' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all finance apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY Category ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a rating higher than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average ratings of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are in the 'BUSINESS' category and have more than 10 reviews? Please list the app names and their ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'BUSINESS' AND Reviews > 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a review for the Foody Cyprus - online ordering app and what is its average rating?",
    "SQL": "SELECT COUNT(T1.App), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'foody Cyprus - online ordering'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the USMLE Step 2 CK Flashcards app and what is its price?",
    "SQL": "SELECT AVG(Rating), Price FROM playstore WHERE App = 'USMLE Step 2 CK Flashcards'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category? List all reviews from the 'ADW Launcher 2' app, including the sentiment and polarity.",
    "SQL": "SELECT AVG(Rating), Sentiment, Sentiment_Polarity FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE Category = 'FAMILY' AND T1.App = 'ADW Launcher 2'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category and how many reviews do they have on average?",
    "SQL": "SELECT AVG(Rating), AVG(Reviews) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'BUSINESS' category with a rating of 'None'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'BUSINESS' AND Rating = 'None'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed the BGCN TV app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.App), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.App = 'BGCN TV'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps in the playstore have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category and how many users have given a positive review for the 'Facebook' app?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T2.Sentiment) FROM playstore AS T1 LEFT JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'Social' AND T1.App = 'Facebook' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a neutral sentiment towards the 'Fruit Block - Puzzle Legend' app? Also, display the average rating of this app based on the playstore data.",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Fruit Block - Puzzle Legend' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category with more than 500 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Reviews > 500",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the apps that belong to the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its rating?",
    "SQL": "SELECT App, Rating FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SHOPPING' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'GAME' category have a rating of 4.5 or higher? Retrieve the average review count for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Category = 'GAME' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'SOCIAL' category, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Auto and Vehicles' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive rating to the 'Common Core' app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Common Core' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment towards the Hopper - Watch & Book Flights app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Hopper - Watch & Book Flights' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are in the 'ENTERTAINMENT' category and have a rating higher than 4.0?",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ENTERTAINMENT' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'COMICS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMICS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FAMILY' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category with more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the CB SmartCAR Monitor app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'CB SmartCAR Monitor'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOYS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOYS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are categorized under 'ENTERTAINMENT' and have a rating greater than 4.0? Also, provide the number of reviews for each of these apps.",
    "SQL": "SELECT App, COUNT(Reviews) FROM playstore WHERE Category = 'ENTERTAINMENT' AND Rating > 4.0 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category and how many reviews do they have in total?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Educational' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'EDUCATIONAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many dating apps have a rating higher than 4.0?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'DATING' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free games have a rating above 4.5 on the Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Category = 'GAME' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'SayHi Chat, Meet New People' app based on user reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'SayHi Chat, Meet New People'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received a rating higher than 4.5, and how many such apps are there?",
    "SQL": "SELECT COUNT(App) AS NumApps FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PRODUCTIVITY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the DC Super Hero Girls\u2122 app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'DC Super Hero Girls\u2122' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive review (Sentiment_Polarity greater than 0.5) for the Cy-Reader app?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'Cy-Reader' AND Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the COMMUNICATION category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Health & Fitness' category have received a rating of 4.5 or higher? Provide the average number of reviews for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Category = 'HEALTH & FITNESS' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have positive sentiment towards the Street Panorama View app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Street Panorama View' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received positive sentiment reviews in the user_reviews table?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which game apps have a rating greater than 4.0 and what is the average review count for these apps?",
    "SQL": "SELECT AVG(Reviews) FROM playstore WHERE Category = 'GAME' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and how many apps are there in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the Fun Kid Racing - Motocross app as 4.1 and what is the average rating of the app?",
    "SQL": "SELECT COUNT(Rating), AVG(Rating) FROM playstore WHERE App = 'Fun Kid Racing - Motocross' AND Rating = 4.1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest number of apps with a rating of 5? Also, list one app from this category.",
    "SQL": "SELECT Category, App FROM playstore WHERE Rating = 5 GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'Business' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed the AfterFocus app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Translated_Review), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'AfterFocus'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the British Airways app have and what is its rating?",
    "SQL": "SELECT COUNT(T2.Sentiment), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'British Airways' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category of apps has the highest average rating and what is that average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY Category ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave positive reviews to the ABC News - US & World News app and what was the average rating of these reviews?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'ABC News - US & World News' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment towards the F&M Bank - EZ Banking app?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'F&M Bank - EZ Banking' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive review for the OnePlus Launcher app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'OnePlus Launcher' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and how many have a rating less than 5?",
    "SQL": "SELECT SUM(CASE WHEN Rating = 5 THEN 1 ELSE 0 END) AS Rating_5, SUM(CASE WHEN Rating < 5 THEN 1 ELSE 0 END) AS Below_Rating_5 FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Instagram app and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Instagram'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps have been rated above 4.0 in the playstore?",
    "SQL": "SELECT COUNT(DISTINCT App) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are rated '4.5' or higher and what is the total number of such apps?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PARENTING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PARENTING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Google My Business app and what is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Google My Business' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the Cool Popular Ringtones 2018 \ud83d\udd25 app have?",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'Cool Popular Ringtones 2018 \ud83d\udd25' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the Sports category have a rating greater than 4.5 on the Google Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'SPORTS' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is its category?",
    "SQL": "SELECT App, Category FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'GAME' category and how many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Angry Birds Classic' app and how many reviews it has received?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Angry Birds Classic'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0 and belong to the 'SOCIAL' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'SOCIAL' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written positive reviews for the Slack app and what is its average rating?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Slack' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users gave a positive sentiment review for the app 'BBW Dating & Plus Size Chat'?",
    "SQL": "SELECT COUNT(Sentiment_Polarity) FROM user_reviews WHERE App = 'BBW Dating & Plus Size Chat' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews are negative for the app 'Cool Popular Ringtones 2018 \ud83d\udd25'?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Cool Popular Ringtones 2018 \ud83d\udd25' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4 and how many reviews do they have?",
    "SQL": "SELECT COUNT(App), SUM(Reviews) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the C++ Tutorials app and how many reviews it has received?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'C++ Tutorials'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users holds neutral attitude towards the 7 Minute Workout app? Indicate the app's rating on the Google Play Store.",
    "SQL": "SELECT COUNT(T1.Rating), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = '7 Minute Workout' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the AK 47 Assault Rifle Wallpapers app based on user reviews?",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'AK 47 Assault Rifle Wallpapers'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are available in the FAMILY category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category? How many users have reviewed these apps?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'SPORTS' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health & Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH & FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating above 4.0? Also, provide the names and genres of these apps.",
    "SQL": "SELECT COUNT(App), App, Genres FROM playstore WHERE Rating > 4.0 GROUP BY App, Genres",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have been rated higher than 4.5 by users and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are both in the 'GAME' category and have more than 100 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 100",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the educational games for kids category on the play store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category that have more than 10 reviews and are rated above 3.5?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Reviews > 10 AND Rating > 3.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards Candy Crush Soda Saga? Also, list all their translated reviews.",
    "SQL": "SELECT COUNT(T2.Sentiment), T2.Translated_Review FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Soda Saga' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is its content rating?",
    "SQL": "SELECT App, `Content Rating` FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'LIFESTYLE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category with more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Health & Fitness' category have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'VIDEO_PLAYERS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Trulia Rent Apartments & Homes app? What is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Trulia Rent Apartments & Homes' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0 and belong to the 'GAME' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0 AND Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the BOOKS_AND_REFERENCE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FINANCE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is the average sentiment polarity of its reviews?",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App ORDER BY T1.Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FINANCE' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category that are priced less than $1?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools' AND Price < '$1'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the J-Novel Club app have on the Google Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'J-Novel Club'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the category 'PHOTOGRAPHY'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many negative reviews does the Ecobank Mobile Banking app have?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Ecobank Mobile Banking' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Family' category have a rating above 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'FAMILY' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Social' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users hold a positive sentiment towards the 'RGN CI-Control' app? Also, what is the average rating of this app on the Google Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' AND T1.App = 'RGN CI-Control'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the DATING category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app in the 'PRODUCTIVITY' category has the highest rating and what is the average rating of all apps in that category?",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY' GROUP BY App ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have rated the FH App as 5 stars and what is the average rating of all users for this app?",
    "SQL": "SELECT COUNT(Rating), AVG(Rating) FROM playstore WHERE App = 'FH App' AND Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'SHOPPING' category and what is the most common sentiment from user reviews for these apps?",
    "SQL": "SELECT AVG(Rating), Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'SHOPPING' GROUP BY Sentiment ORDER BY COUNT(Sentiment) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category and how many apps are there in total?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'EDUCATION' category that have a rating greater than 4.5 and how many of these apps have more than 10,000 reviews?",
    "SQL": "SELECT SUM(CASE WHEN Rating > 4.5 THEN 1 ELSE 0 END), SUM(CASE WHEN Reviews > 10000 THEN 1 ELSE 0 END) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category? Please list one translated review for each app in that category.",
    "SQL": "SELECT COUNT(App), Translated_Review FROM user_reviews WHERE App IN ( SELECT App FROM playstore WHERE Category = 'GAME' ) GROUP BY App LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given positive reviews for the BMH-BJ Congregation app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'BMH-BJ Congregation' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps that have more than 1,000,000 reviews on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'BUSINESS' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'BUSINESS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.0 and have been installed by over 1 million users?",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND Installs > '1,000,000+'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the 'Google Analytics' app? What is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Google Analytics' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have the highest average ratings? List their names and average ratings.",
    "SQL": "SELECT App, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY App ORDER BY Avg_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating on the Google Play Store?",
    "SQL": "SELECT App FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and number of reviews for all apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category and how many such apps exist?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many user reviews for the Learn R Language Easy Way app are positive?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Learn R Language Easy Way' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the highest rated app in the playstore and its average user sentiment?",
    "SQL": "SELECT T1.App, AVG(T2.Sentiment_Polarity) AS Avg_Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App GROUP BY T1.App ORDER BY T1.Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The average rating of all games on the Play Store is ______.",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category that have more than 50000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and what is the highest number of reviews received by an app in the same category?",
    "SQL": "SELECT AVG(Rating), MAX(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating of 4.5 or higher and their average reviews count?",
    "SQL": "SELECT App, AVG(Reviews) FROM playstore WHERE Rating >= 4.5 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the BeSoccer - Soccer Live Score app and what is its average rating on the Google Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'BeSoccer - Soccer Live Score' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the PERSONALIZATION category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'Tools' category have more than 50,000 reviews? List the average rating of these apps.",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a 'Positive' sentiment in user reviews and what are their average ratings?",
    "SQL": "SELECT T1.App, AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' GROUP BY T1.App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the DATING apps and how many such apps are there?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Majestic Cinema CI' app on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Majestic Cinema CI'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the V380s app have, and what is the average rating of this app?",
    "SQL": "SELECT Reviews, AVG(Rating) FROM playstore WHERE App = 'V380s'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a positive sentiment in their reviews?",
    "SQL": "SELECT DISTINCT T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the sports category and how many reviews do they have?",
    "SQL": "SELECT AVG(T1.Rating), SUM(T1.Reviews) FROM playstore AS T1 WHERE T1.Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the COMMUNICATION category and how many apps fall into this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free games are there in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users with positive sentiment have reviewed the 'Manga Rock - Best Manga Reader' app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE Sentiment = 'Positive' AND App = 'Manga Rock - Best Manga Reader'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category and have more than 500,000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users who gave a rating of 4.5 or above have downloaded the 'Swagbucks' app? Provide the average rating of these users.",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Swagbucks' AND T1.Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the 'Clash of Clans' app and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' AND T1.App = 'Clash of Clans'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and number of reviews for apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the EZ Financial Calculator app?",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'EZ Financial Calculator' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and the count of reviews for the app 'Bad Piggies'?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE App = 'Bad Piggies'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Utilities' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Cash App in the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Cash App'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating and the total number of reviews for the 'Spotify Music' app?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE App = 'Spotify Music'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have positive reviews for the 7 Minute Workout app?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = '7 Minute Workout' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating of apps in the 'FAMILY' category and what is the most common sentiment in user reviews for these apps?",
    "SQL": "SELECT AVG(T1.Rating), T2.Sentiment FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Category = 'FAMILY' GROUP BY T2.Sentiment",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating and how many reviews does it have?",
    "SQL": "SELECT App, AVG(Rating) as AvgRating, SUM(Reviews) as TotalReviews FROM playstore GROUP BY App ORDER BY AvgRating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized as 'MAPS' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'MAPS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ART_AND_DESIGN' category? How many apps are in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'ART_AND_DESIGN'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many games are available in the playstore and what is their average rating?",
    "SQL": "SELECT COUNT(T1.App), AVG(T1.Rating) FROM playstore AS T1 WHERE T1.Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the BEAUTY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BEAUTY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the maximum rating of the medical apps available on the Play Store?",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'FAMILY' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Entertainment' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Entertainment'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category with more than 2000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Reviews > 2000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The total number of positive reviews for the EyeCloud app",
    "SQL": "SELECT COUNT(Translated_Review) FROM user_reviews WHERE App = 'EyeCloud' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Productivity' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating higher than 4.0 and what are their categories?",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category and their size? Please list them in descending order based on the size.",
    "SQL": "SELECT AVG(Rating), Size FROM playstore WHERE Category = 'GAME' GROUP BY Size ORDER BY Size DESC",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'GAME' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category and what is the most common content rating for these apps?",
    "SQL": "SELECT AVG(Rating), 'Content Rating' FROM playstore WHERE Category = 'FAMILY' GROUP BY 'Content Rating' ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are categorized as 'FINANCE' and have more than 1,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the average rating of apps in the business category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are free and have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps are categorized as 'GAME' and have a rating greater than 4.0? List their names and genres.",
    "SQL": "SELECT App, Genres FROM playstore WHERE Category = 'GAME' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Games' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'BOOKS_AND_REFERENCE' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated the Dr. Panda Art Class app with a rating of 4.5 or higher, and what is the average price of this category of apps?",
    "SQL": "SELECT COUNT(CASE WHEN T1.Rating >= 4.5 THEN 1 ELSE NULL END), AVG(REPLACE(trim(T1.Price, '$'), ',', '')) FROM playstore AS T1 WHERE T1.Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and what is the average rating of these games?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'BK Manager' app and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'BK Manager'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the category 'TOOLS'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'VIDEO_PLAYERS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating on the Google Play Store?",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore GROUP BY App ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the BUSINESS category with at least 10 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS' AND Reviews >= 10",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the playstore apps that are of type 'Free'?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Princess Adventures Puzzles' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Princess Adventures Puzzles'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating of 5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'HEALTH_AND_FITNESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Target - now with Cartwheel app?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Target - now with Cartwheel'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'PHOTOGRAPHY' category have more than 1 review?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Reviews > 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the Shopping category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which is the most reviewed app?",
    "SQL": "SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating?",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY AVG(Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.0 or higher and belong to the 'Utilities' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating >= 4.0 AND Category = 'Utilities'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the rating of the app 'LineStar for FanDuel' on the Google Play Store?",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'LineStar for FanDuel'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Health & Fitness' category and have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Category = 'HEALTH & FITNESS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'HEALTH_AND_FITNESS' category and have a rating higher than 4.5? List the names of these apps along with their ratings.",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the Lifestyle category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating greater than 4.5 and what are their categories?",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the Health & Fitness category have a rating of 4.8 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating >= 4.8",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The question goes here.",
    "SQL": "SELECT * FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free apps are there in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and are of type 'Paid'? ",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating among those with more than 10 reviews?",
    "SQL": "SELECT App, AVG(Rating) as AverageRating FROM playstore WHERE Reviews > 10 GROUP BY App ORDER BY AverageRating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and what is its category?",
    "SQL": "SELECT App, Category FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users holds neutral attitude towards the Geo Tracker - GPS tracker app and what is its price on the Google Play Store?",
    "SQL": "SELECT COUNT(T1.Price), T1.Price FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Geo Tracker - GPS tracker' AND T2.Sentiment = 'Neutral'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and the number of reviews for apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating), COUNT(Reviews) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Games' category? What is the most common type of app in this category?",
    "SQL": "SELECT AVG(Rating), TYPE FROM playstore WHERE Category = 'Games' GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a 'Social' category and what is the average rating for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating on the Google Play Store?",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the 'Robin - AI Voice Assistant' app on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Robin - AI Voice Assistant'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the free apps in the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The price of the GoPro Fusion Action Camera is $249.99. How many reviews does it have and what is its content rating?",
    "SQL": "SELECT Reviews, `Content Rating` FROM playstore WHERE App = 'GoPro Fusion Action Camera'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'COMMUNICATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps that have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'HEALTH_AND_FITNESS' category have a rating of 4.3 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Rating >= 4.3",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'Tools' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5, and what is the average number of reviews for these apps?",
    "SQL": "SELECT COUNT(App), AVG(Reviews) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the Infinity Dungeon VIP app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Infinity Dungeon VIP'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category that cost less than $1? ",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' AND Price < '$1'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'EDUCATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that are of the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Provide the number of apps that are part of the 'TOOLS' category and are free.",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'Galaxy Attack: Alien Shooter' app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'Galaxy Attack: Alien Shooter'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SOCIAL' category and how many such apps are there?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive sentiment to the app 'Mosaic puzzles' and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Mosaic puzzles' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'Tools' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are categorized as 'EDUCATION' in the Play Store and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have downloaded the FarmVille 2: Country Life app and what is its current rating?",
    "SQL": "SELECT SUM(Reviews), Rating FROM playstore WHERE App = 'FarmVille 2: Country Life'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many positive reviews does the 'Health and Nutrition Guide' app have and what is its overall rating?",
    "SQL": "SELECT COUNT(T2.Sentiment), T1.Rating FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Health and Nutrition Guide' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'TOOLS' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of dating apps in the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Write a query to list the names of all apps in the 'playstore' table that have a rating above 4.0 and belong to the 'TOOLS' category.",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0 and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which category has the highest average rating and what is the average rating?",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "what is the content rating of the app Noticias FC Barcelona",
    "SQL": "SELECT `Content Rating` FROM playstore WHERE App = 'Noticias FC Barcelona'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 100,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 100000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'Tools'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which games have a rating higher than 4.0 and what are their average reviews?",
    "SQL": "SELECT App, AVG(Reviews) AS Average_Reviews FROM playstore WHERE Category = 'GAME' AND Rating > 4.0 GROUP BY App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the COMMUNICATION category and how many apps are there?",
    "SQL": "SELECT AVG(T1.Rating), COUNT(T1.App) FROM playstore AS T1 WHERE T1.Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.5 in the playstore?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what are their average ratings?",
    "SQL": "SELECT COUNT(App) , AVG(Rating) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'playstore' table have a 'Rating' greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PRODUCTIVITY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'TOOLS' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PERSONALIZATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users like the 'Candy Crush Saga' app and what is its price on the Google Play Store?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), T1.Price FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Candy Crush Saga' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the HEALTH_AND_FITNESS category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'HOUSE_AND_HOME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all the apps in the 'GAME' category and their total number of reviews?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'BUSINESS' category, and how many of them are rated 4.5 or higher?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'BUSINESS' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Family' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Bangla Newspaper \u2013 Prothom Alo app?",
    "SQL": "SELECT COUNT(Sentiment) FROM user_reviews WHERE App = 'Bangla Newspaper \u2013 Prothom Alo' AND Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'MEDICAL' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users rated the Instagram app as 'Positive'? Indicate the average rating of the app.",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Instagram' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given the app 'Mosaic puzzles' a rating of 4.5 or higher?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE App = 'Mosaic puzzles' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating higher than 4.0 and are of the type 'Paid'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.0 AND Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'NEWS_AND_MAGAZINES' category? What is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres are present in the playstore dataset?",
    "SQL": "SELECT COUNT(DISTINCT Genres) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the Entertainment category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the FAMILY category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Describe a query that answers a natural language question about the playstore table.",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating > 4",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category that have more than 10,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating of more than 4.5 and belong to the GAME category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5 AND Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and belong to the 'SOCIAL' category? Provide the average rating for these apps.",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating >= 4.5 AND Category = 'SOCIAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Education' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the `DATING` category and how many apps are there in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'DATING'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Displaying You VR app? Also, provide the average rating of this app.",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Displaying You VR' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have downloaded the Kim Bu Youtuber? app and what is the average rating of this app?",
    "SQL": "SELECT COUNT(Installs), AVG(Rating) FROM playstore WHERE App = 'Kim Bu Youtuber?'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have a positive sentiment towards the Diary with lock app? Also, list the app's price.",
    "SQL": "SELECT COUNT(T2.Sentiment), T1.Price FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.App = 'Diary with lock' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the category 'BUSINESS' and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of games on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a negative review for the A-J Media Vault app and what is the average rating of the app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'A-J Media Vault' AND T2.Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the maximum rating of the apps in the LIFESTYLE category? ",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'TOOLS' category?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Business' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.5 or higher and are categorized under 'Utilities'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'Utilities' AND Rating >= 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average rating and total reviews of apps in the 'FINANCE' category?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the 'TOOLS' category have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "The average rating of the playstore apps is what?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'BOOKS_AND_REFERENCE' category? How many of them have more than 1000 reviews?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Reviews > 1000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users had a positive sentiment towards the 'ABC News - US & World News' app and what is its average rating?",
    "SQL": "SELECT COUNT(T2.Sentiment_Polarity), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'ABC News - US & World News' AND T2.Sentiment_Polarity > 0.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'PHOTOGRAPHY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the COMMUNICATION category and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore are rated 5.0 and have more than 10000 reviews?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5.0 AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5.0 and what is the average rating of apps with a rating of 4.5?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Rating IN (5.0, 4.5)",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest rating and how many reviews does it have?",
    "SQL": "SELECT App, Rating, Reviews FROM playstore ORDER BY Rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the CB SmartCAR Monitor app have?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'CB SmartCAR Monitor'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Theaverage rating of apps in the puzzle genre?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'Puzzle'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have reviewed the Candy Crush Saga app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Candy Crush Saga'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Tools' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 5 and are of the type 'Free'?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating = 5 AND Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have given a positive review to the 'Google Play' app? What is the average rating of this app?",
    "SQL": "SELECT COUNT(T2.Sentiment), AVG(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.App = 'Google Play' AND T2.Sentiment = 'Positive'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which family category has the highest average rating?",
    "SQL": "SELECT AVG(Rating) AS average_rating, Category FROM playstore WHERE Category = 'FAMILY' GROUP BY Category ORDER BY average_rating DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0, and how many of those apps are in the 'Tools' category?",
    "SQL": "SELECT COUNT(App), COUNT(CASE WHEN Category = 'Tools' THEN 1 ELSE NULL END) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have received a rating of 4.0 or higher, and what are their respective ratings?",
    "SQL": "SELECT App, Rating FROM playstore WHERE Rating >= 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the free apps on the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the different types of apps in the playstore and how many apps are there in each type?",
    "SQL": "SELECT TYPE, COUNT(*) FROM playstore GROUP BY TYPE",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many unique apps are in the 'playstore' table and their average rating?",
    "SQL": "SELECT COUNT(DISTINCT App), AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Apps in the 'TOOLS' category and what is the maximum number of reviews for any app in the same category?",
    "SQL": "SELECT AVG(T1.Rating), MAX(T1.Reviews) FROM playstore AS T1 WHERE T1.Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'MAPS_AND_NAVIGATION' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category and what is the number of apps in this category?",
    "SQL": "SELECT AVG(Rating), COUNT(App) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'FAMILY' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), SUM(Reviews) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'Paid' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating above 4.5 and what are their respective genres?",
    "SQL": "SELECT App, Genres FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' genre on the Google Play Store?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Genres = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps that belong to the 'GAME' category and have more than 50,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 50000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many free business apps have more than 10,000 reviews and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Category = 'BUSINESS' AND Type = 'Free' AND Reviews > 10000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are there in the 'FAMILY' category and what is the average rating for those apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'FAMILY'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users with a positive sentiment towards the Facebook app have a rating greater than 4.0?",
    "SQL": "SELECT COUNT(T1.Rating) FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T2.Sentiment = 'Positive' AND T1.Rating > 4.0 AND T1.App = 'Facebook'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which apps have a rating above 4.5 and have been downloaded more than 1 million times? List the average sentiment polarity of their reviews.",
    "SQL": "SELECT AVG(T2.Sentiment_Polarity), T1.App FROM playstore AS T1 INNER JOIN user_reviews AS T2 ON T1.App = T2.App WHERE T1.Rating > 4.5 AND T1.Installs = '1,000,000+' GROUP BY T1.App",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the Little Pets Animal Guardians app, and how many reviews does it have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE App = 'Little Pets Animal Guardians'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps in the playstore have a rating greater than 4.5?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Rating > 4.5",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.0 and what is the average size of these apps?",
    "SQL": "SELECT COUNT(App), AVG(REPLACE(Size, 'M', '')) FROM playstore WHERE Rating > 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the playstore?",
    "SQL": "SELECT AVG(Rating) FROM playstore",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest average rating among apps in the 'HEALTH AND FITNESS' category?",
    "SQL": "SELECT T1.App FROM playstore AS T1 WHERE T1.Category = 'HEALTH AND FITNESS' GROUP BY T1.App ORDER BY AVG(T1.Rating) DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the MEDICAL category and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the House & Home category have?",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE Category = 'HOUSE_AND_HOME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many users have written negative reviews for the Diamond Zipper Lock Screen app?",
    "SQL": "SELECT COUNT(App) FROM user_reviews WHERE App = 'Diamond Zipper Lock Screen' AND Sentiment = 'Negative'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the LIFESTYLE category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many different genres of apps are available on the Play Store? Provide the name of the most popular genre and its count of apps in that genre.",
    "SQL": "SELECT Genres, COUNT(*) as app_count FROM playstore GROUP BY Genres ORDER BY app_count DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "Which app has the highest number of reviews and what is its category?",
    "SQL": "SELECT App, Category FROM playstore ORDER BY Reviews DESC LIMIT 1",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many games are in the 'Action' genre and what is their average rating?",
    "SQL": "SELECT COUNT(App), AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Genres = 'Action'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'ENTERTAINMENT' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the genre of the app 'Flashlight HD LED' on the Google Play Store?",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'Flashlight HD LED'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Health and Fitness' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH AND FITNESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps belong to the 'TOOLS' category on the Play Store?",
    "SQL": "SELECT COUNT(App) FROM playstore WHERE Category = 'TOOLS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating of 4.0 or higher, and what is the average rating of these apps?",
    "SQL": "SELECT COUNT(*), AVG(Rating) FROM playstore WHERE Rating >= 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of all apps in the 'SPORTS' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the average reviews and ratings for apps in the 'BUSINESS' category?",
    "SQL": "SELECT AVG(Reviews), AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'Finance' category?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What are the categories of apps that have received a rating of 4.0 or higher?",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Rating >= 4.0",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps are in the 'GAME' category and what are their ratings?",
    "SQL": "SELECT COUNT(App), Rating FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many reviews does the 'ek tuhi' app have on the Google Play Store?",
    "SQL": "SELECT Reviews FROM playstore WHERE App = 'ek tuhi'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "How many apps have a rating greater than 4.5 and are priced at $0? List the app names, their categories, and ratings.",
    "SQL": "SELECT App, Category, Rating FROM playstore WHERE Rating > 4.5 AND Price = '$0'",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category that have more than 500,000 reviews?",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Reviews > 500000",
    "db_id": "app_store",
    "evidence": ""
  },
  {
    "question": "What is the average rating of apps in the 'GAME' category and how many reviews do they have?",
    "SQL": "SELECT AVG(Rating), Reviews FROM playstore WHERE Category = 'GAME'",
    "db_id": "app_store",
    "evidence": ""
  }
]