[
  {
    "question": "What is the average rating score for movies directed by Ilias Sounas?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS R JOIN movies AS M ON R.movie_id = M.movie_id WHERE M.director_name = 'Ilias Sounas'",
    "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": "Who is the director of the movie titled 'The Outcasts'? When was it released?",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies WHERE movie_title = 'The Outcasts'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists has the user with user_id 7119252 created?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 7119252",
    "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 1920?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 1920",
    "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 released after 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'To discover' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'To discover'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the '2004: The Year in Film' list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '2004: The Year in Film'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT 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 'Val Guest'?",
    "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 = 'Val Guest'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 1975?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 1975",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movie titles are there in the database?",
    "SQL": "SELECT COUNT(DISTINCT movie_title) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for the user with user_id 10155977?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE user_id = 10155977",
    "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": "How many unique movies have been rated by users who have a payment method? What is the average rating score for these movies?",
    "SQL": "SELECT COUNT(DISTINCT T1.movie_id), AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN ratings_users AS T2 ON T1.user_id = T2.user_id WHERE T2.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a release year between 1970 and 1980 and a popularity greater than 500?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year BETWEEN 1970 AND 1980 AND movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the title of the list with the highest number of followers.",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many different movies are in the ratings table and what is the average rating score for these movies?",
    "SQL": "SELECT COUNT(DISTINCT movie_id) AS num_movies, AVG(rating_score) AS avg_rating_score FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list '2014 View Log' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '2014 View Log'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score? How many people rated it?",
    "SQL": "SELECT T1.movie_title, COUNT(T2.rating_id) FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers for lists that were created before 2012?",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_creation_timestamp_utc < '2012-01-01'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and the release year of the oldest movie in the list?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "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": "Which movie has the most followers on lists?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN lists AS T2 ON T1.movie_id = T2.list_id GROUP BY T2.list_id ORDER BY COUNT(*) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the list creation timestamp of the list with id 150058?",
    "SQL": "SELECT list_creation_timestamp_utc FROM lists WHERE list_id = 150058",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for movies released before 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 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 of the most followed list?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the total number of followers for all lists combined?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by user_id 66776915?",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE user_id = 66776915",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by users who have a subscriber status?",
    "SQL": "SELECT COUNT(DISTINCT list_id) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and the number of movies in the list with the most followers?",
    "SQL": "SELECT list_title, list_movie_number 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 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": "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 were created by the user with id 29694204?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 29694204",
    "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 the movie 'The Goose'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Goose')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the movie that was released in 2013 and 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 WHERE T1.movie_release_year = 2013 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 most followed list and 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": "How many lists are associated with each user? List the user_id and the count of associated lists.",
    "SQL": "SELECT user_id, COUNT(list_id) AS list_count FROM lists GROUP BY user_id",
    "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": "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 list followers does the 'Comedies' list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Comedies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "name of the most popular movie",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 50?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_popularity > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'ver' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'ver'",
    "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 number of followers on lists updated in 2017?",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_update_timestamp_utc LIKE '2017%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the list titles that have more than 10 followers. Sort the lists by the descending number of followers.",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10 ORDER BY list_followers DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists that a specific user has created?",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE user_id = 47147944",
    "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": "What is the list title of the first list with more than 5 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5 ORDER BY list_id ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'filmer vi vil se' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'filmer vi vil se'",
    "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": "How many followers does the list with the title 'FEATS IN ACTRESSING, 1949' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'FEATS IN ACTRESSING, 1949'",
    "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": "Specify the list title and total count of movies in the list with ID 187630.",
    "SQL": "SELECT list_title , list_movie_number FROM lists WHERE list_id = 187630",
    "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 total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers on the 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 are the titles of the top 5 movies with the highest rating scores?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the 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": "How many lists are there with more than 5 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 5",
    "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": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists follow the user ID '89496126'?",
    "SQL": "SELECT COUNT(list_followers) FROM lists WHERE user_id = '89496126'",
    "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": "How many lists were created in the year 2014?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE STRFTIME('%Y', list_creation_timestamp_utc) = '2014'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director 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": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score? What is its title and 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 were released in 1981?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 1981",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists in the database?",
    "SQL": "SELECT SUM(list_followers) AS total_followers FROM lists",
    "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 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 movies were released in the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of movies released after the year 2000?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers and what is its title?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title for list_id 2246?",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 2246",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are rated higher than 4 out of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director 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": "How many followers does the list titled 'Charlize Theron' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Charlize Theron'",
    "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 title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie released in 2019?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2019 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie was directed by Seyed Reza Razavi and released in the year 2012?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Seyed Reza Razavi' AND movie_release_year = 2012",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created on or after January 1, 2015?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc >= '2015-01-01'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie directed by Philippe Grandrieux? When was it released?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Philippe Grandrieux'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies directed by 'Iris Junges'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Iris Junges'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most followed list's title and the number of followers it has?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Desert Dreams' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Desert Dreams'",
    "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 and release year of the movie with the highest popularity score?",
    "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 user 70679288?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 70679288",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were rated higher than 4 by users who have both a trial list and a subscriber status?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score > 4 AND user_trialist = 0 AND user_subscriber = 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 JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 10 most popular movies released after the year 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000 ORDER BY movie_popularity DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "what is the title of the movie and the date it was released?",
    "SQL": "SELECT movie_title , movie_release_year FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the movie with 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": "What is the total number of lists created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS total_lists FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for user with id 35343706?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE user_id = 35343706",
    "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 followers does the list 'the gays & the cinema' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'the gays & the cinema'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers? What is its title?",
    "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 the list titled 'films to watch'? ",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title = 'films to watch'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are directed by Steve Barron?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE director_name = 'Steve Barron'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers do users have in the list titled 'watched in 2016'?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title = 'watched in 2016'",
    "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 release year of the movie with the highest rating?",
    "SQL": "SELECT 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 followers do the lists have?",
    "SQL": "SELECT sum(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with title 'November 09' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'November 09'",
    "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 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": "List all movie titles from the 'movies' table that have a rating score of at least 4 in the 'ratings' table.",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.rating_score >= 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for the user with ID 59661581?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE user_id = 59661581",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 5 most popular movies and what is 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": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of the movies that were rated after 2018?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE rating_timestamp_utc > '2018-01-01 00:00:00'",
    "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 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": "How many lists have more than 10 followers? What is the total number of movies in these lists?",
    "SQL": "SELECT COUNT(list_id), SUM(list_movie_number) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title and its 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 is the title and release year of the first movie 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_timestamp_utc ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most followers on the list?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_id = T2.movie_id ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the number of users who have created more than 10 lists.",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id IN ( SELECT user_id FROM lists GROUP BY user_id HAVING COUNT(list_id) > 10 )",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of ratings given by users for the movie 'Kong: King of Atlantis'?",
    "SQL": "SELECT SUM(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Kong: King of Atlantis')",
    "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 are the titles and descriptions of the top 3 lists with the most followers?",
    "SQL": "SELECT list_title, list_description FROM lists ORDER BY list_followers DESC LIMIT 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the 'lists' table?",
    "SQL": "SELECT COUNT(list_movie_number) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most recently released movie?",
    "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 title of the movie with the highest popularity score?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and popularity of the most viewed movie?",
    "SQL": "SELECT movie_title, movie_popularity 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 INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2019",
    "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": "State the title of the movie with the highest rating score. What is the rating score for 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 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 are the titles and release years of the top 3 movies with the highest rating scores?",
    "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 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users follow the list with the title 'Top 100 as of August 2010'?",
    "SQL": "SELECT COUNT(T2.user_id) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T1.list_title = 'Top 100 as of August 2010'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest popularity score?",
    "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 movie that received the highest rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title 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 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 is the name 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": "How many lists have more than 5 followers?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users are following the 'Iranian Movies' list?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title = 'Iranian Movies'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for the movie titled 'Disco'?",
    "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 = 'Disco'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by users? What is the title of the list with the most followers?",
    "SQL": "SELECT COUNT(list_followers), list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the 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 title of the movie with the highest rating score? What is its 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 title and creation timestamp of the oldest list?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists ORDER BY list_creation_timestamp_utc ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the lowest 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 ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers and what is its title?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to the system?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that was released in 1953?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1953",
    "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": "Which list has the most followers and what is its title?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is the critic's comment for that movie?",
    "SQL": "SELECT T1.movie_title, T2.critic_comments 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 was released in the year 2012 and what is its title?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2012",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'BREAKER MORANT' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'BREAKER MORANT'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the 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 in the last 30 days?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc >= DATETIME('now','-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Cuba' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Cuba'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by user with user_id = 9031629?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 9031629",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score and 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": "Which movies were released between the years 1970 and 1980 and what is their popularity?",
    "SQL": "SELECT movie_title, movie_popularity FROM movies WHERE movie_release_year BETWEEN 1970 AND 1980",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the title 'Favorite 2004' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Favorite 2004'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is the critic's comment for that movie?",
    "SQL": "SELECT T1.movie_title, T2.critic_comments FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and URL of the first movie listed?",
    "SQL": "SELECT movie_title, movie_url FROM movies LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers on lists?",
    "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 movies released in the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2000",
    "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 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": "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": "How many lists does user 34937870 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 34937870",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that 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": "State the movie title and the number of followers for a list with the most followers. Also, show the creation timestamp of the list.",
    "SQL": "SELECT T1.list_title, T1.list_followers, T1.list_creation_timestamp_utc FROM lists AS T1 ORDER BY T1.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the database?",
    "SQL": "SELECT COUNT(*) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "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 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 lists does user 18285316 have and what is the total number of followers they have across all their lists?",
    "SQL": "SELECT COUNT(list_id), SUM(list_followers) FROM lists WHERE user_id = 18285316",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the 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 title of the list with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of movies directed by Jack Fessenden?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Jack Fessenden'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for lists with more than 100 followers?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most followers in the 'Favorite 1956' list?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T2.movie_id = (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id = T1.list_id) ORDER BY rating_score DESC LIMIT 1) WHERE T1.list_title = 'Favorite 1956'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a popularity score greater than 500?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity > 500",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been rated by users who have paid for their subscriptions?",
    "SQL": "SELECT COUNT(*) FROM ratings AS T1 INNER JOIN ratings_users AS T2 ON T1.user_id = T2.user_id WHERE T2.user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average follower count of all lists?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "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 top 5 most popular movies released in 2010?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2010 ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for the movie 'Red Rocket'?",
    "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 = 'Red Rocket'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with title 'Sound Art: great Film Foley' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Sound Art: great Film Foley'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2000 and have a rating score of 5?",
    "SQL": "SELECT COUNT(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 = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Ranking Stanley Kubrick' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Ranking Stanley Kubrick'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the release year of the movie with the highest movie ID?",
    "SQL": "SELECT movie_release_year FROM movies ORDER BY movie_id DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest popularity rating?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the total number of lists and the average number of followers per list",
    "SQL": "SELECT COUNT(list_id), AVG(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score of movies released in 2015?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2015",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie that received 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 and what is the director's name?",
    "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": "How many users have subscribed to the website?",
    "SQL": "SELECT COUNT(user_subscriber) AS subscriber_count 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 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": "Total number of followers for lists created on 2014-01-05?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_creation_timestamp_utc LIKE '2014-01-05%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies released after 2000 and what is their director's name?",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that 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 followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list '\u0130ZLED\u0130KLER\u0130M' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '\u0130ZLED\u0130KLER\u0130M'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is its 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 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie from the year 2009?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2009 ORDER BY movie_popularity 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": "What is the title of the movie with the highest popularity score?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the 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? What is the director's name for 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": "Who has the most followers among users and their corresponding lists updates timestamp in UTC?",
    "SQL": "SELECT T2.user_id, T1.list_update_timestamp_utc FROM lists AS T1 INNER JOIN lists_users AS T2 ON T2.list_id = T1.list_id GROUP BY T2.user_id ORDER BY SUM(T1.list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of lists created before 2019? How many followers do these lists have?",
    "SQL": "SELECT list_title, list_followers FROM lists WHERE list_creation_timestamp_utc < '2019-01-01'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of movies directed by Martin Fri\u010d?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Martin Fri\u010d'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list with the most followers and what is its title?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "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": "List all the titles of movies directed by Ahmed Nader Galal",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Ahmed Nader Galal'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list 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": "List the titles of movies that were released in the year 2000 and have a popularity score greater than 5. Sort the results by the movie title in ascending order.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2000 AND movie_popularity > 5 ORDER BY movie_title ASC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers on their lists?",
    "SQL": "SELECT user_id, SUM(list_followers) AS total_followers FROM lists GROUP BY user_id ORDER BY total_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles and release years of movies directed by Austen Rachlis.",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Austen Rachlis'",
    "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 director of the movie with the ID 235011?",
    "SQL": "SELECT director_name FROM movies WHERE movie_id = 235011",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most recent movie added to 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 title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were 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 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": "What is the total number of movies in the 'movies' table?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with title 'films watched (2011)' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'films watched (2011)'",
    "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": "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 are the most popular movies? List their titles, release years, and directors.",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "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 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 was released in 1988 and 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 WHERE T1.movie_release_year = 1988 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 title of the movie with the highest rating score? And, how many users have given this rating?",
    "SQL": "SELECT T1.movie_title, COUNT(T1.movie_id) AS num_users 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 for a movie 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": "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 of the movie that was released in 2001?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2001",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the first movie?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_id ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies directed by 'Osamu Tezuka'?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Osamu Tezuka'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for the list with the title 'TOP 10 2016'?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'TOP 10 2016'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'The Personals'?",
    "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 = 'The Personals'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies with a rating score greater than 4?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 4)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of the movies made by Marc-Gilbert Guillaumin?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Marc-Gilbert Guillaumin'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie directed by James Whale?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'James Whale'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie was released in the year 2018?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2018",
    "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 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": "What is the total number of ratings received for each movie? Order the results by the number of ratings in descending order.",
    "SQL": "SELECT COUNT(rating_id) AS total_ratings, movie_id FROM ratings GROUP BY movie_id ORDER BY total_ratings DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there that have more than 10 followers and were created before the year 2015?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10 AND SUBSTR(list_creation_timestamp_utc, 1, 4) < '2015'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie that has 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 users have followed the 'watched in 2013' list?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'watched in 2013'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title 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": "What is the average movie rating score for movies directed by Susan Marks?",
    "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 = 'Susan Marks'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most recent list update time for each user?",
    "SQL": "SELECT user_id, MAX(list_update_timestamp_utc) FROM lists GROUP BY user_id",
    "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 title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with list_id 13365 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 13365",
    "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": "How many users have subscribed?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users",
    "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 most popular movie and its director?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is its title?",
    "SQL": "SELECT movie_title 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 movies released in 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 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": "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 top-rated movies in 2020?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE SUBSTR(rating_timestamp_utc, 1, 4) = '2020' ORDER BY rating_score DESC LIMIT 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score?",
    "SQL": "SELECT movie_title 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 most followed list title? 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 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": "How many followers does the list 'Punk' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Punk'",
    "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": "How many lists have more than 5 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most followers?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN lists AS T2 ON T1.movie_id = T2.list_id GROUP BY T1.movie_title ORDER BY SUM(T2.list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the user with the most followers?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY sum(list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "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 followers does the '2014 View Log' list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '2014 View Log'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the oldest movie in the database? When was it released and who is the director?",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that was released in 1980?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1980",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists are followed by the most users?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title and the update timestamp for the list with the most followers?",
    "SQL": "SELECT list_title, list_update_timestamp_utc FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that received the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title 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": "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": "Name the movie titles that have a rating score greater than 3. Show only the titles, not the ratings.",
    "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 > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the number of lists with the title 'Tony Scott - Ranked'?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_title = 'Tony Scott - Ranked'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find the number of movies directed by Mihail Meltev.",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE director_name = 'Mihail Meltev'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'REVOLUTIONARY EDITI/N/G' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'REVOLUTIONARY EDITI/N/G'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score of 0?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_popularity = 0",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie was released first?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are followed by at least 100 users in the 'lists' table?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers >= 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score and 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 title of the movie that was released the earliest?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the user who created the list 'Asian'?",
    "SQL": "SELECT T1.user_id FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.user_id = T2.user_id WHERE T1.list_title = 'Asia'",
    "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 lists have more than 100 followers?",
    "SQL": "SELECT list_id FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most lists and what is the number of lists they have?",
    "SQL": "SELECT user_id, COUNT(list_id) FROM lists GROUP BY user_id ORDER BY COUNT(list_id) 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 movie_title, movie_release_year FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie and who is the director of that movie?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been updated in the last month?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_update_timestamp_utc >= DATETIME('now','-1 month')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated at least one movie and how many have not?",
    "SQL": "SELECT SUM(CASE WHEN user_id IS NOT NULL THEN 1 ELSE 0 END) AS rated_users, COUNT(user_id) AS total_users FROM ratings_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 10 followers and what is the average movie number in these lists?",
    "SQL": "SELECT COUNT(list_id), AVG(list_movie_number) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find 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 user has the most followers and what is their list update timestamp?",
    "SQL": "SELECT T1.user_id, T2.list_update_timestamp_utc FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.user_id = T2.user_id ORDER BY T2.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for movies directed by Fran\u00e7ois Ozon?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Fran\u00e7ois Ozon'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is 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 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 users follow the list 'my best ten'",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'my best ten'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the most popular movie in the database?",
    "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 is the name of the movie with the most followers?",
    "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(*) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists has the user with user_id '896127' created?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 896127",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating 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 user with user_id 48318779 have?",
    "SQL": "SELECT list_followers FROM lists WHERE user_id = 48318779",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score? ",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the director's name for the most popular movie? When was it released and what is the movie title?",
    "SQL": "SELECT director_name, movie_release_year, movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score 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 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 the users of the database?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most viewed 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 'Movies Watched in 2014' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Movies Watched in 2014'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique lists are there for each user?",
    "SQL": "SELECT COUNT(DISTINCT list_id) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating for the movie 'Soul'?",
    "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 = 'Soul'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Who is the most popular director? What is the average rating of their movies?",
    "SQL": "SELECT T2.director_name, AVG(T1.rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id GROUP BY T2.director_name ORDER BY COUNT(T2.movie_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in 2014?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc LIKE '2014%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists were created before the year 2010?",
    "SQL": "SELECT list_title FROM lists WHERE list_creation_timestamp_utc < '2010-01-01'",
    "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": "Give the titles of lists followed by 5 or more followers.",
    "SQL": "SELECT list_title FROM lists WHERE list_followers >= 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by user with ID 72437907?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 72437907",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of users who have created lists?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of 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 number of followers for lists with titles containing the word 'favorite'?",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_title LIKE '%favorite%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there that were created after 2010?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc > '2010-01-01'",
    "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": "Which user has the most number of lists they follow?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY COUNT(list_id) DESC LIMIT 1",
    "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 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": "Name all the directors of movies that have a rating score of 5. Sort the directors by the number of movies they have directed.",
    "SQL": "SELECT T2.director_name FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score = 5 GROUP BY T2.director_name ORDER BY COUNT(T2.movie_id) DESC",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for the movie 'The Ax'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_title = 'The Ax'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by user with ID 41857953?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 41857953",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have been directed by William A. Levey?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE director_name = 'William A. Levey'",
    "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 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": "How many lists were created by the user with user_id 17982294?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 17982294",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there in the database?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Who directed the movie 'Murder on the Campus'?",
    "SQL": "SELECT director_name FROM movies WHERE movie_title = 'Murder on the Campus'",
    "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 and release year of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated movies?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the release year of the movie with the highest rating score?",
    "SQL": "SELECT 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 movies were released in 2012?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2012",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the title of the movie with the highest rating score. 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 of the movie with the highest rating score? How many likes does it have?",
    "SQL": "SELECT T2.movie_title, T1.critic_likes 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(*) 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 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 movies are rated higher than 3 by users?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers for lists?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "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 lists have been created by user with ID 9268311?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 9268311",
    "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 followers does the list 'watched and didnt loved' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'watched and didnt loved'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the movie titles with the highest rating score. Also, mention the rating score and 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": "Write a SQLite query to find the titles of all lists created by a user with the user_id of 62902863.",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 62902863",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is the rating timestamp?",
    "SQL": "SELECT movie_title, rating_timestamp_utc 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 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 a user has created?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 93081538",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating of a movie?",
    "SQL": "SELECT AVG(rating_score) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released after the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 2017?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2017",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists do users have that were created after January 1, 2020?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE list_creation_date_utc > '2020-01-01'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest popularity?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers and what is its title?",
    "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 popularity score?",
    "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 'New Russian Cinema' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'New Russian Cinema'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the 'Films That Made Me Cry' list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Films That Made Me Cry'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for a given user_id?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 17777151",
    "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": "Which lists have the most followers and their corresponding titles?",
    "SQL": "SELECT list_title, list_followers 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": "How many followers does the list 'LIGHTHOUSES' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'LIGHTHOUSES'",
    "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 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? What is the score and timestamp of the rating?",
    "SQL": "SELECT T2.movie_title, T1.rating_score, T1.rating_timestamp_utc 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 'bP' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'bP'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating among users?",
    "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 movie has the highest rating score and who is the critic who gave the highest score?",
    "SQL": "SELECT T2.movie_title, T1.critic 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 name of the longest movie title? When was it released?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY LENGTH(movie_title) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score in the ratings table?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie of all time 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 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 movie popularity for movies released in the year 2000?",
    "SQL": "SELECT AVG(movie_popularity) FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of all movies directed by D\u00e1ire McNab?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'D\u00e1ire McNab'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie directed by Chuck Jones?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Chuck Jones' ORDER BY movie_popularity 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": "State the number of followers for the list with the title 'approved by anton lavey'",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'approved by anton lavey'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title and 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": "What is the director's name for the movie 'Home Sweet Home'?",
    "SQL": "SELECT director_name FROM movies WHERE movie_title = 'Home Sweet Home'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has 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": "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 most popular movie in the database and who is the director?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by user 35343706?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 35343706",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Touching' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Touching'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most commented list? How many comments does it have?",
    "SQL": "SELECT list_title, list_comments FROM lists ORDER BY list_comments DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'branded content short films' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'branded content short films'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the most followers?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_followers = T2.movie_id ORDER BY T1.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the 'Cannes 66' list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Cannes 66'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'ver' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'ver'",
    "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 that has the highest rating score? 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": "Which list has the highest number of followers and what is its title?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list 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 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 in the database?",
    "SQL": "SELECT SUM(list_followers) AS total_followers FROM lists",
    "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 JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 3 most popular movies?",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have more than 100 followers?",
    "SQL": "SELECT COUNT(user_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2008?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2008",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles and release years of movies directed by Leif Sinding?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Leif Sinding'",
    "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": "How many lists are followed by users?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie? What is its director's name and the release year?",
    "SQL": "SELECT T2.movie_title, T2.director_name, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all movie titles that have a rating score of 5. How many such movies are there?",
    "SQL": "SELECT COUNT(*) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE ratings.rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have followed the list titled 'horror & mystery'?",
    "SQL": "SELECT COUNT(T2.user_id) FROM lists AS T1 INNER JOIN lists_users AS T2 ON T1.list_id = T2.list_id WHERE T1.list_title = 'horror & mystery'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the most followers?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_id = T2.movie_id ORDER BY T1.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State 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": "Retrieve the list title and the number of followers for the list with list_id 174662.",
    "SQL": "SELECT list_title, list_followers FROM lists WHERE list_id = 174662",
    "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 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 of the most recent movie released?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_release_year DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movies in the database, and their corresponding director's name",
    "SQL": "SELECT movie_title, director_name FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user ID has the most followers in the 'lists' table?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by user with ID 17378439?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 17378439",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'Short Films' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Short Films'",
    "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": "Name the titles of the movies directed by Noud Heerkens.",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Noud Heerkens'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does the user with user_id `45157319` have?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 45157319",
    "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 received the highest rating?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie that received 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 cover images of the top 5 lists with the most followers?",
    "SQL": "SELECT list_title, list_cover_image_url FROM lists ORDER BY list_followers DESC LIMIT 5",
    "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 most popular movie in the list?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "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": "How many lists were created by the user with ID 96333851?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 96333851",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released before the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Faerie Tale Theatre' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Faerie Tale Theatre'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of the top 5 most popular movies released in the year 2016.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2016 ORDER BY movie_popularity DESC LIMIT 5",
    "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 have a popularity score greater than 5 and were released in the year 2000?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_popularity > 5 AND movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the movie with the highest rating score? What is the critic's opinion about the movie?",
    "SQL": "SELECT T1.movie_title, 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": "List all the list titles that have more than 5 movies in them.",
    "SQL": "SELECT list_title FROM lists GROUP BY list_title HAVING list_movie_number > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the top 3 movie titles and their release years sorted by movie popularity in descending order.",
    "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 title and creation timestamp of the list with the most 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 movie has 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 lists were created in the year 2013?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE SUBSTR(list_creation_timestamp_utc, 1, 4) = '2013'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the user who has the most followers?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY SUM(list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles and release years of movies with 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 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": "Find the movie title and its release year for the movie with the highest rating score.",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the movie with the highest rating?",
    "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": "How many lists have a follower count greater than 5?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 5",
    "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": "List the titles and creation timestamps of lists that were created more than a year ago.",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists WHERE list_creation_timestamp_utc <= DATE('now','-1 year')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Who directed the movie 'Le mani sulle macerie'? When was it released?",
    "SQL": "SELECT director_name, movie_release_year FROM movies WHERE movie_title = 'Le mani sulle macerie'",
    "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 creation timestamp of the oldest list created?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists ORDER BY list_creation_timestamp_utc ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for all movies in the ratings table?",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie with its release year and 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": "How many unique user IDs are associated with lists?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by user with id 49133924?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 49133924",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the top 3 most popular movies and what are 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": "How many followers does the list titled 'top 10 of 2018' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'top 10 of 2018'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have rated a movie at least once?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'AKIRA' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'AKIRA'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a subscription and are eligible for trial?",
    "SQL": "SELECT COUNT(user_id) FROM ratings_users WHERE user_subscriber = 1 AND user_eligible_for_trial = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie directed by Reza Rahadian?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Reza Rahadian' ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is the 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 ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most followers?",
    "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 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 of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title 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 unique directors have directed movies in the database?",
    "SQL": "SELECT COUNT(DISTINCT director_name) FROM movies",
    "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": "What is the total number of followers for all lists?",
    "SQL": "SELECT sum(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title 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 title and release year of the movie with the highest popularity score?",
    "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 movies directed by Cynthia Madansky and the release years of those movies?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Cynthia Madansky'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie released in 2018?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2018",
    "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 rated by users who have a payment method?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_has_payment_method = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'obejrzane' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'obejrzane'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Who directed the movie 'Tomboys'? When was the movie released?",
    "SQL": "SELECT director_name, movie_release_year FROM movies WHERE movie_title = 'Tomboys'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 1973?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 1973",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'to watch 2018' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'to watch 2018'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique users have rated at least one movie?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers and what is the title of that list?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'sensualidad ou o erotismo' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'sensualidad ou o erotismo'",
    "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": "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 were released in the year 2001?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2001",
    "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 GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by the user with user_id 92753795?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 92753795",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for a specific user with user_id 63471105?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 63471105",
    "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": "State the title of the movie that was released in the year 2012.",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2012 LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the movie that was released in 1948 and its director name?",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 1948",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that was released in the year 2019?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2019",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find 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": "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 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": "What is the title and URL of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_url FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by the user with user_id 17224746?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 17224746",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title of the highest rated movie?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Christian-Jaque?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Christian-Jaque'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Get the list title 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 followers does the list with id 130001 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 130001",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for the movie list 'October 2012'?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_title='October 2012'",
    "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 most followed list? Who created it and when was it created?",
    "SQL": "SELECT list_title, user_id, list_creation_timestamp_utc FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2011?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2011",
    "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 of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the 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 of the movie with the most followers?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_movie_number = T2.movie_id WHERE T1.list_followers = ( SELECT MAX(list_followers) FROM lists ) LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists?",
    "SQL": "SELECT COUNT(list_id) FROM lists",
    "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": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title 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 were released in the year 2004?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 2004",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the list titles with at least 10 followers.",
    "SQL": "SELECT list_title FROM lists WHERE list_followers >= 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that were released after the year 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT 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 list 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?",
    "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 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 there with a popularity score greater than 5?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_popularity > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Who are the directors of the movies with the highest ratings?",
    "SQL": "SELECT 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": "How many lists are there for each user?",
    "SQL": "SELECT 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? How many people rated it and what is the rating score?",
    "SQL": "SELECT T1.movie_title, T2.user_subscriber, 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 followers does the list 'Favorite New Films' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Favorite New Films'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie directed by Michael Winner?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Michael Winner'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in the year 2014?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc LIKE '2014%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have more than 5 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie that has 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": "Which movie has the highest rating score? What is the title, release year, and director name of the movie?",
    "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": "What is the average rating score for the movie 'Flophouse'?",
    "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 = 'Flophouse'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that were released in the year 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 most rated movies and their average rating scores?",
    "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 ORDER BY average_rating DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in the 'movies' table?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "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": "What is the title of the movie released in the year 1993?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1993",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 2087570",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 3?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by user with user_id 43252626?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 43252626",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists follow more than 1000 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 1000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State 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 and release year of the movies directed by Jacques Godbout?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Jacques Godbout'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by user with id 83373278?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 83373278",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have the highest number of followers? How many followers do they 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 average list_comments for lists with more than 5 followers?",
    "SQL": "SELECT AVG(list_comments) FROM lists WHERE list_followers > 5",
    "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": "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 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 made ratings?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM ratings",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'e n e r o' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'e n e r o '",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title 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 are the titles of lists that have been updated in the last 24 hours?",
    "SQL": "SELECT list_title FROM lists WHERE list_update_timestamp_utc >= datetime('now','-24 hours')",
    "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 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 movies in the database?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "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": "How many movies were released in the year 2020?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the most popular movie in the 'lists' table?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year, T2.director_name FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_title = T2.movie_title ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average list movie number for lists with more than 10 followers?",
    "SQL": "SELECT AVG(list_movie_number) 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 popularity?",
    "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 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 users are subscribed to the database?",
    "SQL": "SELECT COUNT(user_subscriber) FROM ratings_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'ANIMATED' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'ANIMATED'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating 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 were released in 1958?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 1958",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the lists with more than 10 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the title '2014' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '2014'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the top 5 movie titles with the highest popularity?",
    "SQL": "SELECT movie_title 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 most popular 5 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 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 followers does the list 'MY LIFE CINEMATIC IN 2014' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'MY LIFE CINEMATIC IN 2014'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists do users have follower more than 100?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies has the director 'Daniel Schweizer' directed?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE director_name = 'Daniel Schweizer'",
    "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": "How many followers does the list 'short animations' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'short animations'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have a rating score greater than 4? Show 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 WHERE T2.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name 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": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the most followers on the lists? What is its release year and director?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year, T1.director_name FROM movies AS T1 INNER JOIN lists AS T2 ON T2.list_movie_number = T1.movie_id ORDER BY T2.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name 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 followers does the list titled 'Favorites' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Favorites'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies with a rating score of 4 or higher?",
    "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 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 of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists created by each user?",
    "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 popularity?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the 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 list title of the list with list_id 140960?",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 140960",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with ID 136035 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 136035",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that has been rated the highest? 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 of the most popular movie?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the 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 title and release year of the movie with the highest popularity score?",
    "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 'Deutsch' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Deutsch'",
    "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 is the title of the movie with the highest rating score? Also, provide the release year and the 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 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that received the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie title from the 'movies' table?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does each user have and list the users with more than 2 lists?",
    "SQL": "SELECT user_id, COUNT(list_id) AS list_count FROM lists GROUP BY user_id HAVING list_count > 2",
    "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 followers does the list 'Roman Polanski' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Roman Polanski'",
    "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 followers does the list 'obsession' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'obsession'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and the release year of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does the user with user_id 33844609 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 33844609",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Farmhouse'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = 'Farmhouse'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have been created by user with ID 49187969?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 49187969",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists in the database?",
    "SQL": "SELECT SUM(list_followers) AS total_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created before January 1, 2015?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_creation_timestamp_utc < '2015-01-01'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie directed by Kristen Hester and what is its release year?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Kristen Hester'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "The director name of the movie 'The English Patient' is Gordon Webber. Write a SQLite query to list the title of movies that have the same director as 'The English Patient'",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Gordon Webber'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating? What is the movie title and its 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 followers does the list 'Underrated Gems' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Underrated Gems'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is 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": "What is the list title and list creation timestamp for the list with list_id 188124?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists WHERE list_id = 188124",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have a trial list and are not subscribed?",
    "SQL": "SELECT COUNT(user_id) FROM lists_users WHERE user_trialist = 1 AND user_subscriber = 0",
    "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 are subscribed to the list?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular list with the most followers?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists have a movie number greater than 100?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_movie_number > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie, its release year, and the name of 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": "Which user has the most followers? How many followers does this user have?",
    "SQL": "SELECT user_id, list_followers FROM lists GROUP BY user_id ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie directed by Christine Whitlock?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Christine Whitlock'",
    "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 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 the list with id 120172 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 120172",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the most critic likes?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T2.movie_id = T1.movie_id ORDER BY T1.critic_likes DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies are directed by Keita Amemiya?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Keita Amemiya'",
    "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 = 6183694",
    "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": "Which movies were released in the year 2007 and have a popularity greater than 50? Return the movie titles and their directors.",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 2007 AND movie_popularity > 50",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the oldest movie in the database?",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_release_year ASC 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 total number of followers for all lists in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'Al Pacino' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Al Pacino'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 10 followers and provide the list title and the number of followers?",
    "SQL": "SELECT list_title, list_followers FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 1948?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year = 1948",
    "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 followers does the list 'Spania' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Spania'",
    "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": "Write a query to find the list titles created by a specific user?",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 82996261",
    "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": "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 release year of all movies?",
    "SQL": "SELECT AVG(movie_release_year) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the details of the list titled 'TOP 5 + DOCS' such as the number of movies, followers, and creation date?",
    "SQL": "SELECT list_movie_number, list_followers, list_creation_timestamp_utc FROM lists WHERE list_title = 'TOP 5 + DOCS'",
    "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 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 followers does the list 'Repertory Cinema 2014' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Repertory Cinema 2014'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Write the movie title and director name of the movies released in year 1960",
    "SQL": "SELECT movie_title , director_name FROM movies WHERE movie_release_year = 1960",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies released in 2017?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2017",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there with more than 10 followers?",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists has the user with user_id 19148144 created?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 19148144",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles of movies that have a rating score greater than 4 and were released in the year 2013?",
    "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 AND T2.movie_release_year = 2013",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with list_id '167332' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 167332",
    "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 number of movies released in 1936?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 1936",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'My picks' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'My picks'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the movie title with the highest rating score among movies released in the year 2010?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year = 2010 ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers for lists that were updated within the last 30 days?",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_update_timestamp_utc >= datetime('now','-30 days')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all lists?",
    "SQL": "SELECT sum(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for a specific user?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 40903141",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in the year 2012?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE STRFTIME('%Y', list_creation_timestamp_utc) = '2012'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers for lists with titles containing 'For rent'?",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_title LIKE '%For rent%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have a rating score greater than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the list 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": "How many movies were released before the year 2000?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers and what is its title?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in 2015?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc LIKE '2015%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with the title '...for the clothes...' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '...for the clothes...'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list with the most followers and its title?",
    "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 of all lists in the database?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with list_id 30507 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 30507",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does a user with user_id '98435130' have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 98435130",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most followed list and its creation timestamp?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the director name of the movie with the maximum movie popularity?",
    "SQL": "SELECT director_name FROM movies ORDER BY movie_popularity 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": "State 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": "What are the movie titles directed by Ben Dickinson in 2012?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Ben Dickinson' AND movie_release_year = 2012",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the name of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in the year 2010?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE STRFTIME('%Y', list_creation_timestamp_utc) = '2010'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director 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": "How many followers does the list titled '21TH CENTURY: THE GREATEST' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '21TH CENTURY: THE GREATEST'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the most followers?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 JOIN ratings AS T2 ON T1.movie_id = T2.movie_id GROUP BY T1.movie_title ORDER BY COUNT(T2.user_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Japan Watchlist' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Japan Watchlist'",
    "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 lists have been created by the user with ID 44084983?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 44084983",
    "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 title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many unique movies are in the database?",
    "SQL": "SELECT COUNT(DISTINCT movie_title) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which user has the most followers?",
    "SQL": "SELECT user_id, 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": "What is the average movie rating score for movies released in 2015?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_release_year = 2015",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a popularity score greater than 100?",
    "SQL": "SELECT COUNT(movie_id) FROM movies WHERE movie_popularity > 100",
    "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": "How many lists were created by users who are also subscribers?",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE user_subscriber = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which list has the most followers and what is the title of that 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 Topkapi? ",
    "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 = 'Topkapi'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies released in the year 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 followers does the list with the title 'Chinese Fims' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Chinese Fims'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Samuel Fuller to Watch' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Samuel Fuller to Watch'",
    "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 of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and 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 lists are there for each user?",
    "SQL": "SELECT user_id, COUNT(list_id) AS number_of_lists FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of movies rated by users who are subscribers?",
    "SQL": "SELECT COUNT(rating_id) FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE lists_users.user_subscriber = 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 have been created by each user?",
    "SQL": "SELECT user_id, COUNT(list_id) as number_of_lists FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles and their directors from the movie release year 2000?",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 2000",
    "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 movie rating score for movies released in the year 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": "What is the total number of users who have created lists?",
    "SQL": "SELECT COUNT(DISTINCT user_id) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the most followers in a list and what is its title?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_id = T2.movie_id ORDER BY T1.list_followers DESC LIMIT 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": "State the number of followers for each list with more than 10 followers.",
    "SQL": "SELECT list_title, list_followers FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating of the movie 'Miss Conception'?",
    "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 = 'Miss Conception'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the 'EATING DISORDERS' list have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'EATING DISORDERS'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the movie with the highest rating?",
    "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 lists have the most followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie popularity of 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 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 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 popular movie? What is its title, release year, and director's name?",
    "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 followers does the list 'seen in 2016' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'seen in 2016'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers on lists? How many lists have more than 100 followers?",
    "SQL": "SELECT AVG(list_followers) , SUM(CASE WHEN list_followers > 100 THEN 1 ELSE 0 END) AS count 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 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 that was released in the year 2017?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2017",
    "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 is the total number of movies that 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 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 is the most popular movie from lists? How many followers does the list have?",
    "SQL": "SELECT T2.movie_title, T1.list_followers FROM lists AS T1 INNER JOIN movies AS T2 ON T2.movie_id = ( SELECT T2.movie_id FROM ratings AS T3 INNER JOIN movies AS T2 ON T2.movie_id = T3.movie_id GROUP BY T2.movie_title ORDER BY COUNT(T3.user_id) DESC LIMIT 1 )",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the movies that have been rated with a score greater than 4?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T1.rating_score > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'spring 2013' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'spring 2013'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does the user with user_id '24092883' have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 24092883",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie rating score for movies released after 1980?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_release_year > 1980",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average movie popularity for movies released in 2020?",
    "SQL": "SELECT AVG(movie_popularity) FROM movies WHERE movie_release_year = 2020",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director's name 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 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 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 lists?",
    "SQL": "SELECT COUNT(DISTINCT user_id) 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 movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating 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 most popular movie in the year 2000? What is its title and the director's name?",
    "SQL": "SELECT movie_title, director_name FROM movies WHERE movie_release_year = 2000 ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the list title 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 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": "List the titles of the first 5 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 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title, release year, and director of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title, T1.movie_release_year, T1.director_name 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": "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 before the year 2000?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year < 2000",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies are there in total?",
    "SQL": "SELECT COUNT(movie_id) FROM movies",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title with the most followers and when was it created?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that 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 average number of followers for all lists in the database?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies with a rating score greater than 4 and the year they were released?",
    "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": "Which user has the highest number of followers?",
    "SQL": "SELECT user_id FROM lists GROUP BY user_id ORDER BY SUM(list_followers) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "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 followers for all lists combined?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "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": "Which movie has the highest rating score and what is the critic's opinion?",
    "SQL": "SELECT T2.movie_title, T1.critic, 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 movies were released in the year 2016?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2016",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the most popular movie and its director name?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie was released earliest and what is its title and director?",
    "SQL": "SELECT movie_title, movie_release_year, director_name FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of lists that have over 100 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 100",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled '2014 Viewings' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '2014 Viewings'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the most popular movies and their release years?",
    "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 title of the movie with the highest rating score, and what is the 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 most popular movie and what is its 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 are followed by users?",
    "SQL": "SELECT sum(list_followers) FROM lists",
    "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 movie rating score for the movie 'Extremis'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Extremis')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the release year of 'Morrh\u00e5r & \u00e4rtor'? What is the name of the director?",
    "SQL": "SELECT movie_release_year, director_name FROM movies WHERE movie_title = 'Morrh\u00e5r & \u00e4rtor'",
    "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 has 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 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 lists have been created by user with id 43917266?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 43917266",
    "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 followers for the list titled 'leonie'?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'leonie'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title of the list with the highest number of followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the 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 total number of followers of all lists?",
    "SQL": "SELECT SUM(list_followers) AS total_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most number of followers?",
    "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 were created by user with user_id '80434919'?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = '80434919'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Films seen in 2011' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Films seen in 2011'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most followers in the 'lists' table?",
    "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": "What is the title of the movie released in the year 2004 directed by Mikael Marcimain?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2004 AND director_name = 'Mikael Marcimain'",
    "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 lists were created before January 1, 2014?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc < '2014-01-01 00:00:00'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the lists with more than 10 followers and what is the average movie number in these lists?",
    "SQL": "SELECT list_title, AVG(list_movie_number) FROM lists WHERE list_followers > 10 GROUP BY list_title",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of movies that were released after the year 2000?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2000",
    "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": "How many movies have been released in each year from 2010 to 2020?",
    "SQL": "SELECT movie_release_year, COUNT(*) FROM movies WHERE movie_release_year BETWEEN 2010 AND 2020 GROUP BY movie_release_year",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are followed by more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT 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 and release years of the movies with a rating score higher than 4?",
    "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 > 4",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies directed by Carlos Hugo Christensen?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Carlos Hugo Christensen'",
    "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 are subscribed to the list with ID 37867?",
    "SQL": "SELECT COUNT(user_subscriber) FROM lists_users WHERE list_id = 37867",
    "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": "what is the title of the movie with the highest popularity rating?",
    "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 title?",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created before the year 2015?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc LIKE '2015%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie? What is its release year and 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": "How many lists have more than 10 followers?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists does the user with id '91055310' have?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = '91055310'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the most followers in the 'Portugal - To Watch' list?",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM lists AS T1 INNER JOIN movies AS T2 ON T1.list_id = T2.movie_id WHERE T1.list_title = 'Portugal - To Watch' GROUP BY T2.movie_title, T2.movie_release_year ORDER BY COUNT(T2.movie_id) DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and the number of followers for the top films list?",
    "SQL": "SELECT list_title, list_followers FROM lists WHERE list_title = 'top films'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find 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 most followers?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T2.movie_id = T1.list_title ORDER BY T2.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers for lists?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the movie titles and their ratings from users who have been subscribers for more than one year?",
    "SQL": "SELECT T1.movie_title, T2.rating_score FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id WHERE T2.user_subscriber > 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that was released in 2013 and has the highest popularity?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2013 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": "Query the title and release year of the movie with the highest rating score.",
    "SQL": "SELECT T2.movie_title, T2.movie_release_year FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie 'Approaching Omega'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'Approaching Omega')",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'Indiana Jones Films Ranked' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Indiana Jones Films Ranked'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'my italian film diary' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'my italian film diary'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that received the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many 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": "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 in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity 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": "How many lists does user 21287265 have?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 21287265",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score? What is the critic's comment for the movie?",
    "SQL": "SELECT T1.movie_title, T2.critic_comments 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 were created before 2010?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE list_creation_timestamp_utc < '2010-01-01'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List the titles and movie 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": "Which lists have more than 10 followers and what is their creation timestamp?",
    "SQL": "SELECT list_title, list_creation_timestamp_utc 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 were released in the year 1937?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 1937",
    "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 followers does the list 'Movies in 2015' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Movies in 2015'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created in the year 2016?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE STRFTIME('%Y', list_creation_timestamp_utc) = '2016'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled 'Best of 2001' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Best of 2001'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'TCA' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'TCA'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the first movie listed in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_release_year ASC LIMIT 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) AS total_lists FROM lists GROUP BY user_id",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list '2013, Top Ten' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '2013, Top Ten'",
    "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 name of the oldest movie and what year was it released?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list titled '\u2661' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '\u2661'",
    "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 total number of followers for all lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score 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 title and release year of the most popular movie directed by Mora Stephens?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE director_name = 'Mora Stephens' ORDER BY movie_popularity 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": "What is the title and description of the list with the most followers?",
    "SQL": "SELECT list_title, list_description FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movies have been released in the year 2009?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2009",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for all the lists?",
    "SQL": "SELECT SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Describe the details of the lists with list_id = 92751.",
    "SQL": "SELECT * FROM lists WHERE list_id = 92751",
    "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 top 5 most popular movies released in the year 1973?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1973 ORDER BY movie_popularity DESC LIMIT 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of movies followed by each user?",
    "SQL": "SELECT AVG(list_followers) AS average_followers FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What are the titles of the lists 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 followers does the list with list_id 829 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 829",
    "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": "What is 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 name of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the movie with the highest rating score?",
    "SQL": "SELECT 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 were released in 2019?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2019",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which lists have more than 10 followers?",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating 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 of movies directed by Jonathan Lewis?",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Jonathan Lewis'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list '2018 altrove' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = '2018 altrove'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most followed list and its followers count?",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list with list_id 3529 have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_id = 3529",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for movies with a release year greater than 2010?",
    "SQL": "SELECT AVG(rating_score) FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id WHERE T2.movie_release_year > 2010",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the most popular movie title in the database and who is the director?",
    "SQL": "SELECT movie_title, director_name FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average list follow count of all lists?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists are there for a specific user with user_id = 47766894?",
    "SQL": "SELECT COUNT(list_id) FROM lists WHERE user_id = 47766894",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the total number of followers for the lists with a movie number of 3?",
    "SQL": "SELECT SUM(list_followers) FROM lists WHERE list_movie_number = 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "List all the movie titles directed by David Maldi",
    "SQL": "SELECT movie_title FROM movies WHERE director_name LIKE '%David Maldi%'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by a user with ID 73197740?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 73197740",
    "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": "How many followers does the list 'liz taylor top ten' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'liz taylor top ten'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many users have subscribed to the platform?",
    "SQL": "SELECT SUM(user_subscriber) FROM lists_users",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score and what is the title, release year, and director of the movie?",
    "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": "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": "How many users have rated the movie with the highest popularity?",
    "SQL": "SELECT COUNT(user_id) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 1)",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies were released in the year 2017?",
    "SQL": "SELECT COUNT(movie_title) FROM movies WHERE movie_release_year = 2017",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were created by the user with user_id 24404914?",
    "SQL": "SELECT COUNT(list_id) FROM lists_users WHERE user_id = 24404914",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score of 5?",
    "SQL": "SELECT COUNT(movie_id) FROM ratings WHERE rating_score = 5",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title 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 and description of the list named 'watched'?",
    "SQL": "SELECT list_title, list_description FROM lists WHERE list_title = 'watched'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title and release year of the most popular movie 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 T1.movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest popularity?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Name the list titles of users who are subscribers.",
    "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 = 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the most followers?",
    "SQL": "SELECT T2.movie_title FROM lists AS T1 INNER JOIN movies AS T2 ON T2.movie_id = 1 ORDER BY T1.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Find 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 are the titles of all movies released after the year 2015?",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2015",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many lists were 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 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": "What is the average rating score for the movie 'Schooled'? ",
    "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 = 'Schooled'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average number of followers of the lists?",
    "SQL": "SELECT AVG(list_followers) FROM lists",
    "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 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 most popular movie in the database?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the highest rating score? When was it released and what is its director's name?",
    "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": "How many followers does the list titled 'Chinese Fims' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Chinese Fims'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "list all the lists with more than 10 followers and sort 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": "What is the title of the movie with the highest rating score?",
    "SQL": "SELECT T2.movie_title FROM ratings AS T1 INNER JOIN movies AS T2 ON T1.movie_id = T2.movie_id ORDER BY T1.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the list title with the most followers?",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "Which movie has the most followers among the lists?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN lists AS T2 ON T1.movie_id = T2.list_movie_number ORDER BY T2.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Top 2012' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Top 2012'",
    "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 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 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": "What is the title of the movie with the highest rating?",
    "SQL": "SELECT T1.movie_title FROM movies AS T1 INNER JOIN ratings AS T2 ON T1.movie_id = T2.movie_id ORDER BY T2.rating_score DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a rating score greater than 3?",
    "SQL": "SELECT COUNT(*) FROM ratings WHERE rating_score > 3",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "State the movie 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": "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": "What is the total number of lists and their followers?",
    "SQL": "SELECT COUNT(list_id) , SUM(list_followers) FROM lists",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the average rating score for the movie '40 Views of Water'?",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title = '40 Views of Water'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "The director of which movie was Robyn Paterson?",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Robyn Paterson'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many movies have a release year before 1950?",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_release_year < 1950",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "The user with the highest number of followers has which list title? ",
    "SQL": "SELECT T2.list_title FROM lists_users AS T1 INNER JOIN lists AS T2 ON T1.list_id = T2.list_id GROUP BY T1.user_id ORDER BY T2.list_followers DESC LIMIT 1",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "How many followers does the list 'Neveldine/Taylor Ranked' have?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'Neveldine/Taylor Ranked'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of 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": "How many users follow the list 'tripped out'?",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'tripped out'",
    "db_id": "movie_platform",
    "evidence": ""
  },
  {
    "question": "What is the title of the movie that was released first?",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_release_year ASC LIMIT 1",
    "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 are the titles and release years of the movies released before 1990?",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_release_year < 1990",
    "db_id": "movie_platform",
    "evidence": ""
  }
]