[
  {
    "db_id": "app_store",
    "question": "What is the average rating of free sports apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top free travel and local apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated free apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps under the 'TOOLS' category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore have more than 1 million installs and a rating of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '1,000,000+' AND Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the event planning apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='EVENTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the most reviewed App in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Price FROM playstore WHERE Category='TOOLS' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What app has the most installations among weather apps?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'WEATHER' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has a positive sentiment and a sentiment polarity of 0.21111111111111108?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews WHERE Sentiment = 'Positive' AND Sentiment_Polarity = '0.21111111111111108'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the applications in the MAPS_AND_NAVIGATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps in the PLAYSTORE category have a minimum of 10,000,000 installs and a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free' AND Installs >= '10,000,000+' AND Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular apps in the Family category in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category='FAMILY' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps have been installed by more than 10,000 users?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%10,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the video players in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the PLAYSTORE table?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the FAMILY category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Game'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'TOOLS' AND Rating > 4.0 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the application 'Seen'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Seen'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the medical category have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL' AND Installs LIKE '%+10%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the food and drink category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FOOD_AND_DRINK'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular tools in the playstore based on the number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS average_rating FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the SPORTS category with fewer than 10 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs < '10+' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What game on the playstore has a rating of 4.6 and more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = '4.6' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps categorized as family?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which Play Store app has a rating of 4.6 and has been installed 1,000+ times?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.6 AND Installs LIKE '%,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the 'Florida map' app?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Florida map'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the News & Magazines category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What are the photography apps with the highest rating in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PHOTOGRAPHY' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Business category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the paid apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated Apps in the category 'HEALTH_AND_FITNESS'? ",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='HEALTH_AND_FITNESS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of News 8 San Diego in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'News 8 San Diego'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps under the COMMUNICATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the genre of the app 'AK 47 Assault Rifle Wallpapers'?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'AK 47 Assault Rifle Wallpapers'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 1,000 installs in the GAME category and their average rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='GAME' AND Installs='1,000+' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "Which entertainment app has a rating of 4.3?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='ENTERTAINMENT' AND Rating=4.3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Beauty category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='BEAUTY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top-rated apps in the dating category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the app 'Water Droplets Keyboard Theme'?",
    "evidence": "",
    "SQL": "SELECT Price FROM playstore WHERE App = 'Water Droplets Keyboard Theme'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of weather apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='WEATHER'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free apps in the 'SOCIAL' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'SOCIAL' ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of users who have reviewed Ringtone Maker as negative?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews WHERE App = 'Ringtone Maker' AND Sentiment = 'Negative'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'TETRIS'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App='TETRIS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the health and fitness apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the business apps on Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the EDUCATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of medical apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the Auto & Vehicles category with a rating of 4.6 and more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type='Free' AND Category='AUTO_AND_VEHICLES' AND Rating>=4.6 AND Installs LIKE '%,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated free apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Type='Free' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the medical category of the Play Store that have more than 1,000 installs and are free to download?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'MEDICAL' AND Installs LIKE '%,1,000%' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Communication apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps under the MAPS_AND_NAVIGATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the first app in the playstore table?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 health apps with more than 500 installs from the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND Installs > '500+' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs = '100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the news and magazines category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'Medical' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Maps & Navigation category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the ENTERTAINMENT category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What games have a rating of 4.4 and are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = '4.4' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the most expensive 'BOOKS_AND_REFERENCE' app in the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' ORDER BY Price DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the VIDEO_PLAYERS category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='VIDEO_PLAYERS' AND Rating = (SELECT MAX(Rating) FROM playstore WHERE Category='VIDEO_PLAYERS')"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore app has the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of medical apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of books and reference apps on the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What are all the free apps that have been rated 5.0 by at least 1,000 users in the Lifestyle category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND Installs >= '1,000+' AND Rating = 5.0 AND Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the news apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all paid apps in the Communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Paid' AND Category='COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free games available on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of video player apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top apps in the FINANCE category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of news and magazines apps on the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of health and fitness apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free medical apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore app has the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the Dragon BZ Super Wallpapers app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Dragon BZ Super Wallpapers'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all shopping apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps that are free and have more than 1,000,000 installs in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='FAMILY' AND Type='Free' AND Installs LIKE '%,000,000+%' ORDER BY App LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app in the 'EVENTS' category from playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='EVENTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the GAME category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of K-pop Music?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='K-pop Music'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 'Lake Michigan CU Mobile' app in the 'Finance' category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category = 'FINANCE' AND App = 'Lake Michigan CU Mobile'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which free puzzle games with teen content rating have more than 500 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND 'Content Rating' = 'Teen' AND Installs = '500+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the MAPS_AND_NAVIGATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the application with the most reviews?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App IN (SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free social apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free shopping apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has more than 10 million installs and is free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10,000,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular app in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'SPORTS' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the shopping app that has a rating of 4.6?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.6 AND Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the COMMUNICATION category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'COMMUNICATION' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that are categorized as 'TRAVEL_AND_LOCAL' in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 most popular free apps in the Productivity category on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Category, Rating FROM playstore WHERE Type='Free' AND Category='PRODUCTIVITY' ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps available in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Price = '0' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with highest rating in the 'GAME' category in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='GAME' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of 'Herpes Positive Singles Dating' app in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Herpes Positive Singles Dating'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Books & Reference category apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free finance apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app 'FE Connect Drive-Tech' fall under?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'FE Connect Drive-Tech'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular free apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'BOOKS_AND_REFERENCE' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Adventure genre?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Genres = 'Adventure'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 finance-related apps with a minimum rating of 4.0?",
    "evidence": "",
    "SQL": "SELECT App, Category, Rating FROM playstore WHERE Type = 'Free' AND Category = 'FINANCE' AND Rating >= 4.0 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are all the free gaming apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'Soccer Manager 2018'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Soccer Manager 2018'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top reviewed apps in the 'FAMILY' category that have a 'Positive' sentiment in their reviews?",
    "evidence": "",
    "SQL": "SELECT p.App FROM playstore p JOIN user_reviews r ON p.App = r.App WHERE p.Category = 'FAMILY' AND r.Sentiment = 'Positive' ORDER BY r.Sentiment_Polarity DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore that have a rating of 4.6?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.6"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of video player apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the Personalization category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'PERSONALIZATION' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular apps in the 'BOOKS_AND_REFERENCE' category?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category='BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the AUTO_AND_VEHICLES category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='AUTO_AND_VEHICLES' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Communication category with a free trial?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'COMMUNICATION' AND Type = 'Free' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app categorized as TOOLS?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top free apps with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Price = '0' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular app in the Tools category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all game apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the EVENTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all shopping apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in LIFESTYLE category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='LIFESTYLE' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the playstore has a rating of 4.5 and is a free game with over 100 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.5 AND Type = 'Free' AND Installs LIKE '%,100,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of event apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all tools apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of productivity apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free dating apps in the playstore that have a rating above 3?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App FROM playstore WHERE Type='Free' AND Category='DATING' AND Rating > 3 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps in the COMMUNICATION category with a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'COMMUNICATION' AND Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What free family apps have 1,000+ installs and a rating of 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Free' AND Installs='1,000+' AND Rating=4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the libraries and demo category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'LIBRARIES_AND_DEMO'"
  },
  {
    "db_id": "app_store",
    "question": "What are the reviews of the app 'High Blood Pressure Symptoms' on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT Translated_Review FROM user_reviews WHERE App = 'High Blood Pressure Symptoms'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular apps in the family category that have a rating of 3.2 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' AND Rating>=3.2 ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free action games in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'ACTION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'Students.ch' in the 'SOCIAL' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Students.ch' AND Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 categories of apps in Playstore, sorted by rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category, AVG(Rating) AS Avg_Rating FROM playstore GROUP BY Category ORDER BY Avg_Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the video players in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the BOOKS_AND_REFERENCE application?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most downloaded apps in the Business category with a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' AND Rating >= 4.5 GROUP BY App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the finance apps on the playstore that have a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FINANCE' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Travel and Local category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the GAME category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all sports apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the game 'Essential Resources' in the 'LIBRARIES_AND_DEMO' category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Essential Resources' AND Category = 'LIBRARIES_AND_DEMO'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications in the FAMILY category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of tools apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are in the BUSINESS category in the playstore with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' AND Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the paid book apps with more than 100 installs in the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Paid' AND Installs = '100+' AND Category = 'BOOKS_AND_REFERENCE' AND 'Genres' LIKE '%Books & Reference%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps in Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.5M as their size?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Size = '4.5M'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the NEWS_AND_MAGAZINES category that have a rating of 4.4 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='NEWS_AND_MAGAZINES' AND Rating>=4.4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the communication category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'COMMUNICATION' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore with free type have more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs > '100+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the finance category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'FINANCE' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free applications in ART_AND_DESIGN category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='ART_AND_DESIGN'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Family category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the news and magazines category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'Izneo, Read Manga, Comics & BD'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Izneo, Read Manga, Comics & BD'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='MEDICAL' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of more than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Lifestyle category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIFESTYLE' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the travel category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps in the 'BUSINESS' category have a rating of 'None'?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' AND Rating='None' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'PERSONALIZATION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 most downloaded apps in the shopping category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='SHOPPING' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app 'FK Teplice' belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'FK Teplice'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of GAME apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated video players on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'VIDEO_PLAYERS' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the playstore is rated 4.1?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most popular app in the 'LIBRARIES_AND_DEMO' category that has more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='LIBRARIES_AND_DEMO' AND Installs LIKE '%,1,000,000+' ORDER BY INSTalls DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of lifestyle apps from the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free video players with a rating of more than 3.5 that have been installed more than 10,000 times?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating > 3.5 AND Installs LIKE '%+10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What video players are rated more than 3.8 on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 3.8 AND Type='VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Auto & Vehicles apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most reviewed apps in the game category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps from the SPORTS category in the Playstore that have at least 10+ installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Installs = '10+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the 'Marble - Temple Quest' app?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Marble - Temple Quest'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the top-rated app?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the auto and vehicles category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app with the highest rating in the Playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the TRAVEL_AND_LOCAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have the highest average rating in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest rating in the games category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of reviews for an app in the TRAVEL_AND_LOCAL category with a rating of 4.4?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM user_reviews, playstore WHERE user_reviews.App = playstore.App AND playstore.Category = 'TRAVEL_AND_LOCAL' AND playstore.Rating = 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the shopping category have more than 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SHOPPING' AND Installs = '500,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 mobile apps that have a rating of 4.0 and are free to download?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating=4.0 AND Type='Free' LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of entertainment apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the PLAYSTORE that are categorized as FAMILY and have more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY' AND Installs LIKE '%+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'COMMUNICATION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the ART_AND_DEesign category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the BOOKS_AND_REFERENCE category that have more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Installs LIKE '%,+1,000%' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with a 4.4 rating from the category GAME?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating = 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the beauty category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='BEAUTY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 games in the PLAYSTORE with a rating above 4?",
    "evidence": "",
    "SQL": "SELECT App, Category, Rating FROM playstore WHERE Type = 'GAME' AND Rating > 4 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top rated free games in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the PARENTING category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PARENTING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top free app in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps with a rating of 4.5 or more have a genre of Action?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5 AND Genres LIKE '%Action%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the medical category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the category 'TOOLS'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of 'CQ Key' on the Play Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'CQ Key'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the free app in the FAMILY category with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' AND Type='Free' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "Which free apps with at least 1,000,000 installs have a rating of at least 4.0 in the WEATHER category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Free' AND Installs='1,000,000+' AND Category='WEATHER' AND Rating>=4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 'BV' application in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'BV'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the Dictionary - Merriam-Webster app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Dictionary - Merriam-Webster'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the business category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the family category from the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the productivity apps with a rating of 4.1 in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PRODUCTIVITY' AND Rating = '4.1'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular free Android apps with the highest rating from the family category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app `DF-CAM` in the playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'DF-CAM'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free education apps in the Google Play Store with a rating of 4.5 or more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating >= 4.5 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the 'Sports' category have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Installs LIKE '%1,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the game ROBLOX in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'ROBLOX'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Playstore have a rating of 4.8 or higher?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating >= 4.8"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the FAMILY category of the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with a rating of 4.5 from the 'NEWS_AND_MAGAZINES' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.5 AND Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the 'FAMILY' category that have a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' AND Rating>=4.0"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the Finance category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FINANCE' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'SOCIAL' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the health and fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the photography category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PERSONALIZATION' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free FAMILY apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the category of MAPS_AND_NAVIGATION?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app `CX Summit` in the Playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App='CX Summit'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated productivity apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'PRODUCTIVITY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most highly rated Apps in the MAPS_AND_NAVIGATION category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'Chrome Dev' app in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Chrome Dev'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'DG Coupon'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'DG Coupon'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the weather app 'M\u00e9t\u00e9o Alg\u00e9rie DZ'?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'M\u00e9t\u00e9o Alg\u00e9rie DZ'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'BUSINESS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore are categorized under 'MAPS_AND_NAVIGATION'?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Candy Pop Story?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Candy Pop Story'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of travel and local apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of shopping apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the communication apps that have more than 100,000 installs and have a rating of 4.0 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='COMMUNICATION' AND Installs='100,000,000+' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the free app from the MAPS_AND_NAVIGATION category with more than 1,000 installs and rated 2.8 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,000+' AND Rating >= 2.8 AND Category = 'MAPS_AND_NAVIGATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the medical category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all communication apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with negative reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM user_reviews WHERE Sentiment='Negative' ORDER BY Sentiment_Polarity DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of business apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Dominos Game \u2714\ufe0f'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Dominos Game \u2714\ufe0f'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of social apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have a rating of at least 4.2 and are paid?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating >= 4.2 AND Type = 'Paid'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games available in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of photography apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the FAMILY category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of shopping apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all comics apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMICS'"
  },
  {
    "db_id": "app_store",
    "question": "What free productivity app on the Play Store has more than 100 installs and a negative review?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '100+' AND EXISTS (SELECT 1 FROM user_reviews WHERE user_reviews.App = playstore.App AND Sentiment = 'Negative')"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all shopping apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Medical category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "Which sports app has the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps that are in the GAME category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of health and fitness apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Lifestyle category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='LIFESTYLE' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top tools apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='TOOLS' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps categorized as DATING in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Finance apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Video Players & Editors apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular app in the PLAYSTORE?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps that have received reviews with a sentiment polarity of more than 0.2?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND EXISTS (SELECT 1 FROM user_reviews WHERE user_reviews.App = playstore.App AND Sentiment_Polarity > 0.2)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all travel apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free photography apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free sports apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What games are available for free and have been installed more than 1,000,000 times on the play store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs > '1,000,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the game with the highest average rating in the game category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps under the 'FAMILY' category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the dating category that have been installed more than 100 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Paid' AND Installs LIKE '%+100%' AND Category='DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free weather apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'WEATHER'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the shopping app 'Ouedkniss' in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING' AND App = 'Ouedkniss'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the `GAME` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps in the playstore that have a rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the playstore categorized as FAMILY?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of photo editing apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free applications in the FAMILY category that have a rating of 4.1?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' AND Rating = 4.1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 most popular social media apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'SOCIAL' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the app with the highest average rating in the EDUCATION category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='EDUCATION' GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the LIBRARIES_AND_DEMO category that have more than 100,000 installs and a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' AND Installs LIKE '%,100,000+' AND Rating >= 4.0 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the free weather apps available in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'WEATHER'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has an average rating of 4.4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of Google Photos?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Google Photos'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Finance apps in Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all NEWS_AND_MAGAZINES apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Business apps on Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of productivity apps that are free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PRODUCTIVITY' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the personalization category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PERSONALIZATION' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of books and reference apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app '365Scores - Live Scores'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App='365Scores - Live Scores'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the MAPS_AND_NAVIGATION category with at least 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION' AND Installs LIKE '%,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the EDUCATION apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 'Samsung Health' app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Samsung Health'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 events apps with more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '10+' AND Category = 'EVENTS' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app with the highest average rating among all apps in the playstore table?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating IN (SELECT AVG(Rating) FROM playstore GROUP BY App ORDER BY AVG(Rating) DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the first app in the playstore with no rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating IS NULL ORDER BY rowid LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the comics apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='COMICS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the content rating of the free app Lexus Tech BH Service Pro?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE App = 'Lexus Tech BH Service Pro' AND Type = 'Free' AND 'Content Rating' != 'None'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Business category in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are of Type Paid?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Paid'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top apps by installs in the Tools category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 5,000 installs and are in the `TOOLS` category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,+%' AND Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top three most popular apps in the MEDICAL category with at least 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='MEDICAL' AND Installs LIKE '%,1,000,000%' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of video player apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the News and Magazines category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top free apps in the 'Business' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' AND Type='Free' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free shopping apps from playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the PLAYSTORE that are free?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps in the Play Store that have a minimum rating of 4.2 and a maximum price of 0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.2 AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app CQ-Alert in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'CQ-Alert'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of sports apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the FAMILY category with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'FAMILY' AND Installs LIKE '%,1,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all business apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app 'AP Series Solution Pro' belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'AP Series Solution Pro'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular free apps in the family category with an average rating of at least 4.4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' AND Rating >= 4.4 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the Angry Birds Classic app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Angry Birds Classic'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app named FK Vojvodina?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'FK Vojvodina'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of CB Fit in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' AND App = 'CB Fit'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 1800 Contacts - Lens Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = '1800 Contacts - Lens Store'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 apps with the highest average rating in the Game category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'Acorns - Invest Spare Change'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Acorns - Invest Spare Change'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps in the playstore that have a category of PERSONALIZATION?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the social category that have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SOCIAL' AND Installs LIKE '%,1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the PHOTOGRAPHY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the categories of the top-rated apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Rating > 4.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'Bayview Hill AH'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Bayview Hill AH'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of applications in the communication category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of medical apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Photography category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the photography apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the TOOLS category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of installs for the weather app 'Weather 14 Days'?",
    "evidence": "",
    "SQL": "SELECT Installs FROM playstore WHERE App = 'Weather 14 Days'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free medical apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has the highest rating in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the dating apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with a business category have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' AND Installs LIKE '%+100000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the game Mental Hospital V in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT Price FROM playstore WHERE App = 'Mental Hospital V'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the game with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app `BG Middle East`?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'BG Middle East'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the Dating category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'DATING' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the apps that have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated productivity apps in the playstore that have more than 50 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PRODUCTIVITY' AND Installs='50+' AND Rating IS NOT NULL ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have a minimum of 10,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of a free game in the Health and Fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all communication apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have received over 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,50,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Play Store with more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+100%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of EZ Quran?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'EZ Quran'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of social apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the 'GAME' category have a rating above 3.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating > 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated finance apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='FINANCE' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the GAME category that have a high rating and a large number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='GAME' AND Rating > 4.0 AND Installs LIKE '%,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the FAMILY category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Paid'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the medical category that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'MEDICAL' AND Installs = '100,000+' AND Rating > (SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL' AND Installs = '100,000+')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated games in the Adventure genre with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'GAME' AND Genres LIKE '%Adventure%' AND Installs LIKE '%1,000,000+' AND Rating > 4.0 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the lifestyle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the most popular free family app in the playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Type = 'Free' AND Category = (SELECT Category FROM playstore ORDER BY Installs DESC LIMIT 1) "
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that are rated 4.2 or higher and their corresponding reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore p JOIN user_reviews r ON p.App=r.App WHERE p.Rating >= 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the medical app 'DreamMapper'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'DreamMapper'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are categorized under the lifestyle genre and have a rating of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIFESTYLE' AND Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps that have more than 1,000 installs and are categorized as medical applications?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '1,000+' AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the highest rated apps with over 50,000 installs in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' AND Installs LIKE '%,50,000%' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the WEATHER category and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'WEATHER' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the playstore that have over 10 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+%' AND LENGTH(Installs) > LENGTH('10,000,000+')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all family apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories of apps in the Google Play store?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(*) AS count FROM playstore GROUP BY Category ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What app with 1,000,000+ installs has a free price tag?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '1,000,000+' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free dating apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Type = 'Free' AND Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the tools category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular free dating apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Free' AND Category='DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the game with the most reviews on the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE App IN (SELECT App FROM playstore GROUP BY App ORDER BY Reviews DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest-rated applications in the FOOD_AND_DRINK category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FOOD_AND_DRINK' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated productivity apps in the Google Play Store with more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='PRODUCTIVITY' AND Installs='1,000,000+' AND Rating ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the total number of installs for the apps in the category 'GAME'?",
    "evidence": "",
    "SQL": "SELECT SUM(Installs) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the most rated app in the Playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of Nike+ Run Club?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Nike+ Run Club'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps with at least 1,000,000 installs in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,1,000,000+' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated productivity app in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PRODUCTIVITY' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the TOOLS category apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "Which games in the playstore have a negative sentiment in reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM user_reviews WHERE Sentiment='Negative'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore that have more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%50,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps with more than 1 million installs in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000+' AND Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of VK app?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'VK'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Beauty apps on the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BEAUTY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='TOOLS' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app Manga AZ - Manga Comic Reader in the Play Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Manga AZ - Manga Comic Reader'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the BUSINESS category on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free tools on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of 4.3?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 4.3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the Apps in the PLAYSTORE table with more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the paid apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Paid'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'Can Knockdown'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Can Knockdown'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of photography apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated travel apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='TRAVEL_AND_LOCAL' AND Installs LIKE '%,000,000+' AND Rating > 4.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the FAMILY category that have more than 100,000 installs and a rating of 4.4 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' AND Installs LIKE '%,100,000+' AND Rating >= 4.4 ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Business category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with a rating of more than 3 and more than 1000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 3 AND Installs LIKE '%+1000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of reviews for apps in the 'FAMILY' category with a rating of 4.1?",
    "evidence": "",
    "SQL": "SELECT COUNT(Reviews) FROM playstore WHERE Category = 'FAMILY' AND Rating = 4.1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "Which free productivity apps have been downloaded by more than 10,000 users?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,10,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of finance apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Type = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the extreme coupon finder app in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='Extreme Coupon Finder'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'Multiple Sclerosis Dx & Mgmt.'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Multiple Sclerosis Dx & Mgmt.'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Beauty category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='BEAUTY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular photography apps with at least 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Installs LIKE '%,000,000+' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular sport app in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Installs = (SELECT MAX(Installs) FROM playstore) LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What free apps in the medical category have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'MEDICAL' AND Installs LIKE '%,100,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'FAMILY' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated games in the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Type='Free' AND Category='GAME' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the game category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all photography apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='BOOKS_AND_REFERENCE' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What games in the Play Store have no rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = 'None'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are in the TRAVEL_AND_LOCAL category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the business category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps with more than 1000 installs in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Installs LIKE '%+%' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the FAMILY category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'FAMILY' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 rated Apps in the Books & Reference category on the playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the SOCIAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of sports apps on the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of apps in the Play Store that have a rating of 4.2?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM playstore WHERE Rating = 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Play Store have a rating of 3.1 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 3.1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the GAME category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 'Lavender Emoji Keyboard Theme' app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Lavender Emoji Keyboard Theme'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of game apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the Family category with no rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Rating IS NULL"
  },
  {
    "db_id": "app_store",
    "question": "What are all the genres of free apps that have a rating of more than 4 out of 5?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE Type='Free' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated games from the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'GAME' AND Rating > (SELECT AVG(Rating) FROM playstore) ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the health and fitness apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of productivity apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top apps in the News & Magazines category with a rating greater than 3.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES' AND Rating > 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the FAMILY category have a rating of 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Rating = 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Launcher in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Launcher'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the parenting apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PARENTING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the social category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'SOCIAL' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated meditation apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the app of the same name as the user who wrote a review with a sentiment of 'positive' belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM user_reviews AS r INNER JOIN playstore AS p ON r.App = p.App WHERE r.Sentiment = 'positive' AND r.Translated_Review IS NOT NULL"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the apps available for free in the Maps and Navigation category, along with their number of installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps in the playstore have a rating above 4.0 and the category is medical?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.0 AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular education app in the Playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category = 'EDUCATION' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated productivity apps with more than 100,000 installs from the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PRODUCTIVITY' AND Installs LIKE '%100,000%' AND Rating > 4.5 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free tools in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the `Jeppesen CR Flight Computer` app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Jeppesen CR Flight Computer'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Medical apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS AverageRating FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Health and Fitness category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that have a rating of 4 or more?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps with the highest ratings in the Beauty category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='BEAUTY' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='MEDICAL' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the EDUCATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 rated apps in the Games category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps in the 'PERSONALIZATION' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "Which app in the playstore has the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the COMMUNICATION category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the EVENTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 8fit Workouts & Meal Planner app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = '8fit Workouts & Meal Planner'"
  },
  {
    "db_id": "app_store",
    "question": "What is the content rating for the application 'Reisedealz.eu'?",
    "evidence": "",
    "SQL": "SELECT \"Content Rating\" FROM playstore WHERE App = 'Reisedealz.eu'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore that have been installed more than 100 times?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%+' AND CAST(SUBSTRING(Installs, INSTR(Installs, '+') + 1) AS INTEGER) > 100"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Ay Hasnain k Nana Milad Naat'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Ay Hasnain k Nana Milad Naat'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of lifestyle apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the TOOLS category with a rating of 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='TOOLS' AND Rating=4.2 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the BEAUTY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BEAUTY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free travel and local apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps have over 100 million installs and a content rating of 'Everyone 10+'?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%100,000,000+' AND 'Content Rating' = 'Everyone 10+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the Apps in the HEALTH_AND_FITNESS category and their average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' GROUP BY App"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the simulation apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'FAMILY' AND Genres = 'Simulation'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated free apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What app has been installed by 10,000+ users and is free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '10,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the ART_AND_DESIGN category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'ART_AND_DESIGN' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the genres of an app called 'A Call From Santa Claus!'?",
    "evidence": "",
    "SQL": "SELECT Genres FROM playstore WHERE App = 'A Call From Santa Claus!'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'SOCIAL' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What games on the playstore have a rating higher than 4.5 and more than 5 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5 AND Installs > '5000000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the medical apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "Which free photography app with 50+ installs is rated None?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'PHOTOGRAPHY' AND Installs = '50+' AND Rating = 'None'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the application 'Evolution CP' in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Evolution CP' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'BUSINESS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated apps in the tools category of the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the EDUCATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular photo editing app in the playstore, and what is the rating of that app?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='PHOTOGRAPHY' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of game apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the shopping apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free travel apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0' AND Category = 'TRAVEL_AND_LOCAL' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Space Z' from the Playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Space Z'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Lifestyle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='LIFESTYLE' AND Type='Game'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Health and Fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps in the PLAYSTORE which have more than 10 million installs and are of type Free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%+%' AND Type = 'Free' AND installs > 10000000"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the medical app that has a rating of 4.8 and has been installed more than 500 times?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'MEDICAL' AND Rating = '4.8' AND Installs LIKE '%+500%'"
  },
  {
    "db_id": "app_store",
    "question": "What free apps with libraries and demo are rated 4 or above with more than 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'LIBRARIES_AND_DEMO' AND Rating >= 4 AND Installs = '50,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular app in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most highly-rated game on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'GAME' AND Rating = (SELECT MAX(Rating) FROM playstore WHERE Type = 'GAME')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of news apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps that are rated 4.4 or higher in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PRODUCTIVITY' AND Rating>=4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What apps are free and have a rating of 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating = 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the free game in the Play Store with more than 50,000 installs and a rating of 4.2?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '50,000+' AND Rating = 4.2"
  },
  {
    "db_id": "app_store",
    "question": "What are all the categories in which an app with free content and over 1 million installs can be found?",
    "evidence": "",
    "SQL": "SELECT distinct Category FROM playstore WHERE Price='Free' AND Installs LIKE '%1,000,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of lifestyle apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of books and reference apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which category of apps has the highest rating?",
    "evidence": "",
    "SQL": "SELECT Category, AVG(Rating) AS Average_Rating FROM playstore GROUP BY Category ORDER BY Average_Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the application 'EO Forum'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'EO Forum'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Communication category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='COMMUNICATION' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the 'GAME' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app Sisense Mobile BI?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App='Sisense Mobile BI'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the Productivity category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category='PRODUCTIVITY' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of shopping apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'Axe Spinner'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App='Axe Spinner'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all games on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Barry EC' in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Barry EC'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'METEO FRANCE' app in the 'WEATHER' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='WEATHER' AND App='METEO FRANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'GAME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the GAME category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 categories of apps in the playstore with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT Category, COUNT(Installs) AS Total_Installs FROM playstore GROUP BY Category ORDER BY Total_Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the first app in the database?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rowid ASC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free tools app in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Education category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Genres = 'Education'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of an app that has received 500,000+ installs?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Installs = '500,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top finance apps with at least 500,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FINANCE' AND Installs LIKE '%500,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Business category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the Apps in the Family category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the applications in the MEDICAL category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app `AF Link`?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'AF Link'"
  },
  {
    "db_id": "app_store",
    "question": "What is the app with the highest rating in the shopping category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='SHOPPING' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the FAMILY category apps on the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all video player apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app with the highest installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs = (SELECT MAX(Installs) FROM playstore) ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore are free?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Medical apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the TRAVEL_AND_LOCAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TRAVEL_AND_LOCAL' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the average ratings of all apps in the 'Auto & Vehicles' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free games in the game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Tools apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the paid apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the PHOTOGRAPHY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps from the 'BUSINESS' category that have a rating of at least 3.5?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'BUSINESS' AND Rating >= 3.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'DrivingTest' app in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY' AND App='DrivingTest'"
  },
  {
    "db_id": "app_store",
    "question": "What category does the educational game 'Children Educational Game Full' belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App='Children Educational Game Full'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Social category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'SOCIAL' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the productivity app in Charlotte County, FL?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PRODUCTIVITY' AND App='Charlotte County, FL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most common content ratings for free apps in the Photography category?",
    "evidence": "",
    "SQL": "SELECT \"Content Rating\" FROM playstore WHERE Type = 'Free' AND Category = 'PHOTOGRAPHY' GROUP BY \"Content Rating\" ORDER BY COUNT(*) DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Medical apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most reviewed apps in the 'TOOLS' category with a rating of at least 4 stars?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Rating >= 4 ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the FAMILY category with a rating of 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' AND Rating=4.0 ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app 'The Grand Bike V' in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND App = 'The Grand Bike V'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most installed app in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the application 'Claus Paws AH' in the medical category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Claus Paws AH' AND Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the PRODUCTIVITY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What games are available in the Arcade genre and have a rating of 3.4 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'GAME' AND Category = 'Arcade' AND Rating >= 3.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the free news app with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Free' AND Rating=(SELECT MAX(Rating) FROM playstore WHERE Type='Free')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated dating apps from the playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='DATING' AND Type='Free' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of comics apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMICS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the BUSINESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of HEALTH_AND_FITNESS apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has the highest number of installs in the education category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What travel-related app has the most number of reviews on the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the Health and Fitness category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "Which type of apps is most popular in terms of number of installs?",
    "evidence": "",
    "SQL": "SELECT Type FROM playstore GROUP BY Type ORDER BY COUNT(Installs) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Sports category have more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Installs > '10,000'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top-rated apps in the game category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of business apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free sports apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the categories of the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of personalization apps with more than 10,000 installs in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,10,000%' AND Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'BEAUTY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BEAUTY'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Photography category have a rating above 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What sports apps have more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%100+' AND Category='SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular finance apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT App, COUNT(*) as count FROM user_reviews GROUP BY App ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of food delivery apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of AJ AUTO in the Playstore?",
    "evidence": "",
    "SQL": "SELECT Price FROM playstore WHERE App = 'AJ AUTO'"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs > '10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of productivity apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free tools in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the family apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated sports apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS' AND Rating > 4.0 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps in the Play Store that have a minimum rating of 3.0?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating >= 3.0 GROUP BY Category"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'English to Hindi Dictionary'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App='English to Hindi Dictionary'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the simulation games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Genres LIKE '%Simulation%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the personalization app with more than 100 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PERSONALIZATION' AND Installs = '100+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of 7 Weeks - Habit & Goal Tracker in the Play Store?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = '7 Weeks - Habit & Goal Tracker'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of medical apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'EDUCATION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the productivity apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the family category on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of a free app in the FAMILY category in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all applications in the Family category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free productivity apps in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of 'Barcode Scanner' on Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Barcode Scanner'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the SHOPPING category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Libraries and Demos category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='LIBRARIES_AND_DEMO'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the ENTERTAINMENT category on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of Montessori Preschool?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Montessori Preschool'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 productivity apps in the playstore with a rating of 4.0 and more?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'PRODUCTIVITY' AND Rating >= 4.0 ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free weather apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'WEATHER'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps that have 'Business' as their category and a rating of 2.3 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' AND Rating>=2.3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'PERSONALIZATION' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'MEDICAL' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the COMMUNICATION category with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'COMMUNICATION' GROUP BY App ORDER BY Average_Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free communication apps with more than 10 installs in the play store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND Installs LIKE '%+%' AND Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the dating category in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular finance apps with a rating of 4.5 or above in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FINANCE' AND Rating>=4.5 ORDER BY Reviews DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular app in the family category?",
    "evidence": "",
    "SQL": "SELECT MAX(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps categorized as 'TOOLS' in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the travel and local category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the EVENTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='EVENTS' AND Price='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the most reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Reviews = (SELECT MAX(Reviews) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the apps that have more than 50,000,000 installs in the business category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '50,000,000+' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the SOCIAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top-rated apps in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of game apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the LIBRARIES_AND_DEMO category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the shopping apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most popular paid app in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Paid' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the PLAYSTORE database?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated app in the Business category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'BUSINESS' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Books & Reference category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the productivity category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'BUSINESS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the 'TOOLS' category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS' "
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of dating apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the application 'CWT To Go'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'CWT To Go'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top business apps with over 100,000 installs in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS' AND Installs LIKE '%,100,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the SOCIAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free family apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the MEDICAL category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of a finance app?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the 'Tools' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'TOOLS' AND Price = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 free apps in the Family category with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App, COUNT(*) AS Installs FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free' GROUP BY App ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the app name with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FOOD_AND_DRINK category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FOOD_AND_DRINK'"
  },
  {
    "db_id": "app_store",
    "question": "What game from the Playstore has more than 10 million installs and has a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='GAME' AND Installs='10,000,000+' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps that have more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the productiviry category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the sports apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the video players in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the games in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the family category with more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='FAMILY' AND Installs>'1,000+' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular free apps in the PHOTOGRAPHY category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'PHOTOGRAPHY' AND Type = 'Free' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps have more than 10,000 installs and are of the type Free?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Installs > '10,000+' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What category is the App 'All Maths Formulas' under?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'All Maths Formulas'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the travel app with the highest rating in the PlayStore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore) AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Social category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of PlayStation App?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'PlayStation App'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Family apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the most popular apps in the 'AUTO_AND_VEHICLES' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'AUTO_AND_VEHICLES' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps with highest rated reviews in the Productivity category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='PRODUCTIVITY' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps in the Tools category with a rating of None?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TOOLS' AND Rating = 'None' ORDER BY Installs DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "Which apps are rated with a rating of 4.1 and have a minimum of 50,000 installs?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Rating = 4.1 AND Installs LIKE '%50,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most popular app in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='SPORTS' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app PJ Masks: HQ?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'PJ Masks: HQ'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid books and reference apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Type = 'Paid'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Education category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 free tools in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Free' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 rated video players on the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='VIDEO_PLAYERS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the top-rated app in the playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games that have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Installs LIKE '%,1,000,000+%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'Tools' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps under the SHOPPING category have more than 1 million installs and a rating of at least 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'SHOPPING' AND Installs LIKE '%,1,000,000+' AND Rating >= 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the first app in the Playstore table?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Personalization category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest rated apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the travel and local category have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated tools on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps for navigation in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'MAPS_AND_NAVIGATION' ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free video players in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free health and fitness apps in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='HEALTH_AND_FITNESS' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps that have a rating of 4.5 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What game has the lowest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category = 'GAME' ORDER BY Rating ASC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of photography apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the finance apps available on the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Sports category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "Which  app in the health and fitness category has the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What sports app with a free version and more than 1,000 installs has an average rating of 3.3 or higher?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,+1,000%' AND Rating >= 3.3 AND App IN (SELECT App FROM playstore WHERE Category = 'SPORTS')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'BBW Dating & Plus Size Chat' app in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'BBW Dating & Plus Size Chat'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the finance apps?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore with a free installation?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the popular game application in the house and home category that has been installed by over 10,000 people?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HOUSE_AND_HOME' AND Installs LIKE '%,10,000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free sports apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the LIFESTYLE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free family games on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY' AND Price = '0'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the TOOLS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps in the playstore categorized as business?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of games in the playstore that have a price of 0?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Price = '0' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the number of installs of the Wave Z Live Wallpaper app?",
    "evidence": "",
    "SQL": "SELECT Installs FROM playstore WHERE App = 'Wave Z Live Wallpaper'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the tools apps available in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the BOOKS_AND_REFERENCE category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='BOOKS_AND_REFERENCE' AND Price='Free'"
  },
  {
    "db_id": "app_store",
    "question": "Which playstore apps are considered to be within the LIFESTYLE category and have a minimum of 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='LIFESTYLE' AND Installs >= '1,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the app category of the app 'Google Analytics'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Google Analytics'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the medical apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the most popular category of apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore GROUP BY Category ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 'LEGO TV' application?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'LEGO TV'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the libraries and demo category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the education apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='EDUCATION'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top free business apps with over 100,000 installs on Google Play Store?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND Installs LIKE '%100,000%' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the PERSONALIZATION category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the 'ABC Kids - Tracing & Phonics' app?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'ABC Kids - Tracing & Phonics'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free social apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 'TOOLS' category apps in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of HEALTH_AND_FITNESS apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the top 5 apps in the TOOLS category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What free apps from the category FAMILY have more than 1,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY' AND Installs LIKE '%,+1000%'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the EVENTS category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'EVENTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'NEWS_AND_MAGAZINES' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the playstore are free to install and have a rating of 4.4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Rating = 4.4"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of communication apps with more than 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION' AND Installs LIKE '%,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of EP Gem Hunter game in the Play Store?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App='EP Gem Hunter'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of auto and vehicle apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Medical apps on the PlayStore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of apps in the FAMILY category that have more than 10 installs and have a rating of 4.5 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' AND Installs LIKE '10+' AND Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What category is the Urban Limo Taxi Simulator app listed under?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Urban Limo Taxi Simulator'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the BUSINESS category with more than 10,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' AND Installs='10,000+' ORDER BY SIZE LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the playstore that have more than 100,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '100,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What app has the highest rating among all the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps categorized as PERSONALIZATION in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PERSONALIZATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'HOUSE_AND_HOME' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HOUSE_AND_HOME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free dating apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What apps from the sports category in the playstore have at least 500000 installs and a rating of 4.3 or higher?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='SPORTS' AND Installs >= '500000+' AND Rating >= 4.3"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 apps that have been installed 10,000+ times and are of type Paid?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs = '10,000+' AND Type = 'Paid' LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Lifestyle category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'LIFESTYLE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top free finance apps that have received positive reviews and have a rating of 4 or above?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' AND Type = 'Free' AND Rating >= 4 ORDER BY Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the popular game 'Bubble Shooter' in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Bubble Shooter'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the productivity category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular application in the `TOOLS` category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category = 'TOOLS' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of the top 10 apps with free installation from the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE Type = 'Free' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Price = '0' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the AUTO_AND_VEHICLES category have a rating greater than 4.0?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'AUTO_AND_VEHICLES' AND Rating > 4.0"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Business category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free games in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of applications in the COMMUNICATION category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Animal Jam - Play Wild! app?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Animal Jam - Play Wild!'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a 4-star rating or above and have more than 1 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating >= 4 AND Installs LIKE '%1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps categorized as 'COMMUNICATION' in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What free productivity app has the highest average rating in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Category = 'PRODUCTIVITY' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Finance category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What category does Pocket GMAT Math app belong to?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Pocket GMAT Math'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the parenting category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PARENTING'"
  },
  {
    "db_id": "app_store",
    "question": "What are all the productivity apps with at least 5,000 installs from the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PRODUCTIVITY' AND Installs='5,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Books & Reference category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Type = 'Free'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the highest rated app in the HEALTH_AND_FITNESS category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'HEALTH_AND_FITNESS' ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most popular app that falls under the 'Game' category in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='GAME' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free photography apps with at least 100,000,000 installs in the Playstore?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type='Free' AND Installs LIKE '%,100,000,000+' AND Category='PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of auto and vehicles apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of entertainment apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='ENTERTAINMENT'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'Deaf - Hearing chat device H'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Deaf - Hearing chat device H'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app AE Roundy POP?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'AE Roundy POP'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of books in the Books & Reference category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the AUTO_AND_VEHICLES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'AUTO_AND_VEHICLES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the Books & Reference category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'BOOKS_AND_REFERENCE'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of tools apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore WHERE Type = 'Free' AND Size < '100M'"
  },
  {
    "db_id": "app_store",
    "question": "What is the price of the most popular app in the EVENTS category?",
    "evidence": "",
    "SQL": "SELECT Price FROM playstore WHERE Category = 'EVENTS' AND Installs = (SELECT MAX(Installs) FROM playstore WHERE Category = 'EVENTS')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of family games in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Tools category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top rated apps in the 'Business' category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='BUSINESS' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of photo editing apps in the photography category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free apps in the news and magazines category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of Apps available on the Playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the shopping category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the categories of apps available in the Play Store?",
    "evidence": "",
    "SQL": "SELECT DISTINCT Category FROM playstore"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the reviews for an app that is categorized under 'FAMILY'?",
    "evidence": "",
    "SQL": "SELECT Reviews FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the app FIFA 16 Soccer?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'FIFA 16 Soccer'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the Libraries and Demo category have a rating greater than 4?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIBRARIES_AND_DEMO' AND Rating > 4"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the 'Breastfeeding Tracker Baby Log' app?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Breastfeeding Tracker Baby Log'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all shopping apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SHOPPING'"
  },
  {
    "db_id": "app_store",
    "question": "What games have been installed by more than 1 million users?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs LIKE '%,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top apps in the Family category that have a rating of at least 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' AND Rating >= 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the first app in the playstore table?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated finance apps in Playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FINANCE' AND Rating = (SELECT MAX(Rating) FROM playstore WHERE Category = 'FINANCE')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of productivity apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the 7 Day Food Journal Challenge app in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = '7 Day Food Journal Challenge'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the NEWS_AND_MAGAZINES category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What category of apps is 'Speech Therapy: CH' an example of?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'Speech Therapy: CH'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top apps with the highest rating?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating = (SELECT MAX(Rating) FROM playstore)"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the 'FOOD_AND_DRINK' category?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category='FOOD_AND_DRINK' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all Health & Fitness apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of photography apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'Down Dog: Great Yoga Anywhere' in the 'HEALTH_AND_FITNESS' category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Down Dog: Great Yoga Anywhere' AND Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top free apps with a positive sentiment?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type = 'Free' AND EXISTS (SELECT 1 FROM user_reviews WHERE user_reviews.App = playstore.App AND Sentiment = 'Positive')"
  },
  {
    "db_id": "app_store",
    "question": "What is the content rating for FK S\u016bduva Marijampol\u0117?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE App = 'FK S\u016bduva Marijampol\u0117'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all the finance apps listed in the playstore table?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "Which free news and magazines apps have negative reviews?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Free' AND Category='NEWS_AND_MAGAZINES' AND EXISTS (SELECT 1 FROM user_reviews WHERE user_reviews.App=playstore.App AND Sentiment='Negative')"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the apps in the 'TOOLS' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all games in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all dating apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What are the apps with more than 50 million installs in the game category and their corresponding ratings?",
    "evidence": "",
    "SQL": "SELECT Playstore.App, Playstore.Rating FROM Playstore, (SELECT COUNT(*) AS installs, App FROM Playstore GROUP BY App HAVING installs > 50000000) AS installs_threshold WHERE Playstore.App = installs_threshold.App AND Playstore.Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the 'ART_AND_DESIGN' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='ART_AND_DESIGN'"
  },
  {
    "db_id": "app_store",
    "question": "What are the free apps in the Productivity category in the Play Store with at least 1,000,000 installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type = 'Free' AND Installs = '1,000,000+' AND Category = 'PRODUCTIVITY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Food & Drink apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FOOD_AND_DRINK'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the most popular paid personalization app on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='PERSONALIZATION' AND Type='Paid' AND Installs LIKE '%,000,000+' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 paid apps in the FAMILY category in Play Store with more than 100 reviews?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Category='FAMILY' AND Price='Paid' AND Reviews > 100 ORDER BY Reviews DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of all apps that have more than 100 installs in the category of BOOKS_AND_REFERENCE?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'BOOKS_AND_REFERENCE' AND Installs = '100+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 highest-rated productivity apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'PRODUCTIVITY' ORDER BY Rating DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of ART AND DESIGN apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'ART_AND_DESIGN'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the communication apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the HEALTH_AND_FITNESS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all the communication apps available on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'COMMUNICATION'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps under the 'GAME' category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What apps in the playstore have a rating of more than 4.5?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Rating > 4.5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'NEWS_AND_MAGAZINES' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'NEWS_AND_MAGAZINES'"
  },
  {
    "db_id": "app_store",
    "question": "What is the app with the lowest rating in the education category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'EDUCATION' ORDER BY Rating ASC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all free health and fitness apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='HEALTH_AND_FITNESS' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the free application that has more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Type='Free' AND Installs LIKE '%10,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free apps in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type='Free' AND Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "Which apps with more than 1,000,000 installs have a positive sentiment in their user reviews?",
    "evidence": "",
    "SQL": "SELECT p.App FROM playstore p JOIN user_reviews r ON p.App = r.App WHERE r.Sentiment = 'Positive' AND p.Installs LIKE '%,1,000,000+'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free travel and local apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'TRAVEL_AND_LOCAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of social media apps on the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SOCIAL'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 apps in the PERSONALIZATION category with the most installs?",
    "evidence": "",
    "SQL": "SELECT App, Installs FROM playstore WHERE Category = 'PERSONALIZATION' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the SPORTS category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the app that has a free price and a rating of None?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Price = '0' AND Rating = 'None'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of paid apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most highly-rated app in the PLAYSTORE database?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore ORDER BY Rating DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most downloaded app in the Photography category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Category='PHOTOGRAPHY' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of free communication apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) AS Average_Rating FROM playstore WHERE Category='COMMUNICATION' AND Type='Free'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all dating apps in the Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the app 'The translator'?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = 'The translator'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the HEALTH_AND_FITNESS category in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'HEALTH_AND_FITNESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the most popular app in the playstore?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the Medical category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='MEDICAL'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app CASHIER in the finance category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'CASHIER' AND Category = 'FINANCE'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the Auto & Vehicles category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='AUTO_AND_VEHICLES' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the FAMILY category of the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Rating > 4 ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the `ROBLOX` app in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'ROBLOX'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 shopping apps with the highest rating in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='SHOPPING' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the Entertainment apps with the highest number of installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='ENTERTAINMENT' ORDER BY Installs DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What photography app has more than 10 million installs?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Installs LIKE '%,000,000+' AND Category = 'PHOTOGRAPHY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Sports apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all apps in the 'Business' category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app `Preschool All-In-One`?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Preschool All-In-One'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Sci-Fi Sounds and Ringtones?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App = 'Sci-Fi Sounds and Ringtones'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the FAMILY category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'FAMILY' AND Rating = (SELECT MAX(Rating) FROM playstore WHERE Category = 'FAMILY')"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 10 most popular apps in the LIFESTYLE category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'LIFESTYLE' ORDER BY Installs DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of video players in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'VIDEO_PLAYERS'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top-rated apps in the FAMILY category on the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App, Rating FROM playstore WHERE Category = 'FAMILY' ORDER BY Rating DESC LIMIT 10"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 3 highest-rated apps in the Family category in the playstore?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category='FAMILY' ORDER BY Rating DESC LIMIT 3"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all family apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the free business apps in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Free' AND Category = 'BUSINESS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the application 'Garena Free Fire'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Garena Free Fire'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 games in the Playstore with free downloads?",
    "evidence": "",
    "SQL": "SELECT * FROM playstore WHERE Type='Free' AND Category='GAME' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of tools apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the category of the employment center app with the most reviews?",
    "evidence": "",
    "SQL": "SELECT Category FROM playstore WHERE App = (SELECT App FROM playstore ORDER BY Reviews DESC LIMIT 1)"
  },
  {
    "db_id": "app_store",
    "question": "What type of app is 'Cooking Fever'?",
    "evidence": "",
    "SQL": "SELECT Type FROM playstore WHERE App = 'Cooking Fever'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top apps with the highest average rating in the Sports category?",
    "evidence": "",
    "SQL": "SELECT App, AVG(Rating) AS Average_Rating FROM playstore WHERE Category = 'SPORTS' GROUP BY App ORDER BY Average_Rating DESC"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the most popular game with 10,000,000+ installs in the playstore?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE Installs = '10,000,000+' AND Type = 'Free' ORDER BY Reviews DESC LIMIT 1"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of sports apps on the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the app 'CP Installer App'?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'CP Installer App'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the `TOOLS` category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'TOOLS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the game 'Temple Run 2' in the Play Store?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE App='Temple Run 2'"
  },
  {
    "db_id": "app_store",
    "question": "What are the top 5 most popular apps in the ART_AND_DESIGN category?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'ART_AND_DESIGN' ORDER BY Installs DESC LIMIT 5"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the name of the travel app with an average rating of 4.6?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'TRAVEL_AND_LOCAL' AND Rating = 4.6"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all sports apps in the playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category='SPORTS'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of Games in Playstore?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'GAME'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of the apps in the family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What is the rating of the application 'Doctor Pets' in the 'FAMILY' category?",
    "evidence": "",
    "SQL": "SELECT Rating FROM playstore WHERE App = 'Doctor Pets' AND Category = 'FAMILY'"
  },
  {
    "db_id": "app_store",
    "question": "What are the names of the apps available in the DATING category in the Google Play Store?",
    "evidence": "",
    "SQL": "SELECT App FROM playstore WHERE Category = 'DATING'"
  },
  {
    "db_id": "app_store",
    "question": "What is the average rating of all paid apps in the Family category?",
    "evidence": "",
    "SQL": "SELECT AVG(Rating) FROM playstore WHERE Type = 'Paid' AND Category = 'FAMILY'"
  }
]