[
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list of movie IDs with a rating score greater than 8?",
    "SQL": "SELECT movie_id FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users in the last month?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_timestamp_utc >= DATE('now','-1 month')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies rated by users in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie release year of the top 10 most popular movies?",
    "SQL": "SELECT AVG(movie_release_year) FROM movies ORDER BY movie_popularity DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2020?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_release_year = 2020)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies has a rating score greater than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have made a trialist rating?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE user_trialist = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users with a rating score of 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies with a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists has the user with user_id 1 created?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does a list have?",
    "SQL": "SELECT list_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with the user with ID 1?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies with a popularity score greater than 50?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list that has the maximum number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for each movie?",
    "SQL": "SELECT movie_title, COUNT(rating_id) FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by the user with user_id 1?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating higher than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for a specific movie?",
    "SQL": "SELECT COUNT(rating_score) FROM ratings WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a release year greater than 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 500 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "how many followers does the list with id 1 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 4?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does a list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users who are not eligible for trial?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.user_eligible_for_trial = 0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for the movie 'Inception'?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'Inception')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are rated higher than 4 out of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists owned by a specific user?",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE user_id = 'specific_user_id'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movie titles are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT movie_title) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies based on their rating scores?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies with a rating score greater than 8?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie with the title 'Inception'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 500?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie with a rating score of 5?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and rating score of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T1.rating_score FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists combined?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in 2020?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title and release year for the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie with the title 'The Matrix'?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'The Matrix'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 12345",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the 'movies' table?",
    "SQL": "SELECT COUNT(*) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score in the ratings table?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie with the title 'Interstellar'?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Interstellar'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a specific movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies in the 'Sci-Fi' genre?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title LIKE '%Sci-Fi%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for the user with user_id 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) AS num_lists FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are rated the highest?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8 and what is their title?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for a user with a specific user_id?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 'desired_user_id'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies are there in the ratings table?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the total number of users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with user ID 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for the movie 'Frozen'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Frozen'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does the user with user_id 1 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all the movies that have a rating score greater than 8?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Retrieve the total number of ratings for each movie.",
    "SQL": "SELECT COUNT(rating_id), movie_id FROM ratings GROUP BY movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the 'movies' table?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest popularity score?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does a user with ID 123 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Avatar'? ",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Avatar')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list created by the user with ID 1?",
    "SQL": "SELECT list_title FROM lists_users AS lu INNER JOIN lists AS l ON lu.list_id = l.list_id WHERE lu.user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated more than 10 movies?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE user_id IN (SELECT user_id FROM ratings GROUP BY user_id HAVING COUNT(movie_id) > 10)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year before 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the ID 123?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of comments on lists by user_id 1?",
    "SQL": "SELECT SUM(list_comments) FROM lists WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS number_of_lists FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have created at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does each list have?",
    "SQL": "SELECT list_id, list_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 4 or higher?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score >= 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there in the database?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated more than 5 movies?",
    "SQL": "SELECT COUNT(user_id) FROM ratings GROUP BY user_id HAVING COUNT(movie_id) > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) AS list_count FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by a user with the user_id 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by a user with user_id 1?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies released after the year 2000",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the list titles of the top 5 lists with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a critic score greater than 8?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for a specific movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the ID 1?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list created by user 123?",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies that have a rating score of 5?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by more than 100 users?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all movies released before the year 2000.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies in the last 30 days?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE rating_timestamp_utc >= date('now','-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by user with id 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by users?",
    "SQL": "SELECT SUM(list_followers) AS total_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released after the year 2000?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique lists are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the user with user_id 1 ?",
    "SQL": "SELECT T1.list_title FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id AND T1.user_id = T2.user_id WHERE T2.user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated by users?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers for all lists?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "which movie is most rated?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_title ORDER BY COUNT(T2.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie with a score of 5?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers for lists that have been updated within the last 30 days?",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_update_timestamp_utc > DATETIME('now','-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Inception'? ",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies in the 'Action' genre?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title LIKE '%Action%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie was released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for the movie with the title 'The Shawshank Redemption'?",
    "SQL": "SELECT COUNT(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'The Shawshank Redemption'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score higher than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that have a rating score of 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies are in the ratings table?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique critics have provided ratings?",
    "SQL": "SELECT COUNT(DISTINCT critic) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a popularity score greater than 500?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie was released in 2020 and has a rating score of 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2020 AND T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does a list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles and their release years from the 'movies' table?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies released after the year 2010?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users with a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the titles of movies released in the year 2021",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Inception'?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and ratings of movies that have a rating score greater than 4?",
    "SQL": "SELECT T1.movie_title, T2.rating_score FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users who have both a payment method and are eligible for a trial?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_has_payment_method = 1 AND T2.user_eligible_for_trial = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of unique users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for each movie in the 'ratings' table?",
    "SQL": "SELECT AVG(rating_score), movie_id FROM ratings GROUP BY movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are subscribed to the list with list_id = 5?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE list_id = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for the movie 'Alien'? ",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title LIKE 'Alien' LIMIT 2",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were released in the year 2021?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating higher than 8 and were released after the year 2000?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8 AND T1.movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated by users in the database?",
    "SQL": "SELECT COUNT(*) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 3?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are rated by users who have a subscriber status?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists_users AS T3 ON T1.user_id = T3.user_id WHERE T3.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest popularity score?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released after the year 2000?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the movie title for movie id 555",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 555",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for the movie 'Inception'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Inception')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for a specific movie?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with list_id 123 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies in the database have a popularity score greater than 500?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies in the 'ratings' table have a rating score greater than 4?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings given for each movie title?",
    "SQL": "SELECT T1.movie_title, COUNT(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies that have a rating score greater than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are rated higher than 4 on average?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in the year 2020?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which users have rated more than 10 movies?",
    "SQL": "SELECT T1.user_id FROM ratings AS T1 GROUP BY T1.user_id HAVING COUNT(T1.movie_id) > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are in the list with the highest number of followers?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T2.movie_id IN ( SELECT movie_id FROM ratings ) WHERE T1.list_followers = ( SELECT MAX(list_followers) FROM lists )",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies have been rated?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies in the database sorted by their release year?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_release_year",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4 and were released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 4 AND movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have the most followers?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with the user with ID 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in the year 2020?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in the year 2021?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a release year greater than 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated a movie and are part of a trial sublist?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE user_trialist = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS list_count FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released after the year 2010?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = ' specific_user_id '",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2021?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have been rated with a score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie based on the ratings in the database?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list with ID 10?",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for a list with a specific title?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title = 'example_title'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2020?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for a specific movie?",
    "SQL": "SELECT COUNT(rating_score) FROM ratings WHERE movie_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie in the database?",
    "SQL": "SELECT COUNT(user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating score of 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the top 5 movies with the highest rating scores",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users since January 1, 2022?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc >= '2022-01-01'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users in the last 30 days?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc > datetime('now', '-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that have a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the ratings table?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings given for each movie?",
    "SQL": "SELECT movie_title, COUNT(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id GROUP BY movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for the movie with the title 'Inception'?",
    "SQL": "SELECT COUNT(*) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are associated with the user with user_id = 1?",
    "SQL": "SELECT T2.movie_title FROM lists_users AS T1 INNER JOIN movies AS T2 ON T2.movie_id IN ( SELECT movie_id FROM ratings WHERE user_id = 1 ) WHERE T1.user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for movies with a release year greater than 2000?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 100 followers?",
    "SQL": "SELECT list_id, list_title FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find all the movie titles from the 'movies' table",
    "SQL": "SELECT movie_title FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 5 and were released after the year 2010?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2010 AND movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated more than 10 movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE user_id IN (SELECT user_id FROM ratings GROUP BY user_id HAVING COUNT(movie_id) > 10)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie that has been released before 2000?",
    "SQL": "SELECT COUNT(DISTINCT T1.user_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 rated movies of all time?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 1?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie with a release year of 2021?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated in the ratings table?",
    "SQL": "SELECT COUNT(*) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "list all the movies with a rating score greater than 4",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users who are also subscribers?",
    "SQL": "SELECT COUNT(T2.list_id) FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id WHERE T1.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in the year 2020?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with ID 101?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 101",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the list titles with more than 10 followers.",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5 and what are their titles?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the 'movies' table?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for movies directed by 'Christopher Nolan'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies based on ratings?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which users have rated a movie and what is the rating score?",
    "SQL": "SELECT T1.user_id, T2.rating_score FROM ratings_users AS T1 INNER JOIN ratings AS T2 ON T1.user_id = T2.user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of followers for list_id 1?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by users?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have an average rating score higher than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id HAVING AVG(rating_score) > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have an average rating score greater than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings GROUP BY movie_id HAVING AVG(rating_score) > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies have been rated?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated by users who have a payment method?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by users?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with ID 10?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of followers for list with list_id 1?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the number of movie ratings with a score of 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does the user with ID 123 follow?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are rated with a score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies with a rating score greater than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest popularity?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies with a rating score of at least 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score >= 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers?",
    "SQL": "SELECT user_id FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and descriptions of the lists that have more than 100 followers?",
    "SQL": "SELECT list_title, list_description FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8 and belong to the science fiction genre?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8 AND T1.movie_title LIKE '%science fiction%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5 and have been reviewed by critics?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score = 5 AND T2.critic IS NOT NULL",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received the highest ratings?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of unique users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2020?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many ratings have a score of 5?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Inception'?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have given ratings to movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest average rating score?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY AVG(rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie according to the ratings?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many ratings does the movie 'Inception' have?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies with a release year greater than 2010?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 4?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year before 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the average rating score of all movies",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the list titles and their corresponding follower counts for lists with more than 100 followers.",
    "SQL": "SELECT list_title, list_followers FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which users have rated the movie 'Inception'?",
    "SQL": "SELECT DISTINCT user_id FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Inception')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in the year 2020?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie with ID 101?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE movie_id = 101",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year greater than 2000 and what is their director's name?",
    "SQL": "SELECT T1.movie_title, T1.director_name FROM movies AS T1 WHERE T1.movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies in the ratings table?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'The Shawshank Redemption'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = 'The Shawshank Redemption'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of followers for the list with ID 123?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest popularity rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating score of 5 from users?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find all the movies that were rated higher than 4 by the user with user_id = 123.",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_id = 123 AND T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of comments on all lists?",
    "SQL": "SELECT SUM(list_comments) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that have a rating score greater than 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does user 123 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies that have received a rating score of 4 or above?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score >= 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the first list created by user with id 1234?",
    "SQL": "SELECT T2.list_title FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id WHERE T1.user_id = 1234 ORDER BY T2.list_creation_timestamp_utc ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated by users who are subscribers?",
    "SQL": "SELECT COUNT(DISTINCT T1.movie_id) FROM ratings AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T2.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for movies released before the year 2000?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie within the last month?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE rating_timestamp_utc >= DATE('now','-1 month')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the ratings table?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with ID 123?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title associated with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie with a score of 5?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with a user with user_id 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies based on their rating scores?",
    "SQL": "SELECT T2.movie_title, T1.rating_score FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with ID 5?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the list titles with a follower count greater than 1000.",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 1000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies that have been rated by at least one user?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies AS T1 JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 3?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 500?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest popularity?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have a movie number greater than 10?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_movie_number > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies are rated?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating higher than 8 out of 10?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year greater than 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were rated by users and what was their average rating score?",
    "SQL": "SELECT AVG(rating_score), movies.movie_title FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id GROUP BY movies.movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies in the 'ratings' table?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie title in the 'movies' table?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2021?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated more than 10 movies?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE user_id IN (SELECT user_id FROM ratings GROUP BY user_id HAVING COUNT(movie_id) > 10)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all lists owned by user_id 123?",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie release year?",
    "SQL": "SELECT AVG(movie_release_year) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies are there in the ratings table?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of unique directors in the movies table?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a popularity score greater than 100?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the highest number of list followers?",
    "SQL": "SELECT T2.user_id FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id ORDER BY T1.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie based on the ratings?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies more than once?",
    "SQL": "SELECT COUNT(user_id) FROM ratings GROUP BY user_id HAVING COUNT(movie_id) > 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the maximum rating score among all ratings?",
    "SQL": "SELECT max(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have the highest ratings?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by users?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of comments on all lists?",
    "SQL": "SELECT SUM(list_comments) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by users?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have ratings higher than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie in the 'movies' table?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies rated by users who have a payment method?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does user 1 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie with an ID of 123?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many ratings does each movie receive?",
    "SQL": "SELECT T1.movie_title, COUNT(T2.rating_id) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movies with a rating score greater than 4",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the maximum number of followers any list has?",
    "SQL": "SELECT MAX(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for a specific movie title?",
    "SQL": "SELECT COUNT(T2.rating_id) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the release year of the movie with the title 'Inception'?",
    "SQL": "SELECT movie_release_year FROM movies WHERE movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of at least 8 and what are their titles?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score >= 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies that have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 50 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie with the title 'Interstellar'?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Interstellar'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that have received a rating score of 5?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies with a release year greater than 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 5?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for each movie?",
    "SQL": "SELECT AVG(rating_score), movie_title FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id GROUP BY movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "For what year was the movie with the title 'Terminator' released?",
    "SQL": "SELECT movie_release_year FROM movies WHERE movie_title = 'Terminator'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are associated with each list?",
    "SQL": "SELECT list_id, COUNT(user_id) FROM lists_users GROUP BY list_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year greater than 2000 and are popular with more than 5000 users?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year > 2000 AND T1.movie_popularity > 5000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users who are eligible for trial?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_eligible_for_trial = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 3?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 3)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Top 10 Best Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 10 Best Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings given to movies?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of all movies that have a rating score of 5?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie with the title 'Inception'?",
    "SQL": "SELECT COUNT(T2.user_id) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of all movies?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most ratings?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_id ORDER BY COUNT(T1.rating_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2015?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year = 2015",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the 'lists' table that have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for movies in the database?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were rated by a user with a subscriber status?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists_users AS T3 ON T3.user_id = T1.user_id WHERE T3.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 3?",
    "SQL": "SELECT movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the movie_id 123?",
    "SQL": "SELECT T1.list_title FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id INNER JOIN movies AS T3 ON T2.user_id = T3.movie_id WHERE T3.movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were rated by users who are not eligible for trial?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_eligible_for_trial = 0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie release year of all movies in the database?",
    "SQL": "SELECT AVG(movie_release_year) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are in the list with list_id 1?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_id = T2.movie_id WHERE T1.list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by each user in 2022?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc LIKE '2022%' GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there in the 'lists' table?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following a specific list?",
    "SQL": "SELECT COUNT(list_followers) FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are rated by users who have a payment method?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id INNER JOIN ratings_users AS T3 ON T3.user_id = T2.user_id WHERE T3.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have subscribed to at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by the user with ID 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by users?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie in the database?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers?",
    "SQL": "SELECT user_id FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of followers for each list title?",
    "SQL": "SELECT list_title, list_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for movies released in the year 2021?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users who have a payment method?",
    "SQL": "SELECT COUNT(DISTINCT l.list_id) FROM lists l JOIN lists_users lu ON l.user_id = lu.user_id WHERE lu.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for a specific movie?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE movie_id = 1234",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie in the ratings table?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the release year of the movie with the highest popularity score?",
    "SQL": "SELECT movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies have been rated?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie in the 'ratings' table?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released after the year 2000?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2021?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest average rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_id ORDER BY AVG(T2.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of movies released in the year 2020?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the list titles and their creation timestamps for users who have more than 10 followers",
    "SQL": "SELECT T1.list_title, T1.list_creation_timestamp_utc FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id GROUP BY T1.list_id HAVING COUNT(T1.list_followers) > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for a specific list with a given list_title?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title = 'Spider-Man'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has rated the highest number of movies?",
    "SQL": "SELECT user_id FROM ratings GROUP BY user_id ORDER BY COUNT(movie_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies have been rated by users?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 5?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 10 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 7?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 7",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 100 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "which movies has 5 rating score ?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year greater than 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie with ID 123?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "how many unique users have rated the movie of their lists?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie popularity for movies that have a rating score of 4 or higher?",
    "SQL": "SELECT AVG(movie_popularity) FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score >= 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2020?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_release_year = 2020)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score higher than 8?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id , COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the average rating score for the movie 'Inception'? ",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies released after the year 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of the movie 'Juno'?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Juno'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies with a rating score greater than 3?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users who have subscribed to a list?",
    "SQL": "SELECT DISTINCT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists_users AS T3 ON T1.user_id = T3.user_id WHERE T3.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists each user has?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that have a rating score higher than 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie with a score greater than 4?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 100 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have at least 100 followers in the lists table?",
    "SQL": "SELECT COUNT(list_followers) FROM lists WHERE list_followers >= 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many ratings are there for the movie 'The Shawshank Redemption'?",
    "SQL": "SELECT COUNT(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'The Shawshank Redemption'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have created more than 5 lists?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY user_id HAVING COUNT(list_id) > 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score on average across all ratings?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_id ORDER BY AVG(T2.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS list_count FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have a rating score greater than 8?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does a list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 5?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does user 123 follow?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies directed by Steven Spielberg?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.director_name = 'Steven Spielberg'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies have received ratings ?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies in the database?",
    "SQL": "SELECT movie_title FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by each user?",
    "SQL": "SELECT T2.user_id, COUNT(T1.list_id) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id GROUP BY T2.user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for each movie in the ratings table?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the number of lists each user has created.",
    "SQL": "SELECT T1.user_id, COUNT(T1.list_id) FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id GROUP BY T1.user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating score higher than 8?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2021?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists follow the movie 'Juno'?",
    "SQL": "SELECT COUNT(*) FROM lists INNER JOIN movies ON lists.list_movie_number = movies.movie_id WHERE movies.movie_title = 'Juno'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a specific movie? Let's consider 'Inception' with a movie_id of 272.",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = 272",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following the list with the title 'Top 10 Must Watch Movies'?",
    "SQL": "SELECT COUNT(list_followers) FROM lists WHERE list_title = 'Top 10 Must Watch Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the average movie popularity of movies that have been rated higher than 3?",
    "SQL": "SELECT AVG(movie_popularity) FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies in the ratings table?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Who created the list titled 'Top 10 Movies of All Time'?",
    "SQL": "SELECT T1.user_id FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T1.list_title = 'Top 10 Movies of All Time'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "how many movies are in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of 5?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to the list with ID 1?",
    "SQL": "SELECT user_subscriber FROM lists_users WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have the highest rating score?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have a rating of 5 by users who are eligible for trial?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score = 5 AND T2.user_eligible_for_trial = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie received the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for the movie 'Inception'?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers a user has across all their lists?",
    "SQL": "SELECT SUM(T1.list_followers) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id GROUP BY T2.user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title and the number of movies in a list with a specific user_id?",
    "SQL": "SELECT T1.list_title, T1.list_movie_number FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T2.user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4 and what are their titles?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated by users who have a payment method?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score?",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many ratings does each movie have?",
    "SQL": "SELECT T1.movie_title, COUNT(T2.rating_score) AS rating_count FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies rated by a user with a rating of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all lists that have more than 50 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie in the database?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to the list with list_id 1?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated with a score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies rated above 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 12345?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 12345",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) AS list_count FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the release year of the movie with the title 'Toy Story'?",
    "SQL": "SELECT movie_release_year FROM movies WHERE movie_title = 'Toy Story'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest average rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_id ORDER BY AVG(T1.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have a movie number greater than 10?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_movie_number > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the maximum movie popularity?",
    "SQL": "SELECT MAX(movie_popularity) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that have received a rating score greater than 8?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 3 and how many users have rated them?",
    "SQL": "SELECT T1.movie_title, COUNT(T2.rating_id) AS number_of_users FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 3 GROUP BY T1.movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list created by user with user_id 1?",
    "SQL": "SELECT T1.list_title FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T2.user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 4?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have given a rating to the movie 'Inception'?",
    "SQL": "SELECT COUNT(T2.user_id) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique directors are there in the movies table?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by each user?",
    "SQL": "SELECT COUNT(list_id), user_id FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie according to the ratings table?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated by users who are eligible for trial?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE user_eligible_for_trial = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and popularity of the movie with ID 1234?",
    "SQL": "SELECT movie_title, movie_popularity FROM movies WHERE movie_id = 1234",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of comments on all lists?",
    "SQL": "SELECT SUM(list_comments) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists follow each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 3?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 3)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies that have been rated by users?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie with the title 'Avengers: Endgame'?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Avengers: Endgame'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and description of the list with the highest number of followers?",
    "SQL": "SELECT list_title, list_description FROM lists WHERE list_followers = ( SELECT MAX(list_followers) FROM lists )",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie received the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the list titles of users who have a follower count greater than 100.",
    "SQL": "SELECT T1.list_title FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T1.list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are there in the lists_users table?",
    "SQL": "SELECT COUNT(*) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by users?",
    "SQL": "SELECT COUNT(DISTINCT list_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated by users who have a payment method?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for a list with a specific title?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title = 'example_title'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all movies with a rating score greater than 4",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies rated by users who have a payment method?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings_users.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in the year 2020?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movies that have a rating score greater than 4.5",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4.5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles with the highest average rating scores?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN (SELECT movie_id, AVG(rating_score) AS avg_score FROM ratings GROUP BY movie_id) AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.avg_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for each movie?",
    "SQL": "SELECT AVG(rating_score), movie_id FROM ratings GROUP BY movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score higher than 4?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies that have a rating score greater than 8.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 50 followers?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie 'Inception'?",
    "SQL": "SELECT COUNT(*) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 rated movies with their release years?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of comments for all lists?",
    "SQL": "SELECT SUM(list_comments) AS total_comments FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 4?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a popularity score greater than 80?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 80",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie with a score of 5?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie from the given database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies rated by users who have subscribed to the platform?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists_users AS T3 ON T1.user_id = T3.user_id WHERE T3.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies on the platform?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that received a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie 'Inception'?",
    "SQL": "SELECT COUNT(T1.user_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following the list with the title 'My Favorite Movies'?",
    "SQL": "SELECT COUNT(T1.user_id) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T1.list_title = 'My Favorite Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for a list with a specific title?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Your List Title'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie release year of all movies rated higher than 8?",
    "SQL": "SELECT AVG(movie_release_year) FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the title 'My Favorite Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'My Favorite Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Retrieve the list title of the user with user_id 12345",
    "SQL": "SELECT T1.list_title FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T2.user_id = 12345",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "how many ratings have a score greater than 4",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies that have a rating score greater than 4?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie on the platform?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie 'The Dark Knight'?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE movie_id = ( SELECT movie_id FROM movies WHERE movie_title = 'The Dark Knight' )",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies in the 'ratings' table have a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating higher than 8?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique lists are created by each user?",
    "SQL": "SELECT user_id, COUNT(DISTINCT list_id) AS number_of_lists FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score of at least 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score >= 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has rated the movie with the highest rating score?",
    "SQL": "SELECT user_id FROM ratings ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) AS avg_rating FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were released before 1990?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year < 1990",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique critics have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT critic) AS unique_critics FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with list_id 1?",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for a specific movie?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE movie_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated by users who are subscribers?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for the movie with the highest popularity?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 5 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 5?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 10 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year greater than 2010?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Inception'?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the 'lists' table?",
    "SQL": "SELECT COUNT(*) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8 and are in English?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8 AND T1.movie_title_language = 'English'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a popularity rating above 500 and have received a rating score of 4 or higher from users?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_popularity > 500 AND T1.rating_score >= 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the 'top rated' list?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with movie_id 2023?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 2023",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with title 'Top Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and creation timestamps of all lists created by user 1?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie 'Inception'?",
    "SQL": "SELECT COUNT(user_id) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many ratings have a score of 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY sum(list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of followers for each list in the 'lists' table?",
    "SQL": "SELECT list_id, list_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are rated by users who are trialists?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists_users AS T3 ON T1.user_id = T3.user_id WHERE T1.user_trialist = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with ID 12345?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 12345",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie popularity of movies that have received a rating score of 5?",
    "SQL": "SELECT AVG(T1.movie_popularity) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by users?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by each user?",
    "SQL": "SELECT COUNT(list_id), user_id FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Retrieve the titles and descriptions of lists created by a specific user",
    "SQL": "SELECT T1.list_title, T1.list_description FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T2.user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users who have a payment method?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released after the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were rated by users who are subscribers?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) AS number_of_lists FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and descriptions of the lists that have more than 10 followers?",
    "SQL": "SELECT list_title, list_description FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies rated by users?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies AS T1 JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 500?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with movie_id 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies are in the ratings table?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie with a rating score of at least 4?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score >= 4 ORDER BY T1.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies rated by users with a payment method?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id INNER JOIN lists_users AS T3 ON T1.user_id = T3.user_id WHERE T3.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie with the title 'Inception'? ",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a release year greater than 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have a rating score of 4 or higher?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score >= 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users are in the database?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 8?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of movies with a release year after 2010?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated higher than 4 out of 5 by users?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for a list with a specific list title?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title = 'Example List Title'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of movies rated by a user with ID 1?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the id and title of the list that created in last 30 days",
    "SQL": "SELECT list_id , list_title FROM lists WHERE list_creation_timestamp_utc > DATE('now','-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the ID 123?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies in the database?",
    "SQL": "SELECT movie_title FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Inception'?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released after the year 2010?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with list_id 100 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie with the title 'Juno'?",
    "SQL": "SELECT AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'Juno'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that have received a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title for a list with more than 5 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have the most followers and what is the average movie number of these lists?",
    "SQL": "SELECT list_title, AVG(list_movie_number) FROM lists GROUP BY list_title ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2020?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have received a rating score of at least 8?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score >= 8)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have received a rating score of 5?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of unique movies in the database?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have the highest rating scores?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the highest number of followers?",
    "SQL": "SELECT user_id FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4 and how many such movies are there?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies that have a rating score greater than 8?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "list one of the movie titles and their release years from the 'movies' table",
    "SQL": "SELECT movie_title, movie_release_year FROM movies LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie in the database?",
    "SQL": "SELECT COUNT(user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2020?",
    "SQL": "SELECT AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies with a rating score greater than 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with ID 1?",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies with a popularity score greater than 50.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for all movies in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie with the highest popularity?",
    "SQL": "SELECT COUNT(user_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  }
]