[
  {
    "question": "What is the average rating score for movies rated by users who are not subscribers?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_subscriber = 0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movie titles with their release years and director names that are rated higher than 4.5 in the ratings table?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year, T1.director_name FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4.5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to a list?",
    "SQL": "SELECT COUNT(DISTINCT user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movie directors are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies directed by Christopher Nolan.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies released after 2010 and order them by their release year.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2010 ORDER BY movie_release_year",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the 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 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 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 released in each year?",
    "SQL": "SELECT movie_release_year, COUNT(*) FROM movies GROUP BY movie_release_year",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies at least once?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many different genres of movies are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT movie_title) FROM movies",
    "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": "What are the titles of the movies that have received a rating score of 5 by a critic? ",
    "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 that 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": "How many users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the oldest movie in the database?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Christopher Nolan'",
    "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 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": "Which movie has the highest rating score and what is its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies in the 'movies' table.",
    "SQL": "SELECT movie_title FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released before the year 2000?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year < 2000",
    "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 all the movies that have a critic's score greater than 7. Include the movie title, critic's score, and critic's comments.",
    "SQL": "SELECT movie_title, rating_score, critic_comments FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_score > 7",
    "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": "State the average rating score for movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie and what is the average rating score?",
    "SQL": "SELECT COUNT(user_id), AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the title and release year of all movies directed by Christopher Nolan.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in each director's list?",
    "SQL": "SELECT COUNT(movie_id), director_name FROM movies GROUP BY director_name",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by each user in 2020?",
    "SQL": "SELECT COUNT(list_id), user_id FROM lists WHERE SUBSTR(list_creation_timestamp_utc, 1, 4) = '2020' GROUP BY user_id",
    "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": "Find the titles of all movies directed by Christopher Nolan.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the top 5 most popular movies with their release years and director names.",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are there in the 'ratings_users' table?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users",
    "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": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated higher than 4 out of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to a list?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_subscriber) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released in 2020?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2020",
    "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 average rating score for movies rated by more than 100 users?",
    "SQL": "SELECT AVG(rating_score) FROM ratings GROUP BY movie_id HAVING COUNT(rating_score) > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score? What is its title and release year?",
    "SQL": "SELECT movie_title, movie_release_year 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 followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released in the year 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers and what is their user ID?",
    "SQL": "SELECT user_id FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists and users that have interacted with those lists?",
    "SQL": "SELECT COUNT(list_id) + COUNT(user_id) AS total_interactions FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released after the year 2000?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year > 2000",
    "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": "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": "List the user IDs who have rated the movie with the highest rating score.",
    "SQL": "SELECT user_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies released in 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020 ORDER BY movie_popularity DESC LIMIT 5",
    "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 JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Write a query to get the list titles of lists that have more than 5 followers.",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many different genres of movies are in the 'movies' table?",
    "SQL": "SELECT COUNT(DISTINCT movie_title_language) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to more than 100 lists?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE user_subscriber > 100",
    "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 director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie in the 'movies' table?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity 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 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 and URL of the most recently updated list by a user?",
    "SQL": "SELECT list_title, list_url FROM lists ORDER BY list_update_timestamp_utc DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers a user has?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users follow a list with a title containing the word 'Adventure'?",
    "SQL": "SELECT COUNT(user_id) FROM lists WHERE list_title LIKE '%Adventure%'",
    "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": "How many users have a payment method? ",
    "SQL": "SELECT COUNT(user_has_payment_method) FROM lists_users WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie in the database?",
    "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 most popular movie? When was it released and who is the director for the movie?",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "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": "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": "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": "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": "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": "List all movie titles directed by 'Christopher Nolan'",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "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 with a rating score greater than 4, sorted by release year in descending order?",
    "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_release_year DESC",
    "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 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": "Who are the directors of the movies that have the highest number of followers?",
    "SQL": "SELECT T2.director_name FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_id = T2.movie_id ORDER BY T2.movie_release_year DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users and what is the average number of followers among these lists?",
    "SQL": "SELECT COUNT(list_id) AS total_lists, AVG(list_followers) AS average_followers FROM lists",
    "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": "List all movies released in 2021 and their directors.",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5 and what is the average release year of these movies?",
    "SQL": "SELECT COUNT(*), AVG(movie_release_year) FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by user with ID 123?",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE user_id = 123",
    "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 total number of lists created by each user and the most popular list title for each user?",
    "SQL": "SELECT T1.user_id, COUNT(T2.list_id) AS total_lists_created, MAX(T2.list_title) AS most_popular_list_title FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.user_id = T2.user_id GROUP BY T1.user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 50?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_popularity > 50",
    "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": "List the top 5 most popular movies along with their release years and directors.",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that 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 most popular movie title and its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity 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 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 lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS num_lists FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers in their lists?",
    "SQL": "SELECT T1.user_id FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id GROUP BY T1.user_id ORDER BY SUM(T2.list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have subscribed to a list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) AS total_subscribers FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the user with the user_id 12345?",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 12345",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all movies with a rating score greater than 4. Order the results by the number of ratings in descending order.",
    "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 GROUP BY T2.movie_id ORDER BY COUNT(T2.rating_id) DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of the movie 'Inception'? ",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers?",
    "SQL": "SELECT user_id, MAX(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated with a score of 5 by users who are subscribers?",
    "SQL": "SELECT COUNT(T2.user_id) FROM ratings AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T1.rating_score = 5 AND T2.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were released before 2000 and have more than 10,000 followers?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN lists AS T2 ON T1.movie_id = T2.list_movie_number WHERE T2.list_followers > 10000 AND T1.movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020 ORDER BY movie_popularity DESC LIMIT 5",
    "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 subscribed to lists?",
    "SQL": "SELECT SUM(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most recently released movie in the database?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_release_year DESC LIMIT 1",
    "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": "What are the top 5 most popular movies and their release years?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and creation timestamps of the lists with the highest number of followers?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are released before the year 2000 and 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 AND T1.movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies 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 is the average number of followers for lists with a movie number greater than 5?",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_movie_number > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie(s) have the highest rating score and what is their release year?",
    "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 on the list?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by users?",
    "SQL": "SELECT COUNT(DISTINCT list_id) AS total_lists FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following list with the title 'Top 10 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 = 'Top 10 Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what are the titles of the movies that 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 lists were created by each user and what is the average number of followers per list?",
    "SQL": "SELECT user_id, COUNT(list_id) AS number_of_lists, AVG(list_followers) AS average_followers FROM lists GROUP BY user_id",
    "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": "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": "List the titles of all movies that have a rating score greater than 4. Order the movies by their release year in descending order.",
    "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_release_year DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie 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": "How many movies were released in 2020?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 500 and what is the average rating score for these movies?",
    "SQL": "SELECT COUNT(*), AVG(rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_popularity > 500",
    "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": "Which movie was rated the highest and what is its popularity score?",
    "SQL": "SELECT movie_title, movie_popularity FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie and how many times has it been rated?",
    "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 ORDER BY T1.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were rated higher than 4.5 out of 5 and by how many critics?",
    "SQL": "SELECT movie_title, COUNT(critic) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_score > 4.5 GROUP BY movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total 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": "How many movies were released in the year 2020?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that were released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have over 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "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": "How many unique movie directors are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists 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": "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 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": "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": "Which movies have a rating score greater than 7 and were released after the year 2000? List them by their rating scores in descending order.",
    "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 > 7 AND T2.movie_release_year > 2000 ORDER BY T1.rating_score DESC",
    "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 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 lists have more than 10 followers?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is its director's name?",
    "SQL": "SELECT T1.movie_title, T1.director_name 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 cover image URL of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title, T2.list_cover_image_url FROM movies AS T1 INNER JOIN lists AS T2 ON T1.movie_id = T2.list_movie_number ORDER BY T2.list_movie_number DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie and its release year?",
    "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 average rating score for movies rated by users who are subscribers?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a specific 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 average rating score of all movies in the ratings table?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie and its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are listed in the 'lists_users' table?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score higher than 8?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released before the year 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year < 2000",
    "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 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 released in the year 2020?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2020",
    "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": "How many users have made a trial list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists_users WHERE user_trialist = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the average rating score for movies that were released in 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": "List all movies with a rating score greater than 4 and display their titles, release years, and directors' names.",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "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 average rating score 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": "What are the movie titles and their release years that have received a rating score of 5?",
    "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 WHERE T2.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that 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 movies are there in the database that were released after the year 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for the movie 'The Godfather'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Godfather')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie and its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "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": "Which movie has the highest rating score and what is its title?",
    "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 for a specific movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have more than 10 followers?",
    "SQL": "SELECT COUNT(user_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many different directors are in the 'movies' table?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the most followers and when was it released?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_movie_number = T2.movie_id ORDER BY T1.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers on the platform and what is their list creation timestamp?",
    "SQL": "SELECT T1.user_id, T2.list_creation_timestamp_utc FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id GROUP BY T1.user_id ORDER BY SUM(T2.list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the title and creation timestamp of the most recent list created by any user.",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists ORDER BY list_creation_timestamp_utc DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is its release year?",
    "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 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 total number of comments for all lists?",
    "SQL": "SELECT SUM(list_comments) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have been rated by more than 10 users?",
    "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 HAVING COUNT(T2.user_id) > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movie titles that have received a rating score greater than 8 out of 10, along with the release year of these movies.",
    "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 WHERE T2.rating_score > 8",
    "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": "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": "What is the title and the release year of the most rated movie by critics?",
    "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 title of the movie that 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": "How many followers does the list with the title 'My Movie List' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'My Movie List'",
    "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": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title, rating_score 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 are eligible for trial and have a payment method?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_eligible_for_trial = 1 AND user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list that 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 list title of the list that has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the titles of all movies released after the year 2010 and the directors of these movies.",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie 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": "What is the title of the movie with the most ratings?",
    "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_id ORDER BY COUNT(T2.rating_id) 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 average movie rating score for the movie with the highest popularity?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies directed by Christopher Nolan and their release years.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most viewed lists in descending order of list followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating and who rated it?",
    "SQL": "SELECT T1.movie_title, T2.user_id 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 in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most followed lists with their titles and follower counts?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the database?",
    "SQL": "SELECT COUNT(*) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a subscriber status?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie director? How many movies has this director made?",
    "SQL": "SELECT T2.director_name, COUNT(*) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.director_name ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies with 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 total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "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": "How many users have subscribed to the service?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the movies with a release year greater than 2000 and list them by their movie popularity.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000 ORDER BY movie_popularity DESC",
    "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 most followed list title in the database?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated movies in the database?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "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": "Who directed the movie with the highest rating score?",
    "SQL": "SELECT T2.director_name 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 the movie 'The Lord of the Rings: The Return of the King'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_title = 'The Lord of the Rings: The Return of the King'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for 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": "What is the total number of ratings for movies released after 2010?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_release_year > 2010)",
    "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 unique movies have been rated?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for movies released in the year 2020?",
    "SQL": "SELECT COUNT(rating_id) 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 have been rated by at least one user?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS total_lists FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of a movie that has a rating score greater than 8?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most recently updated list of movies? When was it updated?",
    "SQL": "SELECT list_update_timestamp_utc FROM lists ORDER BY list_update_timestamp_utc DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles and their respective release years that have a popularity score greater than 500?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by 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 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": "How many users who have made a trial list and are subscribers have rated movies? ",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE user_trialist = 1 AND user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were released between the years 2010 and 2020, and what is the average rating score for each movie?",
    "SQL": "SELECT movies.movie_title, AVG(ratings.rating_score) AS average_rating FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE movies.movie_release_year BETWEEN 2010 AND 2020 GROUP BY movies.movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of 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": "Get the list titles of the lists created by users who are trialists. Sort the list titles by their update timestamps in descending order.",
    "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_trialist = 1 ORDER BY T2.list_update_timestamp_utc DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and URL of the most popular movie?",
    "SQL": "SELECT movie_title, movie_url FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movie titles that have a rating score greater than 4.5 and the critic likes this rating more than 5.0.",
    "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 AND T1.critic_likes > 5.0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles and creation timestamps of all lists that have been updated in the last 30 days.",
    "SQL": "SELECT list_title, list_update_timestamp_utc FROM lists WHERE list_update_timestamp_utc >= DATETIME('now','-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated by users with a trialist status?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE user_trialist = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are there who 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 at least one movie in the 'ratings' table?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a release year greater than 2010?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Steven Spielberg?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name = 'Steven Spielberg')",
    "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_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 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": "How many movies have been rated by users who have a payment method?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers in the lists table?",
    "SQL": "SELECT user_id, MAX(list_followers) FROM lists",
    "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": "How many followers does the list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 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": "How many users have made more than 10 ratings?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE user_id IN (SELECT user_id FROM ratings GROUP BY user_id HAVING COUNT(user_id) > 10)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total 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": "name 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 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 average rating score 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": "How many lists does the user with user_id 123 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with each user?",
    "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 users who are subscribers have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the top 5 movies with the highest ratings. Include the movie title, the rating score, and the movie release year.",
    "SQL": "SELECT T1.movie_title, T2.rating_score, 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 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the most followers have?",
    "SQL": "SELECT list_followers FROM lists ORDER BY list_followers 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": "What is the title and the 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": "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": "How many users have rated a movie and have a payment method?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE user_has_payment_method = 1",
    "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": "What is the most popular movie in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies with 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 lists created by each user and the average number of followers per list for each user?",
    "SQL": "SELECT T1.user_id, COUNT(T2.list_id) AS total_lists, AVG(T2.list_followers) AS avg_followers 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": "How many lists do users have on average?",
    "SQL": "SELECT AVG(list_count) FROM (SELECT COUNT(list_id) AS list_count FROM lists_users GROUP BY user_id)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for a specific movie title?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = 'Example Movie Title'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "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 movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name = 'Christopher Nolan')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated?",
    "SQL": "SELECT COUNT(movie_id) 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": "How many users have a subscriber status?",
    "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 in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "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 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 are there for a specific user, let's say user_id = 123?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies? How many users have subscribed to the service?",
    "SQL": "SELECT COUNT(DISTINCT user_id) AS 'Rated Users', COUNT(DISTINCT user_subscriber) AS 'Subscribed Users' FROM ratings_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score? What is the director's name for that movie?",
    "SQL": "SELECT T1.movie_title, T1.director_name 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 the movies that have a popularity rating greater than 5?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_popularity > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and its title, release year, and director's name?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year, T1.director_name, T2.rating_score 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": "Which user has the most followers on the list platform?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY SUM(list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles and release years of the top 5 most popular movies along with their director's names.",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "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 are the titles and release years of the top 10 most popular movies?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most viewed list on the platform? How many followers does it have?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_movie_number DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are followers of a list with a movie number greater than 5?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists WHERE list_movie_number > 5 AND list_followers > 0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for a movie by a specific director?",
    "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 = 'John Doe'",
    "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": "How many users have more than 10 followers in their lists?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie? When was it released and who is the director?",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "The most followed list?",
    "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 unique users have rated movies in the database?",
    "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": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(movie_id) 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 highest user 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 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": "Query for the number of 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 of the movie 'Inception'? ",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users follow the list titled 'Movie Recommendations'?",
    "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 = 'Movie Recommendations'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in 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 average movie rating score for a movie with a specific movie title, e.g. '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 users have a subscriber status and are eligible for trial?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE user_subscriber = 1 AND user_eligible_for_trial = 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 average rating score of all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movies that have been rated with a score of 5 and their corresponding directors?",
    "SQL": "SELECT T1.movie_title, T1.director_name 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 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 the five most popular movies and their release years?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by 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 average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Christopher Nolan'",
    "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 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": "Retrieve the list titles that have more than 10 followers and order them by the number of followers in descending order.",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10 ORDER BY list_followers DESC",
    "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": "What is the most rated movie in 2021? How many ratings does it have?",
    "SQL": "SELECT T2.movie_title, COUNT(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE STRFTIME('%Y', T1.rating_timestamp_utc) = '2021' ORDER BY COUNT(T1.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all the movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating of 5 and how many have a rating of 4?",
    "SQL": "SELECT rating_score, COUNT(*) FROM ratings GROUP BY rating_score",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the list creation timestamp and update timestamp for a user with user_id 5.",
    "SQL": "SELECT T1.list_creation_timestamp_utc, T1.list_update_timestamp_utc FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T2.user_id = 5",
    "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 are the titles of the movies released in the year 2020 and what is the average rating of these movies?",
    "SQL": "SELECT T1.movie_title, 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 GROUP BY T1.movie_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating and what is the critic's comment?",
    "SQL": "SELECT T2.movie_title, T1.critic_comments 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 movies in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers a list has? What is the list title for that average number?",
    "SQL": "SELECT AVG(list_followers), list_title FROM lists GROUP BY list_title ORDER BY AVG(list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie title and its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what movie with a director named David Fincher was released most recently ?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'David Fincher' ORDER BY movie_release_year DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score, and what is the 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": "How many movies in the database were released before 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many different movie directors are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "The top 5 most popular movies based on user ratings, along with the release year and director's name.",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year, T2.director_name 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 total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released between 1990 and 2000?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year BETWEEN 1990 AND 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest average rating? What is the average rating?",
    "SQL": "SELECT T2.movie_title, AVG(T1.rating_score) AS average_rating FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_title ORDER BY average_rating DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all movies?",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 5000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_popularity > 5000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for each user_id?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by users in the year 2021?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE list_creation_date_utc LIKE '2021%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have ratings above 4? What are their titles and 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 WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the user with user_id 1 have?",
    "SQL": "SELECT list_followers FROM lists WHERE user_id = 1",
    "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": "Which user has rated the most 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 followers does the list with the title 'Top 10 Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 10 Movies'",
    "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 WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_release_year > 2010)",
    "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 are the titles of all movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score? What is its title and release year?",
    "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": "Find the list title with the most followers.",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "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": "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": "List the movie titles and their directors that were released in the year 2021.",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 1000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_popularity > 1000",
    "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": "What is the average movie rating for the movie '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": "What are the titles of the movies that 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 are the titles of the top 5 most popular movies and their release years?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 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 and release year of the movie with the highest popularity?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the average rating score for a movie with a popularity of more than 500. Also, provide the total number of ratings for the movie.",
    "SQL": "SELECT AVG(rating_score), COUNT(*) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_popularity > 500",
    "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 are the top 3 most popular movies and their release years?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers a list has?",
    "SQL": "SELECT sum(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score 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 is the most popular movie released in the year 2000? What is its title and release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_release_year = 2000 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie and what is its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the most ratings?",
    "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_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the titles of movies directed by Steven Spielberg.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Steven Spielberg'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies with a rating score of 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score = 5",
    "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": "What is the average movie popularity among movies that have a popularity greater than 1000?",
    "SQL": "SELECT AVG(movie_popularity) FROM movies WHERE movie_popularity > 1000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that 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": "What are the titles of the top 5 most popular movies and their respective directors?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by users and what are their average scores?",
    "SQL": "SELECT movie_title, AVG(rating_score) AS average_rating FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id GROUP BY movie_title",
    "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 lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the top 5 most popular movies by their release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie?",
    "SQL": "SELECT COUNT(user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is the rating score?",
    "SQL": "SELECT movie_title, rating_score FROM movies 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 a movie with a rating score greater than 3? List their user IDs.",
    "SQL": "SELECT user_id FROM ratings WHERE rating_score > 3",
    "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": "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 of the movie with the highest rating score? How many users have rated it?",
    "SQL": "SELECT T1.movie_title, COUNT(T2.user_id) as number_of_ratings 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 the titles of all movies directed by Christopher Nolan in descending order of release year.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan' ORDER BY movie_release_year DESC",
    "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": "Get the names of all movies rated higher than 4.5 by users who have made more than 100 reviews. Also, return the average rating for each movie.",
    "SQL": "SELECT T1.movie_title, AVG(T2.rating_score) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4.5 GROUP BY T1.movie_title HAVING COUNT(T2.user_id) > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie title in the database?",
    "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 and what is its release year?",
    "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 are directed by Christopher Nolan?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have received a rating of 5?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) AS total_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie in the database? What is its release year?",
    "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 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 average rating score for the movie 'The Godfather'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Godfather')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 10 most viewed lists?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_comments DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name 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 4? Sort the results by the movie popularity in descending order.",
    "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 ORDER BY T2.movie_popularity DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2000?",
    "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 = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies directed by Christopher Nolan.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year, T2.director_name 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 movies in the database have a rating score greater than 7?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 7",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 800?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_popularity > 800",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies in 2021?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2021 ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been released since the year 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year >= 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most ratings?",
    "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_id ORDER BY COUNT(T2.rating_id) 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 movies have a rating score greater than 4? List their titles and 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 WHERE T1.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": "What are the titles of movies directed by Christopher Nolan that have a rating score greater than 7?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.director_name = 'Christopher Nolan' AND T2.rating_score > 7",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are associated with list_id 10?",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE list_id = 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies directed by Christopher Nolan.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does a list have?",
    "SQL": "SELECT list_followers FROM lists LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have followers more than 1000?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 1000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies directed by Christopher Nolan? ",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique directors are associated with movies in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a payment method and are eligible for a trial?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_has_payment_method = 1 AND user_eligible_for_trial = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie and its release year?",
    "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 average rating score for movies released in 2019?",
    "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 = 2019",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for lists in the year 2022?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE STRFTIME('%Y', list_creation_timestamp_utc) = '2022'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique directors have worked on movies listed in the 'lists' table?",
    "SQL": "SELECT COUNT(DISTINCT T1.director_name) FROM movies AS T1 INNER JOIN lists AS T2 ON T2.user_id = T1.director_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 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 title, release year, and director name of the most popular movie?",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies from the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020 ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies that have received a rating score of 5 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",
    "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 INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique directors are associated with the movies in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "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": "What is the total number of users who have rated movies and the average rating score given by these users?",
    "SQL": "SELECT COUNT(user_id), AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles with a rating score of 5 and their corresponding directors?",
    "SQL": "SELECT T2.movie_title, T2.director_name 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 and its release year?",
    "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 users are subscribed to the service?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a specific user and the number of followers for each list?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE user_id = 1",
    "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": "How many unique directors are there in the movies table?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "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": "Write a SQL query to list the titles of all movies that have been rated by at least 10 users.",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_id HAVING COUNT(T1.user_id) >= 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have given ratings to movies in the 'ratings' table?",
    "SQL": "SELECT COUNT(DISTINCT user_id) AS unique_user_count 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 of movies released in the year 2020?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2020",
    "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? What is the average rating score?",
    "SQL": "SELECT COUNT(DISTINCT user_id), AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and URL of the most popular movie?",
    "SQL": "SELECT movie_title, movie_url FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most followed lists on the platform and their creation timestamps?",
    "SQL": "SELECT list_id, list_followers, list_creation_timestamp_utc FROM lists ORDER BY list_followers DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 8 and have been rated by at least 10 users? Provide the movie title and the average rating score.",
    "SQL": "SELECT T1.movie_title, AVG(T2.rating_score) as average_rating FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 8 GROUP BY T1.movie_title HAVING COUNT(T2.user_id) >= 10",
    "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(user_id) > 10)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Query the number of distinct users who have rated movies",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most recently updated list?",
    "SQL": "SELECT list_title, list_update_timestamp_utc FROM lists ORDER BY list_update_timestamp_utc DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for each movie in the database?",
    "SQL": "SELECT AVG(rating_score) FROM ratings GROUP BY movie_id",
    "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 most popular movie title?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020 ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have a total 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 users have a trialist status and are subscribers? ",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE user_trialist = 1 AND user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in 2020?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most commented list on the platform?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_comments DESC LIMIT 1",
    "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 director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all lists that have more than 10 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles that have received 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 were created by users in the last month?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc >= date('now','-30 days')",
    "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 different movies are rated by users and what is the average rating score for each movie?",
    "SQL": "SELECT COUNT(DISTINCT T1.movie_id), AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Select the list titles of the lists that 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 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": "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 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 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 the movie 'The Dark Knight'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'The Dark Knight')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the movie titles and their corresponding release years for movies with a popularity rating higher than 50.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_popularity > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique directors have made movies in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "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 INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Steven Spielberg'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the movie titles and their release years for movies directed by 'Christopher Nolan'.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christopher Nolan'",
    "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 movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists each user has created?",
    "SQL": "SELECT user_id, COUNT(list_id) AS total_lists FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies with the highest ratings?",
    "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 with the most followers and its title.",
    "SQL": "SELECT list_id, list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the title of the movie with the highest rating score. What is its release year and the name of the director?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year, T1.director_name 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 the movie titles directed by Christopher Nolan and their release years.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for 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": "How many users have a payment method?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name = 'Christopher Nolan')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most followers on a list?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T2.movie_id = T1.list_movie_number ORDER BY T1.list_followers 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": "What is the total number of movies and their average popularity?",
    "SQL": "SELECT COUNT(movie_id), AVG(movie_popularity) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of the movies that were released in the year 2020 and 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 T1.movie_release_year = 2020 AND T2.rating_score > 8",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a release year of 2020?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies in the database have a popularity score greater than 500?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find 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 director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "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 most popular movie in 2021 and what is its director name?",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 2021 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are there in the 'lists_users' table?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for a particular movie title?",
    "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 = 'The Matrix'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Select the list title and the creation timestamp of the list with the highest number of followers.",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have created at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies that have received a rating score of 4 or higher.",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score >= 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the title 'My Top 10 Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'My Top 10 Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by each user? Group the results by user ID.",
    "SQL": "SELECT user_id, COUNT(list_id) as total_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 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": "List the movie titles and their release years of all movies directed by Christopher Nolan.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christopher Nolan'",
    "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": "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 a movie 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": "Which movies were released between 2000 and 2010 and what is their average rating?",
    "SQL": "SELECT AVG(rating_score), movie_title FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_release_year BETWEEN 2000 AND 2010 GROUP BY movie_title",
    "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": "How many unique users have rated movies?",
    "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 has the user with ID 10 rated?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE user_id = 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Steven Spielberg?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name = 'Steven Spielberg')",
    "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 unique users have rated movies in the 'ratings' table?",
    "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 and how many ratings does it have?",
    "SQL": "SELECT T1.movie_title, COUNT(T2.rating_id) as rating_count 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 rating score of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title, T2.rating_score 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 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": "Which movie has the highest rating score and what is the rating score?",
    "SQL": "SELECT T1.movie_title, T2.rating_score 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 are there in the database?",
    "SQL": "SELECT COUNT(*) 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": "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 average rating score of 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": "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 are the top 5 most popular movies based on their 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 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for each user_id?",
    "SQL": "SELECT user_id, COUNT(list_id) AS num_lists FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies in the database have a release year before 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most followed lists and their titles?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 5",
    "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": "List the top 5 most popular movies and their release years.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 5 and what is their average rating score?",
    "SQL": "SELECT T2.movie_title, AVG(T1.rating_score) AS average_rating 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": "Find the total number of followers for all lists in the database.",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie(s) has a release year greater than 2000 and has received a rating score greater than 8? Return the movie title, release year, and rating score.",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year, T2.rating_score FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_release_year > 2000 AND T2.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 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 users have paid for the trial and have a payment method? ",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_trialist = 1 AND user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated the movie 'Inception'?",
    "SQL": "SELECT COUNT(rating_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 followers does the list with the title 'Top 50 Marvel Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 50 Marvel Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id 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? What is the rating score and the release year of the movie?",
    "SQL": "SELECT T1.movie_title, T2.rating_score, 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": "List the titles of all movies that have a rating score greater than 4 out 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 > 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": "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 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 have been released in the year 2021?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the most popular list have?",
    "SQL": "SELECT list_followers FROM lists ORDER BY list_movie_number DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list of movies with the highest rating score from the ratings table?",
    "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 and what is its release year?",
    "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": "list the top 5 movies based on their popularity",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists 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 and who is the director of that movie?",
    "SQL": "SELECT T2.movie_title, T2.director_name 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 movies released in 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": "What is the average rating score for a movie with a rating score greater than 4?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE rating_score > 4",
    "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 lists are created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most followed list and its number of followers?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers 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 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 movie rating score for movies released after the year 2010?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with 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 T2.movie_title ORDER BY AVG(T1.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie '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": "What is the average rating score 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 is the list title of the most followed list? How many followers does it have?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers 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 most popular movie in 2022 and what is its director?",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 2022 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "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": "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": "Find the average rating score for all movies.",
    "SQL": "SELECT AVG(rating_score) AS average_rating 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 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 unique directors are associated with movies in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released after the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2020?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are currently subscribers to lists?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the user ID of the user who 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": "Which movies were released in the year 2000 and have a rating score higher than 4?",
    "SQL": "SELECT DISTINCT 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 T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "SQL query to find 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": "How many movies are in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists do users have? How many unique users are there?",
    "SQL": "SELECT COUNT(list_id), COUNT(DISTINCT user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies in the database are directed by Christopher Nolan?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE director_name = 'Christopher Nolan'",
    "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": "What is the total number of comments for all lists?",
    "SQL": "SELECT sum(list_comments) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie popularity for movies released after the year 2000?",
    "SQL": "SELECT AVG(movie_popularity) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in 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": "List the titles of the top 10 most popular movies",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released after the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the user IDs from the ratings table who have rated more than 5 movies.",
    "SQL": "SELECT user_id FROM ratings GROUP BY user_id HAVING COUNT(movie_id) > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of the movie with the highest rating score?",
    "SQL": "SELECT AVG(rating_score) FROM ratings 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 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": "How many movies are in the database?",
    "SQL": "SELECT COUNT(*) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie with a score greater than 5?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated movies in 2022?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE rating_timestamp_utc LIKE '2022%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie that was released in the year 2020?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_release_year = 2020",
    "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 INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles and their respective directors for the most popular movies in each year from 2000 to 2010?",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year BETWEEN 2000 AND 2010 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie director has directed the most movies?",
    "SQL": "SELECT director_name FROM movies GROUP BY director_name ORDER BY COUNT(movie_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that has the highest average rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_id ORDER BY AVG(T2.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score? Who is the director of the movie and when was it released?",
    "SQL": "SELECT T1.movie_title, T1.director_name, 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 total number of ratings given by users for movies released before 2010?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year < 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the average rating score for a given movie title",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'Your Movie Title')",
    "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": "Write a query to find 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": "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 average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS r JOIN movies AS m ON r.movie_id = m.movie_id WHERE m.director_name = 'Christopher Nolan'",
    "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 WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Shawshank Redemption')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name, release year, and director of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year, T2.director_name 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 in the last 30 days?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings WHERE rating_timestamp_utc >= DATETIME('now', '-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name movie titles that are directed by Christopher Nolan and released after the year 2000. Sort the listing by the descending order of movie popularity.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan' AND movie_release_year > 2000 ORDER BY movie_popularity DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Select the number of unique movie titles in the ratings table",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2020 and have a rating score greater than 8?",
    "SQL": "SELECT COUNT(*) FROM movies AS M JOIN ratings AS R ON M.movie_id = R.movie_id WHERE R.rating_score > 8 AND M.movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released in each year?",
    "SQL": "SELECT movie_release_year, COUNT(movie_id) AS total_movies FROM movies GROUP BY movie_release_year",
    "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 INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie and the director's name?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated by users who are eligible for trial?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE user_eligible_for_trial = 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 ratings.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that 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 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": "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 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": "What are the titles and release years of the top 5 most popular movies?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by more than 500 followers?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 500",
    "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": "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": "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": "How many followers does the list with the title 'Top 50 Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 50 Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is the critic's comment for that movie?",
    "SQL": "SELECT T2.movie_title, T1.critic_comments 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 followers does the list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "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 title and release year of the movie with the highest average 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 GROUP BY T1.movie_id ORDER BY AVG(T1.rating_score) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies and their release years?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been released after the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 500?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following a specific list with a given list ID?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE list_id = 123",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for a particular user_id?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "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 have a rating score greater than 4?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists do users follow?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of movies that have received a rating of 4 or higher by users who are both trialists and subscribers.",
    "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 AND T2.user_trialist = 1 AND T2.user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following a specific list? Which list?",
    "SQL": "SELECT list_followers, list_title FROM lists WHERE list_id = 'SPECIFIC_LIST_ID'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies and their release years?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY 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": "How many unique directors are there in the 'movies' table?",
    "SQL": "SELECT COUNT(DISTINCT director_name) AS unique_directors FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Who is the director of the movie with the most ratings?",
    "SQL": "SELECT T2.director_name FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.director_name ORDER BY COUNT(T1.rating_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have both a trialist and a subscriber status?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE user_trialist = 1 AND user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the highest number of followers in a list?",
    "SQL": "SELECT user_id FROM lists ORDER BY list_followers DESC LIMIT 1",
    "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": "How many lists does the user with user_id 123 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "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 most viewed list title? How many followers does it have?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_movie_number DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users follow a movie list with the title 'Top 100 Movies'? ",
    "SQL": "SELECT COUNT(T2.user_id) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T1.list_title = 'Top 100 Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(DISTINCT list_id) AS unique_lists FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies based on user ratings?",
    "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": "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 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": "How many movies are in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "The number of users who have rated a movie and their rating score.",
    "SQL": "SELECT COUNT(user_id), rating_score FROM ratings GROUP BY rating_score",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the title 'Top 50 Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 50 Movies'",
    "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 a subscription to the platform?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE 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": "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 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": "List the titles and release years of the top 5 most popular movies",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 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": "How many lists are there for a specific user and what is the total number of followers for these lists?",
    "SQL": "SELECT COUNT(list_id), SUM(list_followers) FROM lists WHERE user_id = 1",
    "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": "List the titles of the top 5 movies with the highest ratings.",
    "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 followers does a list have?",
    "SQL": "SELECT list_followers FROM lists 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 most ratings and what is the average rating score for that movie?",
    "SQL": "SELECT T2.movie_title, AVG(T1.rating_score) AS average_rating FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_title ORDER BY COUNT(T1.rating_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released between 1990 and 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year BETWEEN 1990 AND 2000",
    "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 followers does the list with the most followers have?",
    "SQL": "SELECT list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "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": "How many lists were created by users who have a subscriber status?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by users who have at least one subscriber?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in 2015?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2015",
    "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": "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 most popular movies released in the year 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2000 ORDER BY movie_popularity DESC LIMIT 5",
    "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": "What is the average movie rating for movies released after 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": "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 unique movies have a rating higher than 4? ",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is its release year?",
    "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 are the names of the movies that have been rated by users who have 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 ratings_users AS T3 ON T1.user_id = T3.user_id WHERE T3.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating and its release year?",
    "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 users have made at least one list?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles and ratings of the movies with the highest rating scores.",
    "SQL": "SELECT movie_title, rating_score FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all the 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 critic score? When was it released and what is the critic's name?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year, T2.critic 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 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": "How many lists were created before the year 2000?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE STRFTIME('%Y', list_creation_timestamp_utc) < '2000'",
    "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 total number of unique directors in the movies table?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for 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": "How many users 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 and what is the average rating?",
    "SQL": "SELECT T1.movie_title, AVG(T2.rating_score) AS average_rating FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_title ORDER BY average_rating DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Get the number of followers for list id 5",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the most followers have?",
    "SQL": "SELECT list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies released in 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie released before 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year < 2000 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score among movies released in the year 2020?",
    "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 = 2020 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": "Find the titles of movies with a popularity score greater than 500, sorted by release year in descending order.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 500 ORDER BY movie_release_year DESC",
    "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 lists have more than 50 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies based on the number of ratings?",
    "SQL": "SELECT movie_title, COUNT(rating_id) as total_ratings FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY total_ratings DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that has the most 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": "Total number of followers of a list?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released in 2021?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2021",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with title 'Top 50 Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 50 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": "How many users have rated movies at least once?",
    "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 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 list title 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 and popularity scores of the movies with the highest ratings?",
    "SQL": "SELECT T1.movie_title, T1.movie_popularity 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": "How many lists are there for each user_id?",
    "SQL": "SELECT user_id, COUNT(list_id) AS num_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": "Retrieve the titles and ratings of all movies that have a rating score greater than 8.",
    "SQL": "SELECT T2.movie_title, T1.rating_score 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 have a follower count greater than 1000 and what is the average creation timestamp for these lists?",
    "SQL": "SELECT COUNT(list_id), AVG(strftime('%s', list_creation_timestamp_utc)) FROM lists WHERE list_followers > 1000",
    "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 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": "How many lists are created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS number_of_lists FROM lists_users GROUP BY user_id",
    "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": "List all movie titles and their release years where the release year is greater than 2000.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score? Provide the movie title and the rating score.",
    "SQL": "SELECT movie_title, rating_score FROM movies 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 a movie with a score of 5 out of 5?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the most highly rated movie?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year, T2.director_name 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 and what is the average popularity of these movies?",
    "SQL": "SELECT AVG(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 title and release year of the movie with the highest score in the ratings table?",
    "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": "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 of the movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following a list with a specific title?",
    "SQL": "SELECT COUNT(list_followers) FROM lists WHERE list_title = 'Example List Title'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are created by a user who is a subscriber and has a payment method?",
    "SQL": "SELECT COUNT(T1.list_id) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T2.user_subscriber = 1 AND T2.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movie directors are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for the movie with the title '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": "list the list_title of the list with the most 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 most rated movie?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 movies with the highest ratings?",
    "SQL": "SELECT T1.movie_title, T2.rating_score FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Get the top 5 lists with the most followers. Include the list title and the number of followers.",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers 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 are the titles of the movies that received a rating 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": "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": "What are the list titles of users who have a subscriber 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 T2.user_subscriber > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of all the movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the titles of the top 5 most rated 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": "What is the number of users who have given a rating to at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles and release years from the most popular movie rated 5 by users?",
    "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 ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2000?",
    "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 = 2000",
    "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? The rating score is based on the average of all ratings for each movie.",
    "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 AVG(T2.rating_score) DESC LIMIT 1",
    "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": "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 total number of lists a user has created.",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users follow each list and what is the list title?",
    "SQL": "SELECT T1.list_id, T1.list_title, COUNT(T2.user_id) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id GROUP BY T1.list_id, T1.list_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have a popularity score greater than 1000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 1000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most recent list? Who created it?",
    "SQL": "SELECT list_title, user_id FROM lists ORDER BY list_creation_timestamp_utc DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are subscribers in the 'lists_users' table?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest critic 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": "Name the directors of the movies that have been rated by users who are eligible for trial.",
    "SQL": "SELECT T2.director_name FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.user_eligible_for_trial = 1",
    "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_users GROUP BY user_id",
    "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 are there in the database?",
    "SQL": "SELECT COUNT(*) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are there in the lists_users table?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the list of movies that have a rating score greater than 3.0 and display their titles, release years, and directors.",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year, T2.director_name FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 3.0",
    "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": "How many followers does the list with the title 'Top 50 Movies of All Time' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 50 Movies of All Time'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the title 'Top 10 Best Movies of All Time' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 10 Best Movies of All Time'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 3 most followed lists and their titles?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 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": "How many lists have a follower count greater than 100?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated by users who have both a trialist and a subscriber status?",
    "SQL": "SELECT COUNT(DISTINCT T1.movie_id) FROM ratings AS T1 INNER JOIN ratings_users AS T2 ON T1.user_id = T2.user_id WHERE T1.user_trialist = 1 AND T2.user_subscriber = 1",
    "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 and release year of the movie with the highest average rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN (SELECT movie_id, AVG(rating_score) AS avg_rating FROM ratings GROUP BY movie_id) AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.avg_rating DESC LIMIT 1",
    "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": "Find the list title 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 most popular movie in 2022? ",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2022 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of all movies that have a popularity rating greater than 800?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_popularity > 800",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a subscriber status?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have and when was the last update?",
    "SQL": "SELECT user_id, COUNT(list_id) as list_count, MAX(list_update_timestamp_utc) as last_update FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that received the highest rating score from a critic?",
    "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 a creation timestamp later than '2020-01-01 00:00:00'? ",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc > '2020-01-01 00:00:00'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Retrieve the list of movies that have been rated by users and their ratings.",
    "SQL": "SELECT T2.movie_title, T1.rating_score FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies directed by 'Christopher Nolan' and released after the year 2010. Sort the list by the movie's release year in ascending order.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan' AND movie_release_year > 2010 ORDER BY movie_release_year ASC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies directed by Christopher Nolan?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie title and its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does a list have if it's created before 2020?",
    "SQL": "SELECT COUNT(list_followers) FROM lists WHERE list_creation_timestamp_utc LIKE '2020%'",
    "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 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 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 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 that has 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": "What is the total number of movies released in each year?",
    "SQL": "SELECT COUNT(movie_title), movie_release_year FROM movies GROUP BY movie_release_year",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating? What is the rating score and the movie title?",
    "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 movies released in each year? Order the results by the release year.",
    "SQL": "SELECT movie_release_year, COUNT(*) FROM movies GROUP BY movie_release_year ORDER BY movie_release_year",
    "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": "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": "How many users have a subscriber status? Provide the count of these users.",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE user_subscriber = 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 average rating score for the movie 'The Shawshank Redemption'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings 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 title of the movie with the highest rating score and who is the director of this movie?",
    "SQL": "SELECT T1.movie_title, T1.director_name 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 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 are the titles of the movies that received a rating score of 5? Who are the critics for these movies?",
    "SQL": "SELECT T2.movie_title, T1.critic 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 movies have a rating score greater than 5?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest average rating score?",
    "SQL": "SELECT movie_title FROM movies INNER 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": "How many users are following the list with the title 'Inception'? ",
    "SQL": "SELECT COUNT(user_id) FROM lists WHERE list_title = 'Inception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and the 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": "How many lists follow at least 1000 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers >= 1000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least 5 movies?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE user_id IN (SELECT user_id FROM ratings GROUP BY user_id HAVING COUNT(user_id) >= 5)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a subscriber status?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE user_subscriber = 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 the highest rating score?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title 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 movie rating score for a specific movie title, for example, '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": "What are the titles of the movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies were rated by critics and what was the average rating score for each movie?",
    "SQL": "SELECT movie_title, AVG(rating_score) as average_rating FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title",
    "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 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": "How many users have a list creation date before 2020?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE list_creation_date_utc < '2020-01-01'",
    "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 a subscriber status?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been 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 list title with the most followers? How many followers does it have?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "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": "Which movies were released between 2000 and 2010 and have a rating score greater than 4? Sort the results by the average rating score in descending order.",
    "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 BETWEEN 2000 AND 2010 AND T2.rating_score > 4 GROUP BY T1.movie_title ORDER BY AVG(T2.rating_score) DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies has the highest rating score? List the movie title and the rating score.",
    "SQL": "SELECT T1.movie_title, T2.rating_score 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 100 followers?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 100",
    "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 followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by a user with user_id 1?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score 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 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": "Retrieve the movie title and its release year for the movie that has received the highest average 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 GROUP BY T1.movie_id ORDER BY AVG(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 of all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "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": "What are the titles of the movies rated 5 out of 5 by critics?",
    "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": "What is the title of the movie with the highest rating score and who directed it?",
    "SQL": "SELECT T1.movie_title, T1.director_name 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 INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies directed by Christopher Nolan?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in the month of January 2021?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE STRFTIME('%Y-%m', list_creation_timestamp_utc) = '2021-01'",
    "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 total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) AS total_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most followed list on the platform?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and URLs of movies with a rating score greater than 4?",
    "SQL": "SELECT T1.movie_title, T1.movie_url 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 movie has the highest number of followers in the lists?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_movie_number = T2.movie_id ORDER BY T1.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the titles of all movies released after the year 2000. Order the results by the release year in ascending order.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000 ORDER BY movie_release_year ASC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does the user with user_id 123 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 123",
    "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": "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": "How many movies have been rated by users?",
    "SQL": "SELECT COUNT(movie_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": "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 a trial list? How many users have a subscriber list?",
    "SQL": "SELECT COUNT(user_trialist), COUNT(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many different genres of movies are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT movie_title) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "list the most commented lists with their number of comments",
    "SQL": "SELECT list_comments, list_title FROM lists ORDER BY list_comments 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 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 and release year of the movie with the highest rating score?",
    "SQL": "SELECT movie_title, movie_release_year 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 user has the most followers on their lists?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY SUM(list_followers) 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": "Which movie director has directed the most movies?",
    "SQL": "SELECT director_name FROM movies GROUP BY director_name ORDER BY COUNT(movie_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been rated by critics with a 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 total number of users who have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "list the top 5 movie titles with the highest movie popularity",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "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 WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_release_year > 2000)",
    "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": "How many users are currently subscribed to lists?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all lists with more than 100 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 100",
    "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 movie has the highest rating score and what is the title of the movie?",
    "SQL": "SELECT T1.movie_title, T2.rating_score 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 currently subscribed to the trialist program?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_trialist = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most popular movies by release year?",
    "SQL": "SELECT movie_title, movie_release_year, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "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 4?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are associated with each user?",
    "SQL": "SELECT user_id, COUNT(list_id) as list_count FROM lists_users GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the highest number of followers? How many followers do they have?",
    "SQL": "SELECT user_id, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 1000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_popularity > 1000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies that have a release year greater than 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 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 are listed in each category?",
    "SQL": "SELECT COUNT(*) AS num_movies, T1.list_title FROM lists AS T1 INNER JOIN movies AS T2 ON T2.movie_id IN (SELECT movie_id FROM ratings) GROUP BY T1.list_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has rated the movie 'The Shawshank Redemption' and how many times?",
    "SQL": "SELECT T2.user_id, COUNT(*) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T1.movie_title = 'The Shawshank Redemption'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating and what is the 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 average rating score for the movie with the title '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 are the titles of the movies that have been rated by more than 10 users?",
    "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_id HAVING COUNT(T2.user_id) > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followers more than 100?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "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 are the titles of movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by the user with ID 12345?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 12345",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings for each movie title?",
    "SQL": "SELECT T2.movie_title, COUNT(T1.rating_id) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.movie_title",
    "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": "How many movies have a rating score greater than 4 and were released in the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score > 4 AND T1.movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the five most popular movies? Provide their release years and directors.",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers on their list?",
    "SQL": "SELECT user_id FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies have been rated and what is the average rating score?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) AS unique_movies, AVG(rating_score) AS average_rating FROM ratings",
    "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": "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 followers for all lists?",
    "SQL": "SELECT SUM(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 INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie with the title 'The Shawshank Redemption'?",
    "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 = 'The Shawshank Redemption'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score 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 average rating score for 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 movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the movie title with the highest rating score and list its release year.",
    "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 average rating score 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": "How many followers does the list with title 'Top 10 Marvel Movies' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 10 Marvel Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Provide the titles of the three movies with the highest ratings from 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 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is its title?",
    "SQL": "SELECT T1.movie_title, T2.rating_score 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": "What are the top 5 most popular movies and their directors?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the total number of movies in the database",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "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 average rating score for a movie and how many users have given that rating for the movie with ID 101?",
    "SQL": "SELECT AVG(rating_score), COUNT(user_id) FROM ratings WHERE movie_id = 101",
    "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 directed by Christopher Nolan?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated by more than 100 users?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE user_id > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is its title?",
    "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 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 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 average rating score for all movies?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have made ratings on movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of the movie 'The Shawshank Redemption'?",
    "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 = 'The Shawshank Redemption'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by more than 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does a list have that was created in the year 2021?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_creation_timestamp_utc LIKE '2021%'",
    "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 lists created by users in the last month?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc >= DATETIME('now','-1 month')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie in the database? How many ratings does it have and who directed it?",
    "SQL": "SELECT T1.movie_title, T2.rating_score, T1.director_name 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": "What are the titles of the top 10 most popular movies and their directors?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 10",
    "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 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 and what is the average rating score for each movie?",
    "SQL": "SELECT movies.movie_title, COUNT(ratings.rating_id) AS num_ratings, AVG(ratings.rating_score) AS avg_rating_score FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movies.movie_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie directed by Christopher Nolan?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christopher Nolan' 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": "Which movie has the highest rating score and its director's name?",
    "SQL": "SELECT T1.movie_title, T1.director_name, T2.rating_score 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 are created by each user and the total number of lists created by all users?",
    "SQL": "SELECT COUNT(list_id) , user_id , COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies released between 2000 and 2010, sorted by their release year?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year BETWEEN 2000 AND 2010 ORDER BY movie_release_year",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that received 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 movies are there in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for the movie 'The Matrix'?",
    "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 = 'The Matrix'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles with the highest ratings?",
    "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": "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": "What is the title of the most recent list created by a user?",
    "SQL": "SELECT list_title FROM lists_users INNER JOIN lists ON lists_users.list_id = lists.list_id ORDER BY list_creation_timestamp_utc 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 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": "List all the movies released before 2000.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies released in the year 2020?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2020 ORDER BY movie_popularity DESC LIMIT 5",
    "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": "How many movies were rated by users who have both subscribed and are eligible for trials?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings INNER JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE lists_users.user_subscriber = 1 AND lists_users.user_eligible_for_trial = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the average rating score for movies with a release year after 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 users have rated more than 5 movies?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE movie_id > 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": "How many movies have been rated higher than 4 stars?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in the year 2021?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE STRFTIME('%Y', list_creation_timestamp_utc) = '2021'",
    "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": "What is the average rating score for movies released after the year 2010?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the list title 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 users are associated with the list with the highest number of followers?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists_users WHERE list_id IN (SELECT list_id 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 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": "What is the average movie rating score for movies released before 2000?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following the movie with the highest rating score?",
    "SQL": "SELECT COUNT(T2.user_id) FROM ratings AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T1.rating_score = ( SELECT MAX(rating_score) FROM ratings )",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a trial subscription and have made at least one rating?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_trialist = 1",
    "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 average rating of movies released in 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 critic score of at least 7 and have received positive comments? List their titles, critic scores, and critic comments.",
    "SQL": "SELECT T1.movie_title, T2.rating_score, T2.critic_comments FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score >= 7 AND T2.critic_comments > 0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of all movies that have a rating score greater than 4.0.",
    "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.0",
    "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 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": "Find the average rating score for movies directed by Christopher Nolan.",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the 5 most popular movies and their release years.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in 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": "What are the names and release years of the top 5 most popular movies?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list that 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 movies were released in the year 2000 and have a rating score greater than 4?",
    "SQL": "SELECT COUNT(*) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2000 AND ratings.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are directed by Christopher Nolan?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE director_name = 'Christopher Nolan'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a payment method and are not trialists?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_has_payment_method = 1 AND user_trialist = 0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most followed lists with the most recent update timestamp?",
    "SQL": "SELECT list_title, list_followers, list_update_timestamp_utc FROM lists ORDER BY list_followers DESC, list_update_timestamp_utc DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies that have a popularity score higher than 5000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 5000",
    "db_id": "movie_platform",
    "evidence": ""
  }
]