[
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers on the list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the film 'Mazepa'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Mazepa')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the rating database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists created by user with id 48265333?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 48265333"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated 4 by user '42317868'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings, movies WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score = 4 AND ratings.user_id = 42317868"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that contains Tom of Your Life movie?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists WHERE list_movie_number = (SELECT movie_id FROM movies WHERE movie_title = 'Tom of Your Life'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with user ID 71387299 and list ID 68897?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 71387299 AND list_id = 68897"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has been updated the most recently?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_update_timestamp_utc DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating and who is the critic?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.critic, r.rating_score FROM movies m JOIN ratings r ON m.movie_id = r.movie_id ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a rating score of 4 or higher and were released in 1974?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score >= 4 AND m.movie_release_year = 1974"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with animation movies that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists WHERE list_title LIKE '%Animation%')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the list with id 165308?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_id = 165308)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by a user with trialist status?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_trialist = 1) AND list_id IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with a rating of 4 and the user who rated it is a subscriber?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings.rating_score = 4 AND ratings_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are most popular among users who have a list with 5 movies?",
    "evidence": "",
    "SQL": "SELECT M.movie_title, COUNT(R.rating_id) as popularity FROM ratings R, lists L, lists_users LU, movies M WHERE LU.list_id = L.list_id AND LU.user_id = R.user_id AND L.list_movie_number = 5 GROUP BY M.movie_title ORDER BY popularity DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with a 5-star rating given by user '11611343'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_score = 5 AND user_id = 11611343"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 172310?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 172310"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies were listed by user with ID 39665133?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id=39665133)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular lists with the most number of followers?",
    "evidence": "",
    "SQL": "SELECT l.list_title, COUNT(lu.list_id) AS followers FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id GROUP BY l.list_title ORDER BY followers DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the list with list ID 144120?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 144120"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating among movies watched by user 78733007?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.user_id = 78733007 AND movies.movie_id = ratings.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings WHERE user_id = 78733007)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of ratings in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY (SELECT COUNT(*) FROM ratings WHERE ratings.movie_id = movies.movie_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list Sofia Coppola, RANKED.? and how many movies is it ranked?",
    "evidence": "",
    "SQL": "SELECT list_title, list_movie_number FROM lists WHERE list_title = 'Sofia Coppola, RANKED.'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 131673?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 131673"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the list with id 137413?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 137413"
  },
  {
    "db_id": "movie_platform",
    "question": "What Iranian films are in the most popular lists?",
    "evidence": "",
    "SQL": "SELECT DISTINCT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.list_id IN (SELECT list_id FROM lists WHERE list_title LIKE '%Iranian Films%') AND l.list_followers > 0 ORDER BY l.list_followers DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie with rating 4?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 4 ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which user has rated 'Father Frost'?",
    "evidence": "",
    "SQL": "SELECT user_id FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Father Frost')"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has been rated the highest by subscribers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 1 AND r.rating_score = (SELECT MAX(rating_score) FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first unusual movie listed in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title = 'Unusual' LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the lowest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MIN(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists that have more than 0 followers and created before 2013?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 0 AND list_creation_timestamp_utc < '2013-01-01 00:00:00' ORDER BY list_followers DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the 'Watched' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists_users WHERE user_id = 80704036 LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that the user 64978245 is following?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 64978245"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of users who have never been a subscriber?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id NOT IN (SELECT list_id FROM lists_users WHERE user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are rated by the user with ID 62548003?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.user_id = 62548003"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for 'The Bride of the Mountains'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Bride of the Mountains')"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have the movie La La La at Rock Bottom?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_title = '2013, Top Ten'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has 2 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 2"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the list with the title 'The Russo Brothers'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title = 'The Russo Brothers'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles in the list 'Coreia do Sul'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_id WHERE list_title = 'Coreia do Sul'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies rated by users who are both subscribers and have a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(movie_popularity) FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id INNER JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings_users.user_subscriber = 1 AND ratings_users.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the CULT list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title = (SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'CULT'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists contain the movie 'A French Woman'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'A French Woman')))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 147220?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 147220"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the 'D\u00c9CADA DE 90' list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE m.movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'D\u00c9CADA DE 90') AND r.rating_score = (SELECT MAX(rating_score) FROM ratings) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT list_title, list_movie_number FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users)) GROUP BY list_title, list_movie_number ORDER BY list_movie_number DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the film with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie was not released in the year 1988?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year != 1988"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists that the user with ID 76819909 has created?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 76819909"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in a list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists JOIN (SELECT list_id, COUNT(*) AS followers FROM lists_users GROUP BY list_id ORDER BY followers DESC LIMIT 1) AS followers ON lists.list_id = followers.list_id WHERE list_movie_number = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating score among all movies?",
    "evidence": "",
    "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",
    "question": "Which lists are followed by users who have never been subscribers?",
    "evidence": "",
    "SQL": "SELECT l.list_title, l.list_id FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN ratings_users ru ON lu.user_id = ru.user_id WHERE ru.user_subscriber = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does the user with id 94812835 have?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 94812835"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top three movies listed by user 73497125?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings_users WHERE user_id = 73497125 ORDER BY rating_date_utc DESC LIMIT 3)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 225664?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 225664"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the ID 134607?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 134607"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 26789?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 26789"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies in the BEST OF 1978 list have a rating score above 3?",
    "evidence": "",
    "SQL": "SELECT movie_id, movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE list_title = 'BEST OF 1978' AND exists (SELECT 1 FROM ratings WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score > 3)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the 100th personal favourite movie in a user's list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id = (SELECT list_id FROM lists WHERE list_movie_number = 100)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Christine Gensheimer?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Christine Gensheimer'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 178210?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 178210"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list contains the movie 'Being Women'?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_title = (SELECT list_title FROM movies WHERE movie_title = 'Being Women')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies that have been rated by users who have a paid subscription?",
    "evidence": "",
    "SQL": "SELECT * FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings_users.user_has_payment_method = 1 ORDER BY ratings.rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie released in 2019?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '2019' ORDER BY movie_id LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies with 3 star ratings from the lists of subscribers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) AS total_ratings FROM lists_users lu JOIN ratings r ON lu.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE lu.user_subscriber = 1 AND r.rating_score = 3 GROUP BY m.movie_title ORDER BY total_ratings DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'Carrs Down South'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 171405"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is most popular among users who have a subscription and have a payment method?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.user_subscriber = 1 AND lu.user_has_payment_method = 1 GROUP BY m.movie_title ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with user_id 89047670?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 89047670"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the film with the highest movie_popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie among users who are not trialists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score > 2 AND ratings.user_trialist = 0 ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are not yet rated by any users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m LEFT JOIN ratings r ON m.movie_id = r.movie_id WHERE r.movie_id IS NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in the `lists` table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_movie_number DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 51758?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 51758"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been added to a user's list since they became a subscriber?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1) AND list_creation_date_utc > (SELECT list_creation_date_utc FROM lists_users WHERE user_id = (SELECT user_id FROM ratings_users WHERE user_subscriber = 1) ORDER BY list_creation_date_utc ASC LIMIT 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 133265?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 133265"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies liked by user '3593588'?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id = 3593588 AND rating_score > 3 ORDER BY rating_score DESC LIMIT 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating on this database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) ORDER BY movie_title LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies rated by a user who is both a subscriber and a user with a payment method in the year 2011?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id INNER JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 1 AND ru.user_has_payment_method = 1 AND SUBSTR(r.rating_timestamp_utc,1,4) = '2011'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 173847?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 173847"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have the movie 'Undefeated' in them?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_movie_number = (SELECT movie_id FROM movies WHERE movie_title = 'Undefeated')))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the movie with id 252785?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 252785"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 123616?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123616"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie was rated 4 by a subscriber who has a payment method?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id INNER JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings.rating_score = 4 AND ratings_users.user_has_payment_method = 1 AND ratings_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the film that has the highest user rating?",
    "evidence": "",
    "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",
    "question": "What are the top 5 movies rated by a user who has paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method=1) ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 130293?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 130293"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with user_id 52298383?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 52298383"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are rated 3 by users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE rating_score = 3 AND user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies were rated by users with payment methods on December 22nd, 2016?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id INNER JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_has_payment_method = 1 AND r.rating_timestamp_utc = '2016-12-22' ORDER BY m.movie_title ASC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 120738?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 120738"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie among the users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings_users r ON m.movie_id = r.user_id WHERE r.user_has_payment_method = 1 ORDER BY m.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie is in a list titled 'Jacques Demy'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists LEFT JOIN movies ON lists.list_id = 153528 AND lists.list_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies rated by user with ID 54439150?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.user_id = 54439150 ORDER BY rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 224505?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 224505"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are followed by a user with id 40090735?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE user_id = 40090735"
  },
  {
    "db_id": "movie_platform",
    "question": "Which director has directed the most movies?",
    "evidence": "",
    "SQL": "SELECT director_name FROM movies GROUP BY director_name ORDER BY COUNT(movie_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 26038?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 26038"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "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",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists that a user with user_id 74833790 created?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 74833790"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the list of 1991 essentials that were released in 1949?",
    "evidence": "",
    "SQL": "SELECT m.* FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN ratings r ON lu.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE l.list_title = '1991 essentials' AND m.movie_release_year = '1949'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the film that a user with user ID 67384823 has given a rating of 2?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.rating_score = 2 AND ratings.user_id = 67384823 AND ratings.movie_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 145060?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 145060"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is most popular among users?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of all the movies in a list titled Strait-Jacket?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id JOIN lists ON lists.list_title = 'Strait-Jacket' JOIN lists_users ON lists_users.list_id = lists.list_id WHERE lists_users.user_id = ratings.user_id AND movies.movie_title = 'Strait-Jacket'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 189066?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 189066"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most number of followers?",
    "evidence": "",
    "SQL": "SELECT DISTINCT movie_title FROM lists, movies WHERE list_movie_number = movie_id AND list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie with a release year of 1998 has the highest popularity among all movies in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '1998' ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists created by a user with ID 33023922?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 33023922"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 150200?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 150200"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that the user with ID 51146513 has rated?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.user_id = 51146513 AND ratings.movie_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie was the female pioneers list created in reference to?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'Female Pioneers')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the lists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN lists ON lists.list_movie_number = movies.movie_popularity ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list `Films Watched 2015`?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 111926 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has a user trialist of 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_trialist = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are followed by user 19221797?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 19221797)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by user with ID 66317016?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 66317016"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does user 77323234 follow?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists_users lu INNER JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 77323234"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Philipp Kadelbach?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Philipp Kadelbach'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers in the list 'top 10 films of 1936'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_title = 'top 10 films of 1936')) ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with a popularity score of 0 and whose director is Helena Nogueira?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = 0 AND director_name = 'Helena Nogueira'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the list 'Las Chidas' with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id = 118572 AND list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating score?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular lists on the database?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie on Mubi?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list has a movie titled 'A Morning Bath'?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_title = '2019' AND list_movie_number = 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the list 74018?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 74018 ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by \u00c9douard Molinaro?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = '\u00c9douard Molinaro'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the list with title 'Gothic Films'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists WHERE list_title = 'Gothic Films')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the names of all movies that were released after 2000 and directed by Nicolas Monette?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_release_year > 2000 AND director_name = 'Nicolas Monette'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by the user 11566700?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 11566700)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie released in 1988?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '1988' ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(list_id) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie was rated by a trialist subscriber",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings_users.user_trialist = 1 AND ratings_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are followed by the user who follows the list 'love for food'?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'love for food'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie title is associated with the list 'The Cinema of Aliens ' by user with ID 89369872?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE lists.list_id = movies.movie_id AND lists.user_id = 89369872 AND lists.list_title = 'The Cinema of Aliens '"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie was directed by Woody Allen?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name='Woody Allen'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score for the movie Boccaccio 70?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Boccaccio 70')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are rated 5 stars by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings r JOIN lists_users lu ON r.user_id = lu.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score = 5 AND lu.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings) "
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie released in the year 1960 and directed by Ion Popescu-Gopo?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '1960' AND director_name = 'Ion Popescu-Gopo'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 86 movies created by user 60626012?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 60626012 AND list_movie_number = 86"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated 5 by a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = 5 AND user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the 'Chinese Films' list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists INNER JOIN lists_users ON lists.list_id = lists_users.list_id INNER JOIN movies ON lists.user_id = movies.movie_id WHERE list_title = 'Chinese Films' ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the 10th movie in the ranking David Lynch's films list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 117469 AND list_movie_number = 10"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have movies that have been rated by users?",
    "evidence": "",
    "SQL": "SELECT DISTINCT l.list_title FROM lists l INNER JOIN lists_users lu ON l.list_id = lu.list_id INNER JOIN ratings r ON lu.user_id = r.user_id WHERE r.rating_score IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most popular release year in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_release_year DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has been rated 4 by user 47680220?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE user_id = 47680220 AND rating_score = 4"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has 3 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular lists in the database, considering the number of followers?",
    "evidence": "",
    "SQL": "SELECT list_id, list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie rated by users in the list 'Quentin Tarantino'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_id IN (SELECT rating_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id = 159620)) AND ratings.rating_score > 3 ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies with a critic rating score of 4?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = 4"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie by director Aaron Kurmey is the most popular?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name='Aaron Kurmey' AND movie_popularity=(SELECT MAX(movie_popularity) FROM movies WHERE director_name='Aaron Kurmey')"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does the user with the ID 94731849 follow?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 94731849"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do users with trial accounts follow?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id JOIN ratings_users ON lists_users.user_id = ratings_users.user_id WHERE ratings_users.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in the database sorted by their popularity?",
    "evidence": "",
    "SQL": "SELECT * FROM movies ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the lowest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score = (SELECT MIN(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of El Cerro de los Dioses movie?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'El Cerro de los Dioses')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 107478?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 107478"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating that has been rated by a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(r2.rating_score) FROM ratings r2 WHERE r2.user_id IN (SELECT user_id FROM lists_users lu WHERE lu.user_subscriber = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the WATCHED IN 2013 list?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings, lists_users WHERE lists_users.list_id = 57777 AND ratings.user_id = lists_users.user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first list under user 91640033?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 91640033 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the popularity of the movie Ms. Bu Laughs?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE movie_title = 'Ms. Bu Laughs'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list titled 'Emi' has the most movies?",
    "evidence": "",
    "SQL": "SELECT list_title, COUNT(*) AS num_movies FROM lists, lists_users WHERE lists.user_id = lists_users.user_id AND lists_users.list_id = lists.list_id AND lists.list_title = 'Emi' GROUP BY list_title ORDER BY num_movies DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in the 'May' list?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE list_title = 'May' ORDER BY list_movie_number LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has been the most popular among users of the 'DANCE - FILM' list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id = (SELECT list_id FROM lists WHERE user_id = 10250279))) ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies has user `88216422` rated?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_id = 88216422"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest list_movie_number in the lists table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = (SELECT MAX(list_movie_number) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the list 'Lgbt'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r INNER JOIN lists_users lu ON r.user_id = lu.user_id INNER JOIN lists l ON lu.list_id = l.list_id WHERE l.list_title = 'Lgbt'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does the user with ID 75396867 have?",
    "evidence": "",
    "SQL": "SELECT list_title, list_id FROM lists WHERE user_id = 75396867"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are updated regularly by a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT l.list_id, l.list_title FROM lists_users lu INNER JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_subscriber = 1 AND lu.list_update_date_utc IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that contains the movie 'Separate Tables'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists WHERE list_movie_number = (SELECT movie_id FROM movies WHERE movie_title = 'Separate Tables'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What list of movies has the user with ID 64690347 created?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 64690347)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists created by user with user_id 72149903?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 72149903"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 155591?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 155591"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 24614?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 24614"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists having at least 2 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number > 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the Moroccan cinema list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN lists ON movies.movie_id = lists.list_movie_number WHERE list_title = 'Moroccan cinema' ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that was released in 2014 and is also featured in a user's list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.list_id = m.movie_id WHERE l.list_movie_number = 19 AND lu.list_id = l.list_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the movie with ID 175221?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 175221"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been added to the 'Best Films of 2001' list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.user_id = lu.user_id WHERE l.list_title = 'Best Films of 2001' AND lu.list_id IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest number of followers in the `lists` table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies in the Chinese Films list are rated 4 out of 5?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists AS l JOIN lists_users AS lu ON l.list_id = lu.list_id JOIN movies AS m ON lu.user_id = m.director_id WHERE l.list_title = 'Chinese Films' AND lu.user_trialist = 1 AND m.movie_title NOT LIKE '%play%' AND m.movie_popularity > 0 AND m.movie_id IN (SELECT r.movie_id FROM ratings AS r WHERE r.rating_score = 4) AND lu.user_has_payment_method = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by subscribers who have payment methods?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.user_subscriber = 1 AND ratings.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the 2014 list with only 1 follower?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users) AND list_followers = 1 AND list_title LIKE '%2014%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the list with the title '60s'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_id WHERE list_title = '60s'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with user_id 18285316?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 18285316"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been liked by users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_has_payment_method = 1 AND r.rating_score > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the 'Top Ten 1994' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'Top Ten 1994')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles that have been rated 5 by a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = 5 AND user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 123359?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 123359"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in a watchlist with no followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = 0 ORDER BY list_creation_timestamp_utc LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has a rating score of 4?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE rating_score = 4)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do the user with id 79791872 own?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 79791872"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 4446?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 4446"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Russell Friedenberg?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Russell Friedenberg'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 19128?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 19128"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have been rated by users who have subscribed to the service?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the total number of movies rated by users?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM ratings"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists GROUP BY list_id ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the ID 175399?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 175399"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the lowest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MIN(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies released in the year 2011 that have been rated by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_timestamp_utc >= '2011-01-01' AND r.rating_timestamp_utc <= '2011-12-31' ORDER BY r.rating_score DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the popularity of the movie with title '' and release year 2004?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE movie_title='' AND movie_release_year=2004"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the total followers of all lists made by user 52253268?",
    "evidence": "",
    "SQL": "SELECT SUM(list_followers) as total_followers FROM lists, lists_users WHERE lists.list_id = lists_users.list_id AND lists_users.user_id = 52253268"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "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",
    "question": "What is the title of the list with ID 24737?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 24737"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has Michael Brynntrup as its director and was released in the year 1990?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Michael Brynntrup' AND movie_release_year = 1990"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 54429?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 54429"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the best actresses list with 7 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 30220501) AND list_movie_number = 7"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest popularity in a list that has the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists INNER JOIN lists_users ON lists.user_id = lists_users.user_id INNER JOIN movies ON lists.list_id = movies.movie_id WHERE list_followers = (SELECT MAX(list_followers) FROM lists) AND movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the horror film list created by the user with ID 36567742?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = '36567742'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 2551?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 2551"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating among all the movies?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings, movies WHERE ratings.movie_id = movies.movie_id ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top ten movies of 2004 in the list 'Top Ten 2004'? ",
    "evidence": "",
    "SQL": "SELECT list_movie_number, movie_title FROM lists, lists_users, movies WHERE lists.user_id = lists_users.user_id AND lists_users.list_id = lists.list_id AND lists.list_title = 'Top Ten 2004' AND lists.list_movie_number = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 151830?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 151830"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated 5 by a trialist?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 5 AND ratings.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the popularity of the movie 'Cinderella Ballet'?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE movie_title = 'Cinderella Ballet'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies are users with a trial subscription following?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN ratings_users ru ON lu.user_id = ru.user_id WHERE ru.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the 'true crime' list?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM lists L INNER JOIN lists_users LU ON L.list_id = LU.list_id INNER JOIN movies M ON L.list_id = M.movie_id WHERE L.list_title = 'true crime' ORDER BY L.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user 22336946?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 22336946"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie released in 1959 has the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1959 ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does user with ID 92468128 have?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE user_id = 92468128"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of movies a user with a payment method follows?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have the most followers?",
    "evidence": "",
    "SQL": "SELECT list_id, list_title, list_followers FROM lists WHERE list_followers > (SELECT AVG(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, r.rating_score FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id INNER JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has a list title 'THE COEN BROS & I'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title = 'THE COEN BROS & I'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by the user with id 52280073?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 52280073"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists that have at least 3 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers >= 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top movies with a rating score of 5 that were released before 2006?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year < 2006 AND movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are listed in the list 'Top 10 films of 2012'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON lu.user_id = m.director_id WHERE l.list_title = 'Top 10 films of 2012'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has 12 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 12"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has 33 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = '33'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id GROUP BY movie_title ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies rated by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM movies m JOIN ratings_users ru ON m.movie_id = ru.user_id JOIN ratings r ON m.movie_id = r.movie_id WHERE ru.user_has_payment_method = 1 ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the movie rated 5 stars by user with id 22520719?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE rating_score = 5 AND user_id = 22520719)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of the Witchville movie based on user ratings?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Witchville')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 115453?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 115453"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the 'Touching' list?",
    "evidence": "",
    "SQL": "SELECT list_title, list_movie_number, movie_title, movie_release_year FROM lists LEFT JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_id = 103383"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in the 2014 release year?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '2014' ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie was rated by user with id 60633081?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_id = 60633081"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Giovanni Grimaldi?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Giovanni Grimaldi'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the movie with the highest number of ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY COUNT(ratings.rating_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie with a release year of 1975 has been rated by a user who is a subscriber and has payment method?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE movies.movie_release_year = 1975 AND ratings.user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1 AND user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies in the lists database?",
    "evidence": "",
    "SQL": "SELECT AVG(m.movie_popularity) FROM lists AS l JOIN movies AS m ON l.list_movie_number = m.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists created by user 18285316?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 18285316"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest popularity among the users in the 'lists_users' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score IN (SELECT MAX(rating_score) FROM ratings)) ORDER BY movie_title LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 11 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 11"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have subscribed to 'MERCI MUBI - courts'?",
    "evidence": "",
    "SQL": "SELECT l.user_id FROM lists_users l WHERE l.list_id = (SELECT l.list_id FROM lists l WHERE l.list_title = 'MERCI MUBI - courts') AND l.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists created by the user with the user_id 91125685?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = '91125685'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY COUNT(rating_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users GROUP BY user_id ORDER BY COUNT(*) DESC LIMIT 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has been rated 4 by a user who has not paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM ratings R, movies M WHERE R.rating_score = 4 AND R.user_trialist = 0 AND R.user_subscriber = 0 AND R.user_eligible_for_trial = 1 AND R.user_has_payment_method = 0 AND R.movie_id = M.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the 'favourite endings' list made by the user with id 26889326?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 26889326"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user 88239169?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 88239169"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the lowest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM movies ORDER BY movie_popularity LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie title is rated 3 by a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 3 AND ratings.user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE lists.list_id = movies.movie_id GROUP BY movie_title ORDER BY lists.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers on the list 'The Cinema of Giants'?",
    "evidence": "",
    "SQL": "SELECT list_title, list_followers FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'The Cinema of Giants' ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who have also created lists?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN lists_users lu ON r.user_id = lu.user_id GROUP BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 3 followers that was created on 2014-01-05 15:02:42?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = 3 AND list_creation_timestamp_utc = '2014-01-05 15:02:42'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the Film Noir Classics list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists_users WHERE user_id = 46076803 AND list_id = (SELECT list_id FROM lists WHERE list_title = 'Film Noir Classics'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 rated movies of the director Nadine Trintignant?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE m.director_name = 'Nadine Trintignant' ORDER BY r.rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title with the highest user rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings.rating_score > (SELECT AVG(rating_score) FROM ratings) ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the 74th movie in the 'Mad 70s' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id=(SELECT list_id FROM lists WHERE list_movie_number=74)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie on the list with 2 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = 2 ORDER BY list_id LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have more than 3 movies?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number > 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies in the 'Movies I've Watched on MUBI' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 191660"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies were rated by a user who is not a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, r.rating_score FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id INNER JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 45675?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 45675"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies in lists with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m, lists l WHERE m.movie_id IN (SELECT list_id FROM lists WHERE list_followers > (SELECT AVG(list_followers) FROM lists)) ORDER BY m.movie_popularity DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the list titled '2019'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT list_id FROM lists WHERE list_title = '2019') AND rating_score IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 13594?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 13594"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating?",
    "evidence": "",
    "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",
    "question": "Which users have a rating score of 4 for movie Cruisin' Down the River?",
    "evidence": "",
    "SQL": "SELECT user_id FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Cruisin'' Down the River') AND rating_score = 4"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that user 72540775 created and has 0 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 72540775 AND list_followers = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user 57262409?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 57262409"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the Italian films that are liked by at least one user?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l, ratings r WHERE l.list_id = 128379 AND l.list_movie_number = r.movie_id AND r.rating_score > 0 GROUP BY l.list_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 38172?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 38172"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the lists table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies rated by a non-subscriber user?",
    "evidence": "",
    "SQL": "SELECT * FROM movies m, ratings r WHERE m.movie_id = r.movie_id AND r.user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 0) ORDER BY r.rating_score DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies that have a list of ratings from users?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(DISTINCT user_id) DESC LIMIT 3)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who are both trialists and subscribers?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings_users.user_trialist = 1 AND ratings_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which user_id is associated with the list_id 182387?",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists WHERE list_id = 182387"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the names of the directors who have directed movies released in 1956?",
    "evidence": "",
    "SQL": "SELECT director_name FROM movies WHERE movie_release_year = 1956"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that received a rating of 3 from user 82252286?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 3 AND user_id = 82252286)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies has user with ID 71458797 rated?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_id = 71458797"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in the list 'Movies in 2014'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title = 'Movies in 2014' ORDER BY list_movie_number LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie did user 58940345 rate 4/5 stars?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_id = 2122940 AND r.user_id = 58940345"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that was released in 2006 and directed by Peter Moss?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2006 AND director_name = 'Peter Moss'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the movie 'Comrade Kim Goes Flying'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number = (SELECT movie_id FROM movies WHERE movie_title = 'Comrade Kim Goes Flying')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the popularity of 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 20 movies and 1 follower?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 20 AND list_followers = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the top-rated movie in the Christopher Nolan ranking list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings WHERE rating_id IN (SELECT rating_id FROM ratings WHERE rating_score IN (SELECT MAX(rating_score) FROM ratings))))"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has Calvin Marshall as its director?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE director_name = 'Gary Lundgren'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 30012?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 30012"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 132601?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 132601"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the top 10 lists of the user with ID 97517537?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 97517537 ORDER BY list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the highest popularity among all the movies in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the total number of movies in the database?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by a user with the user ID 95300672?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 95300672"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 167578?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 167578"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) ORDER BY movie_title LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has the title 'The Glass Shield'?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_title = 'The Glass Shield'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 74018?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 74018"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies rated by users who have been eligible for trial?",
    "evidence": "",
    "SQL": "SELECT * FROM movies, ratings_users, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.user_id = ratings_users.user_id AND ratings_users.user_eligible_for_trial = 1 ORDER BY ratings.rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists created by user 97517537?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 97517537"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Elaine Proctor?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Elaine Proctor'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies directed by Hal Walker?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m WHERE m.director_name = 'Hal Walker' ORDER BY m.movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top-rated movies with trailers?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_release_year, list_title FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id JOIN movies ON lists.user_id = movies.director_id WHERE list_movie_number > 0 ORDER BY list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists has user 10470454 created?",
    "evidence": "",
    "SQL": "SELECT list_id, list_title FROM lists WHERE user_id = 10470454"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies does user with id 34055098 have?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 34055098"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the 'Frances McDormand' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_title = 'Frances McDormand')) AND list_followers = (SELECT MAX(list_followers) FROM lists WHERE list_title = 'Frances McDormand')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest rating in the movie ratings table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings WHERE rating_id IN (SELECT rating_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are followed by the user with ID 28539549?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 28539549"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list titled 'Alfred Hitchcock - ranked' made by the user '89749909'? ",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id=(SELECT user_id FROM lists_users WHERE list_id=(SELECT list_id FROM lists WHERE list_title='Alfred Hitchcock - ranked') AND user_id=89749909)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the 'Obejrzane' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists) AND list_title = 'Obejrzane'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies directed by Michael Rubbo?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Michael Rubbo' ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 200360?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 200360"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title with the movie title 'Track the Man Down'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title='Track the Man Down')))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has 55 movies in it?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 55"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 Chinese movies in the lists database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 3 AND list_title LIKE '%Chinese%' LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 3887?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 3887"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 20394?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 20394"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 231032?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 231032"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies ORDER BY movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has a rating of 3?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 174830?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 174830"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the ratings table?",
    "evidence": "",
    "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",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies has user '34367433' created?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 34367433"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists that are created by users with a trial subscription?",
    "evidence": "",
    "SQL": "SELECT L.list_title, L.list_id FROM lists L JOIN lists_users LU ON L.user_id = LU.user_id JOIN ratings_users RU ON LU.user_id = RU.user_id WHERE RU.user_trialist = 1 GROUP BY L.list_title, L.list_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the top 10 movie list created by a user with no payment method?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method = 0)) AND list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has the highest rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by the user with user_id 63710593?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 63710593)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is most popular among the users who have a subscription?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings_users.user_subscriber = 1 GROUP BY movie_title ORDER BY COUNT(ratings.rating_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 lists with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title, list_followers FROM lists ORDER BY list_followers DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 179711?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 179711"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 92751?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 92751"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 145476?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 145476"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have a payment method and have rated a movie?",
    "evidence": "",
    "SQL": "SELECT user_id, user_avatar_image_url, user_cover_image_url FROM ratings_users WHERE user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have followed a list with title 'Films in 2014'? ",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE list_title='Films in 2014')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers for all lists in the database?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies that are most popular among users who have a subscription?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE lists_users.user_subscriber = 1 ORDER BY ratings.rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the lowest rating score in the ratings table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MIN(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies rated by the users who have a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(r.rating_id) AS count FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id INNER JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 1 GROUP BY m.movie_title ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies has the user with ID 17893708 rated and what are the ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM ratings r INNER JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_id = 17893708"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated 4 stars by a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 1 AND r.rating_score = 4"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the number of followers of the list 'quarentine friends club'?",
    "evidence": "",
    "SQL": "SELECT list_followers FROM lists WHERE list_title = 'quarentine friends club'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Mansur Madavi, if there is any?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Mansur Madavi'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 35367?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 35367"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies that have been rated by users in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) AS count FROM ratings r JOIN movies m ON r.movie_id = m.movie_id JOIN lists_users lu ON r.user_id = lu.user_id GROUP BY m.movie_title ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 154051?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 154051"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have updated their lists within the last year?",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists_users WHERE list_update_date_utc >= date('now','-1 year') ORDER BY user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies contains 'Andrei Rublev' as a movie?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies WHERE movie_title = 'Andrei Rublev')))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies listed by user with ID 26114821?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_id = 26114821"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that the user with the highest number of followers has rated?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists AS l JOIN lists_users AS lu ON l.list_id = lu.list_id JOIN ratings AS r ON lu.user_id = r.user_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in the year 1945?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1945 ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 172071?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 172071"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 Chinese films in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE '%Chinese Films%' ORDER BY list_movie_number LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the Chinese Fims list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists INNER JOIN movies ON lists.list_id = movies.movie_id WHERE list_title = 'Chinese Fims' LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 148444?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 148444"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the highest popularity that are directed by Michael Scott?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE director_name = 'Michael Scott' ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with ID 95960 in the list with ID 161212?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 161212 AND list_movie_number = (SELECT movie_id FROM movies WHERE movie_id = 95960)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the Films of 2012, Ranked list?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings INNER JOIN lists ON lists.list_id = ratings.movie_id WHERE lists.list_title = 'Films of 2012, Ranked'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the total number of movies in the database?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies that have a rating of at least 4 from users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) AS count FROM ratings r INNER JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score >= 4 GROUP BY m.movie_title ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 romantic movies that a user with a payment method has rated?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists INNER JOIN lists_users ON lists.list_id = lists_users.list_id INNER JOIN ratings_users ON lists_users.user_id = ratings_users.user_id WHERE ratings_users.user_has_payment_method = 1 AND list_movie_number = 10"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies were released in 2008 and have a rating of 3?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2008 AND EXISTS (SELECT 1 FROM ratings WHERE rating_score = 3 AND ratings.movie_id = movies.movie_id)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by the user with the ID 18444794?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 18444794"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 15358?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 15358"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies with highest rating from top 5 Sofia Coppola lists?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN ratings r ON lu.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE l.list_title = 'TOP 5 SOFIA COPPOLA' ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among users?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies of all time, ordered by their number of followers on Mubi?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, l.list_followers FROM movies m, lists l WHERE m.movie_id = l.list_id ORDER BY l.list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by the user with ID 72139683?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 72139683"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that is followed by only 1 user?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with a list of followers 0 in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the lowest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MIN(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that were released in the year 2016?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2016"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 58213?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 58213"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that Sundance 2011 movie is part of?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_title = 'Sundance 2011'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a rating score of at least 2 in the list of good movies created by the user 9928018?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies AS m, ratings AS r, lists AS l, lists_users AS lu WHERE m.movie_id = r.movie_id AND r.rating_id = r.rating_id AND l.list_id = lu.list_id AND lu.user_id = 9928018 AND r.rating_score >= 2 AND l.list_title = 'A List of good movies'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 111583?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 111583"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list titled 'Seen in 2014'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 94798"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the highest rated movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the director of the movie Darang?",
    "evidence": "",
    "SQL": "SELECT director_name FROM movies WHERE movie_id = '56122'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID `164041`?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 164041"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'From Miyamoto to You' and what is its release year?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_id = 240732"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 138801?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 138801"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the database?",
    "evidence": "",
    "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",
    "question": "What is the list title of the list with id 114077?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 114077"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have more than 1 follower?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among all movies in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that contains the movie Whining Low?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM movies WHERE movie_id = 168781))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the popularity of the movie 'Denkbilder'?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE movie_title = 'Denkbilder'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated 5 by user with ID 73281768?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 5 AND ratings.user_id = 73281768"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies listed by user 36398544?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 36398544) ORDER BY rating_score DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the 'Highrise' movie?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Highrise')"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie was added to a list titled 'nice' by a subscriber?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM movies M, lists L, lists_users U WHERE M.movie_id = L.list_id AND L.user_id = U.user_id AND U.user_subscriber = 1 AND L.list_title = 'nice'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have the movie 'Plan for Destruction'?",
    "evidence": "",
    "SQL": "SELECT L.list_id, L.list_title FROM lists L INNER JOIN lists_users LU ON L.list_id = LU.list_id WHERE L.list_movie_number = (SELECT M.movie_id FROM movies M WHERE M.movie_title = 'Plan for Destruction')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user 43629833?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 43629833"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies that were released in 1938 and have a popularity score of 2?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1938 AND movie_popularity = 2 LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most anticipated movie in 2020?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title LIKE '%2020%' ORDER BY list_movie_number DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the top 10 list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'Top 10')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the release year 2000 and popularity 0?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2000 AND movie_popularity = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists has a user with id 22336946 created?",
    "evidence": "",
    "SQL": "SELECT list_id, list_title FROM lists WHERE user_id = 22336946"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies rated by a user who has both a trial and a paid subscription?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM movies, ratings, ratings_users WHERE ratings.user_id = ratings_users.user_id AND ratings_users.user_trialist = 1 AND ratings_users.user_has_payment_method = 1 ORDER BY rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT MIN(list_id) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists with movie number greater than 8 that have a title?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number > 8 AND list_title IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with list ID 111341?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 111341"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with user ID 72714472 and list ID 127384?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 72714472 AND list_id = 127384"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 3 movies with the most ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY COUNT(rating_id) DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists has user 92735397 created?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists_users WHERE user_id = 92735397"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list contains the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 24540?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 24540"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists of movies with Christianity as their theme?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = (SELECT movie_id FROM movies WHERE movie_title_language = 'en' AND movie_title LIKE '%Christianity%') GROUP BY list_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the release year 2004?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '2004'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top-rated movies by a user with the first name Perri?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM ratings r, lists_users lu, lists l, movies m WHERE r.user_id = lu.user_id AND lu.list_id = l.list_id AND l.user_id = (SELECT user_id FROM lists_users WHERE director_name = 'Perri Peltz') AND r.movie_id = m.movie_id ORDER BY r.rating_score DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the movie number 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 10 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created on December 6, 2009?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_creation_timestamp_utc = '2009-12-06 02:24:59'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 42479?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 42479"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are in the movie 'The Nevers'?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN ratings_users ru ON l.user_id = ru.user_id WHERE ru.user_id IS NOT NULL AND l.list_movie_number = (SELECT m.movie_id FROM movies m WHERE m.movie_title = 'The Nevers') AND ru.user_eligible_for_trial = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies that have been watched by a user with the ID 82157876?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id=82157876"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists contains the movie 'School Life'?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_id IN (SELECT r.user_id FROM ratings r WHERE r.movie_id = 234725)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the list with the user_id of 64024836?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 64024836"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 28405?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 28405"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the ID 149956?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 149956"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies rated by a user who has subscribed to our service?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1) ORDER BY rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by a user with a specific ID, where the user is a subscriber?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by user with ID 66745516?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 66745516"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first heist film on the list of 'Heist films'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 150378 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers in the list with ID 12860?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 12860 AND list_followers = (SELECT MAX(list_followers) FROM lists WHERE list_id = 12860)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular film of the 2000s according to users on the movie list platform?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_title = m.movie_title WHERE l.list_update_timestamp_utc LIKE '%2000%' ORDER BY l.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated 3 by the user with ID 57530025?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.user_id = 57530025 AND ratings.rating_score = 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 195778?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 195778"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are followed by user 6729386?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 6729386)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id WHERE lists.list_followers > 0 GROUP BY lists.list_id ORDER BY lists.list_followers DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user 30584904?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 30584904"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie that was released in the year 1993 and has a popularity score of 11?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '1993' AND movie_popularity = '11'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the 2010s?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2010 AND movie_popularity = (SELECT MAX(movie_popularity) FROM movies WHERE movie_release_year = 2010)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 109319?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 109319"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Tom Berna?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Tom Berna'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user 47766894?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = (SELECT user_id FROM lists_users WHERE user_id = 47766894) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user `18570305`?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = (SELECT user_id FROM lists_users WHERE user_id = 18570305)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by users who are both trialists and subscribers?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.user_id IN (SELECT user_id FROM ratings_users WHERE user_trialist = 1 AND user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 104937?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 104937"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list is the longest?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT MAX(list_id) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies that a trialist has rated in the list 'Seen in 2014'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.list_id = 94798 AND lu.user_trialist = 1 LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 116527?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 116527"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the 'Favorite Indie Dramas' list?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r JOIN lists_users lu ON r.user_id = lu.user_id JOIN lists l ON lu.list_id = l.list_id WHERE l.list_title = 'Favorite Indie Dramas'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top-rated movies by users who have made a payment method?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings, ratings_users WHERE movies.movie_id = ratings.movie_id AND ratings.user_id = ratings_users.user_id AND ratings.user_has_payment_method = 1 ORDER BY rating_score DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers among the lists in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(list_id) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies of 2013 that are popular and have been rated by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER JOIN lists l ON m.movie_id = l.list_id WHERE l.list_title = 'Top 10 of 2013' AND m.movie_popularity > 60 ORDER BY m.movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the total number of ratings given by users who are subscribers in the year 2018?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM ratings r JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 1 AND strftime('%Y', r.rating_timestamp_utc) = '2018'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies that James Orr has directed?",
    "evidence": "",
    "SQL": "SELECT movie_title, COUNT(*) as popularity FROM movies WHERE director_id = '36172' GROUP BY movie_title ORDER BY popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 71092?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 71092"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has a rating of 5 out of 5 by a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5 AND user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies with more than 10 followers on the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r JOIN lists l ON r.user_id = l.user_id WHERE l.list_followers > 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 948 and who created it?",
    "evidence": "",
    "SQL": "SELECT list_title, user_id FROM lists WHERE list_id = 948"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have a payment method and have rated a movie?",
    "evidence": "",
    "SQL": "SELECT user_id FROM ratings_users WHERE user_has_payment_method=1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE movies.movie_id = ratings.movie_id AND rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 81380?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 81380"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 rated movies listed by user 81211256?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM ratings r, movies m WHERE r.user_id = 81211256 AND r.movie_id = m.movie_id ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies directed by Dino Risi?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE director_name = 'Dino Risi' ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that was created on January 27, 2011?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_creation_timestamp_utc LIKE '%2011-01-27%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists that user 40349689 has followed?",
    "evidence": "",
    "SQL": "SELECT list_title, list_id FROM lists WHERE user_id = '40349689'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list named 'Films Watched 2018'?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE lists.list_id = 158964 AND lists.list_title = 'Films Watched 2018' AND movies.movie_id = lists.list_movie_number"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have the movie 'Daughter Rite' added?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_id NOT IN (SELECT user_id FROM ratings WHERE movie_id = 22088)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the 'ToWatch' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'ToWatch') LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list has the fewest followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MIN(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the lists with less than 11 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number < 11"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the popularity rating of the movie `Vice`?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE movie_title = 'Vice'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 67102?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 67102"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the worst rated movie in the 'Bad comedies I really enjoy' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists_users WHERE user_id = 42061612 ORDER BY (SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM lists WHERE list_id = list_id)) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the movie directed by Corey Surge and released in 2009?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2009 AND director_name = 'Corey Surge'"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM ratings r, movies m WHERE r.user_subscriber = 1 AND r.movie_id = m.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers on the list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists LEFT JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that are rated 5 and are from 2014?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = 5 AND m.movie_release_year = 2014"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that received a 5-star rating from a user?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does user 70296281 follow?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 70296281"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 25881?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 25881"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a rating of 5 from users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 5 AND ratings.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Nicola Zavaglia?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Nicola Zavaglia'"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list with a title has a movie number of 20?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 20"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movie 'Christmas'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Christmas')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 227046?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 227046"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have a rating score of 4?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = 4"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity from the list Cathode Ray Mission?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'Cathode Ray Mission') ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies on the E-N-E-R-O list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'e n e r o') ORDER BY movie_popularity DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the movie with the release year 1986?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1986"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 209174?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 209174"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers in the list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among the users who created a list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists_users, lists WHERE movies.movie_id IN (SELECT movie_id FROM lists WHERE list_id = lists_users.list_id) AND lists_users.user_id IN (SELECT user_id FROM lists WHERE list_id = lists_users.list_id) GROUP BY movie_title ORDER BY (SELECT SUM(list_followers) FROM lists WHERE list_id = lists_users.list_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by user '50088628'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_id = 50088628"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 171306?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 171306"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 124629?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 124629"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 103383?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 103383"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have been updated by the user with the id 19512381?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 19512381 AND list_update_timestamp_utc IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the animation movie in list 14775?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 14775"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 46511?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 46511"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in the Crime/Drama list with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE lists_users.list_id = 155900 AND ratings.rating_score > 4 ORDER BY ratings.rating_score DESC LIMIT 3)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 25376?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 25376"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the list with ID 104690 that has 5 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 104690"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers on the list 'Truly, madly, deeply in love'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_title = 'Truly, madly, deeply in love')) AND list_followers = (SELECT MAX(list_followers) FROM lists WHERE list_title = 'Truly, madly, deeply in love') ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the lists that the user with ID 38919580 has followed?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 38919580 AND list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has been rated with a score of 4 by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score = 4 AND r.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has been given a rating score of 1 by a user who is a trialist?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = 1 AND user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the 'Mickey's Revue' list?",
    "evidence": "",
    "SQL": "SELECT AVG(r.rating_score) FROM ratings r, lists_users lu, lists l WHERE r.user_id = lu.user_id AND lu.list_id = l.list_id AND l.list_title = 'Mickey''s Revue'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have more than 1 follower?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie was the first movie to be listed by the user with user_id 61878318?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE lists.user_id = 61878318 AND lists.list_id = (SELECT list_id FROM lists WHERE list_id = (SELECT MIN(list_id) FROM lists WHERE user_id = 61878318))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'With You'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 70142"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the movie with movie_id 42587?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 42587"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies has been added to the list 'Almost Favorites' by user with ID '31443035'?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON lu.user_id = 31443035 AND m.movie_id = l.list_id WHERE lu.user_id = 31443035 AND l.list_title = 'Almost Favorites'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies rated by a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE lists_users.user_subscriber = 1 GROUP BY movie_title ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists created by the user with the user ID 11726458?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 11726458"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'The Story of Rebecca'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 130285"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top rated movies by 'Du\u0161an Makavejev'?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE director_id = '5325' AND movie_popularity = '1' ORDER BY movie_popularity DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 rated movies in the 'Gunbuster: The Movie' genre?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_title_language = 'en' AND movie_popularity = 1 ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 167578?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 167578"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating with a critic?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.critic != 'None' ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the least number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MIN(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'They All Laughed'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 19996"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies listed by a user who is not a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists, lists_users WHERE movies.movie_id = lists.list_movie_number AND lists.list_id = lists_users.list_id AND lists_users.user_trialist = 0 AND lists_users.user_subscriber = 0 LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has the user with the user_id 98642129 rated?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id = 98642129)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers on the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists has the user 58353559 been following?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 58353559"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most followed lists by critics in the 'Third Horizon: Caribbean Films' list?",
    "evidence": "",
    "SQL": "SELECT l.list_title, COUNT(r.rating_id) AS critics_followers FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id JOIN ratings r ON lu.user_id = r.user_id WHERE l.list_title = 'Third Horizon: Caribbean Films' GROUP BY l.list_title ORDER BY critics_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies directed by Ang Lee in the database?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name LIKE '%Ang Lee%')"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does the user with ID 18570305 follow?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE user_id = 18570305"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies directed by Jean Stelli?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.director_name = 'Jean Stelli'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 81002?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 81002"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Jesse Baget?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Jesse Baget'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie on the list with the title 'WANDERING'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE user_id = (SELECT user_id FROM lists WHERE user_id = 26770034 AND list_title = 'WANDERING') ORDER BY rating_timestamp_utc LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies from 2018 have been rated by at least one user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id WHERE m.movie_release_year = 2018 AND ru.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have the user with id 34294231 followed?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l, lists_users lu WHERE lu.user_id = 34294231 AND lu.list_id = l.list_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list titled 'Ver'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 41787"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie by a director who has worked on multiple lists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists_users ON movies.director_id = lists_users.user_id GROUP BY movie_title ORDER BY COUNT(lists_users.user_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies directed by Piro Milkani in the list 'The Sadness of Mrs. Snajdrova'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name = 'Piro Milkani') AND user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE list_title = 'The Sadness of Mrs. Snajdrova'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest popularity on MUBI?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie was rated 4 by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, ratings r, ratings_users ru WHERE r.rating_score = 4 AND r.user_id = ru.user_id AND ru.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have been added to the 'THESE I'VE SEEN, OCT 2011' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 36219"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists GROUP BY list_id ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies that have been most popular according to their ratings?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings ORDER BY rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list has the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has 12 movies and is followed by 0 users?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 12 AND list_followers = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'Dik Trom'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 139515"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies do users who are subscribers have?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists) "
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among the ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the maximum number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity score?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies rated by a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN lists_users lu ON r.user_id = lu.user_id JOIN lists ls ON lu.list_id = ls.list_id JOIN movies m ON r.movie_id = m.movie_id WHERE lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the popularity of the movie Borderline?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE movie_title = 'Borderline'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies in the list 'David Hemmings' created by user '66100020'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_title = 'David Hemmings' AND lists.user_id = 66100020"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists GROUP BY list_id ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 lists created by the user with user id 62256786?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 62256786 ORDER BY list_id LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 80264?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 80264"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the horror movies released in the years 2010 onwards that have a rating score of 5?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE '%Horror films 2010-onwards%' AND list_movie_number > 2010 AND EXISTS (SELECT 1 FROM ratings WHERE ratings.movie_id = lists.list_id AND ratings.rating_score = 5) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 179998?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 179998"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers on a list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the first list associated with user with ID 95787253?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 95787253 LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 118263?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 118263"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has been rated 5 by a user who has a subscription?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = 5 AND ratings.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the list with the ID 52193?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 52193"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movie 'Ohne dich'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Ohne dich')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists that have more than 5 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies that the user with user_id '79854948' has rated with a score of 5?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_image_url FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_id = '79854948' AND r.rating_score = 5 ORDER BY r.rating_timestamp_utc DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the 'lists' database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the names of the top 5 movies by David Mart\u00edn Porras, the director?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_id = '566504' ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does user 76046427 follow?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE user_id = 76046427"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 rated movies of the year 1970?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE movie_release_year = 1970 ORDER BY rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the list of movies to be watched?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE lists.list_id = movies.movie_id AND lists.list_title = 'to watch'"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie is a part of the list titled 'Nouvelle Vague'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_id = 185956)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies in a list titled 'Altiplano' have a rating score of 5?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN ratings r ON lu.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE l.list_title = 'Altiplano' AND r.rating_score = 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of all movies with more than 0 followers?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings INNER JOIN lists ON ratings.movie_id = lists.list_id WHERE lists.list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie added to a 2019 list by user 14722626?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 14722626 AND list_title = '2019' AND list_id = (SELECT list_id FROM lists WHERE list_title = '2019' ORDER BY list_creation_timestamp_utc LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 94425?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 94425"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 2 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 2"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the total number of movies in the database that have a title containing the word 'Tree'?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM movies WHERE movie_title LIKE '%Tree%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 115465?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 115465"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the movie released in 1941?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = (SELECT movie_release_year FROM movies WHERE movie_release_year = 1941) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list contains the movie 'The South of a Passion'?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_title LIKE '%The South of a Passion%'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 77236?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 77236"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are liked by a user who is a subscriber and has a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id INNER JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 1 AND ru.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among all movies in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies in the database have a popularity rating of 2 and were released in the year 2013?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_popularity = 2 AND movie_release_year = 2013"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has a title of 'I dur och skur'?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_title = 'I dur och skur'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 248636?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 248636"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title that is the most liked by users?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY (SELECT COUNT(*) FROM ratings WHERE ratings.movie_id=movies.movie_id AND ratings.rating_score>4) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by user 66712654?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 66712654"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the highest popularity rated by a user who has a paid subscription?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method = 1)) ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that a user with ID 31352825 rated?",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_id = 31352825"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users are subscribed and eligible for a trial?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings_users WHERE user_subscriber=1 AND user_eligible_for_trial=1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have a title that starts with 'best'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE 'best%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Jonathan Glazer and released in 2010?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2010 AND director_name = 'Jonathan Glazer'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists that the user with ID 8847792 follows?",
    "evidence": "",
    "SQL": "SELECT l.* FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_id = 8847792"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the popularity score of a movie directed by Rainer Kohlberger?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE director_name = 'Rainer Kohlberger'"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie is rated 3 by user with id 41511729?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score = 3 AND r.user_id = 41511729"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the 'Most Favorite Films' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'Most Favorite Films')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list with ID 118427?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 118427 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by users who are not subscribers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m LEFT JOIN ratings r ON m.movie_id = r.movie_id LEFT JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 0 AND r.rating_id IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies were rated 4 or higher by the same user who created the list 'The Films of Stanley Kubrick'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l, ratings r, movies m WHERE l.user_id = r.user_id AND l.list_title = 'The Films of Stanley Kubrick' AND r.rating_score >= 4 AND l.list_id = m.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the list 'Quality Horror'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies, lists_users WHERE lists.list_id = lists_users.list_id AND lists_users.list_id = 50621 AND movies.movie_id = lists.list_movie_number AND movies.movie_popularity > 0 GROUP BY movie_title ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most popular rating?",
    "evidence": "",
    "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",
    "question": "What is the popularity of the movie with the title 'None'?",
    "evidence": "",
    "SQL": "SELECT movie_popularity FROM movies WHERE movie_title = 'None'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the 'watch again' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 130490 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of the movies in the 'Watched 2018' list?",
    "evidence": "",
    "SQL": "SELECT AVG(movies.movie_popularity) FROM movies, lists WHERE lists.list_title = 'Watched 2018' AND lists.list_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the most followed list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with a release year of 1940?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 1940"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the first movie in the list 'Favorite Movies 2010-2019'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE user_id = 84640947 ORDER BY list_creation_timestamp_utc LIMIT 1) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 175128?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 175128"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list titled `Long take cinema`?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title = 'Long take cinema'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists that have at least 1 follower?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "Which Steven Soderbergh movies are in the most lists?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists, movies WHERE lists.list_title = movies.movie_title AND lists.list_title LIKE '%Steven Soderbergh%' GROUP BY list_title ORDER BY COUNT(*) DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do users with a payment method follow?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie with the highest rating score in the given database?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM ratings, movies WHERE ratings.movie_id = movies.movie_id AND rating_score IN (SELECT MAX(rating_score) FROM ratings) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers for all lists in the database?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the movie 'Th\u00e9r\u00e8se Raquin'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM movies WHERE movie_id = 2673)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the director of the movie 'Home from the Hill'?",
    "evidence": "",
    "SQL": "SELECT director_name FROM movies WHERE movie_id = 29782"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies has user `76046427` rated?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_id = 76046427"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies which are in the lists created by the user with ID 58277754?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 58277754"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists that have more than 0 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) AND movies.movie_id = ratings.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'Midnight Ramble'? ",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = '231435'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the 10th watchlist in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_id LIMIT 10) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies with a rating score of 4 or higher in the year 2002?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2002 AND movie_popularity > 0 ORDER BY movie_popularity DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies that have been followed by a user with a paid subscription?",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m LEFT JOIN ratings r ON m.movie_id = r.movie_id LEFT JOIN lists_users lu ON r.user_id = lu.user_id AND lu.user_subscriber = 1 GROUP BY m.movie_id ORDER BY COUNT(lu.user_id) DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the list '\u2610 Year N\u00ba1 \u2014 2012'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id JOIN lists ON lists_users.list_id = lists.list_id WHERE lists.list_title = '\u2610 Year N\u00ba1 \u2014 2012'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 16 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 16"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 106689?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 106689"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_id, movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 films directed by Nikolai Dostal?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name='Nikolai Dostal' ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by user with ID 53258956?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 53258956"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies in a list that the user 57220534 is following?",
    "evidence": "",
    "SQL": "SELECT AVG(movie_popularity) FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.user_id = 57220534"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest follower count?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been added to the list 'Films watched on mubi' in the last year?",
    "evidence": "",
    "SQL": "SELECT movie_title, list_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_title = 'Films watched on mubi' AND lists.list_update_timestamp_utc > DATE('now', '-1 year')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 152981?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 152981"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 16850?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 16850"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers of the lists that the user with user_id 97384689 has created?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id=97384689)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are managed by the user with the ID 35100181?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 35100181)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 3 movies in a list by user 98937960?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 98937960 ORDER BY list_movie_number LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) AND movies.movie_id = ratings.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title for the list titled '2012'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 40786"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the classic adaptation movie with 20 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 20"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that was released in the year 2008 and has a popularity score of 8?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2008 AND movie_popularity = 8"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 166913?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 166913"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies listed in the 'Ranking Stanley Kubrick' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title LIKE '%Ranking Stanley Kubrick%' AND list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in a user's list?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id JOIN lists ON lists_users.list_id = lists.list_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 108576?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 108576"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has a popularity rating of 0?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 13639?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 13639"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 251533?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 251533"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 128044?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 128044"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 50042?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 50042"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has the lowest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MIN(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that the user with id 66660676 is following?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 66660676 AND list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 203402?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 203402"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 253229?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 253229"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the details of the lists that have been created by user 41457383?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 41457383"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the 'to watch' list of user with id 49187969?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 49187969"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists include 'The Mongols'?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_title NOT IN (SELECT list_title FROM lists WHERE list_movie_number != 0)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in the 'Gems of Foreign Cinema' list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON lu.user_id = 41207803 WHERE l.list_id = 82206 ORDER BY m.movie_release_year DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that have been added to 'Kosmorama 2012' list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m LEFT JOIN lists_users lu ON m.movie_id = lu.list_id WHERE lu.list_id = 45026"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies does a user with the ID 76614369 follow?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 76614369"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 14652?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 14652"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with id 10801?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 10801"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings) ORDER BY rating_timestamp_utc DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Issa Salim Hamed Al Subhi?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_id = '331587'"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie title is associated with the movie_id 50881?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 50881"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 lists with the most followers on Abel Ferrara?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title = 'Abel Ferrara' ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been added to the list 'Holding out for a hero'?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists INNER JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_title = 'Holding out for a hero'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the id 76049?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 76049"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by the user with ID 32878345?",
    "evidence": "",
    "SQL": "SELECT list_title, list_update_timestamp_utc FROM lists WHERE user_id = 32878345"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has 1 follower?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists that have been created by user with user ID 18786817?",
    "evidence": "",
    "SQL": "SELECT list_id, list_title FROM lists WHERE user_id IN (SELECT list_id FROM lists_users WHERE user_id = 18786817)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the Japanese list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 14818581 AND list_id = 12321"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have created more than one list and also have a subscription?",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists_users GROUP BY user_id HAVING COUNT(*) > 1 AND user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies liked by users who have a subscription to the service?",
    "evidence": "",
    "SQL": "SELECT M.movie_title, COUNT(R.rating_id) as rating_count FROM ratings R JOIN lists_users LU ON R.user_id = LU.user_id JOIN lists L ON LU.list_id = L.list_id JOIN movies M ON R.movie_id = M.movie_id WHERE LU.user_subscriber = 1 GROUP BY M.movie_title ORDER BY rating_count DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie has the highest rating?",
    "evidence": "",
    "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",
    "question": "What is the title of the list with the least number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MIN(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(list_id) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies in the list '2014'?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM lists JOIN lists_users ON lists.user_id = lists_users.user_id JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_title = '2014' ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among the users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM movies M, ratings R, ratings_users U WHERE M.movie_id = R.movie_id AND R.user_id = U.user_id AND U.user_subscriber = 1 ORDER BY R.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movie 'Gary of the Pacific' from a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'Gary of the Pacific') AND user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are subscribed by the user with the ID 40349689?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_id = 40349689 AND lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 261974?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 261974"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY AVG(rating_score) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 22816?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 22816"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies directed by Ho Yim?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_id = '146227'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers of Madcap: Preston Sturges lists?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_title = 'Madcap: Preston Sturges'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists that the user with ID 35343706 is following?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id WHERE lists_users.user_id = 35343706"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of a movie that has a director named Nathanael Carton?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings r INNER JOIN movies m ON r.movie_id = m.movie_id WHERE m.director_name = 'Nathanael Carton'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the list that has the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(list_id) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists that 38346386 created?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = (SELECT user_id FROM lists_users WHERE user_id = 38346386)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers of all lists?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the 'Romai' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'Romai') LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 178411?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 178411"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of lists with more than 2 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 2"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top rated movies in the South Korea list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN lists l ON m.movie_id NOT IN (SELECT list_movie_number FROM lists WHERE list_title != 'South Korea') WHERE m.movie_popularity IN (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the top 5 most popular movies based on ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id ORDER BY ratings.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 209466?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 209466"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for all the movies in the list 'List to See Asian Movies'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE lists_users.list_id = (SELECT list_id FROM lists WHERE list_title = 'List to See Asian Movies')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users GROUP BY user_id ORDER BY COUNT(*) DESC LIMIT 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the id 224190?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 224190"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the most followers among the lists of user 89047670?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE user_id = 89047670 ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie released in the year 1960 and is popular?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '1960' AND movie_popularity = '2'"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie title is associated with the user id 22542853?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id = 22542853)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 249655?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 249655"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most popular rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first list owned by the user with ID 35153465?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 35153465) ORDER BY list_creation_timestamp_utc LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies in the 'watched 2013' list have been rated by a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.* FROM lists l INNER JOIN lists_users lu ON l.list_id = lu.list_id INNER JOIN ratings r ON lu.user_id = r.user_id INNER JOIN movies m ON r.movie_id = m.movie_id WHERE l.list_title = 'watched 2013' AND lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the names of movies directed by Kim Ki-duk?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Kim Ki-duk'"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating among all movies rated by users with a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_has_payment_method = 1 ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 152761?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 152761"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list with the ID 76049?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 76049 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 258560?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 258560"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie with a rating score of 5?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 5) ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the total number of users who have rated 'The Good Waiter'?",
    "evidence": "",
    "SQL": "SELECT COUNT(DISTINCT(user_id)) FROM ratings WHERE movie_id = 237058"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in January 2011's list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'January 2011') LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in the 'To watch' list?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE lists.list_id = movies.movie_id AND lists.list_title = 'To watch' ORDER BY list_movie_number LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 48 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 48"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for the movie 'Continental Circus'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Continental Circus')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 'Ceasefire'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 91038"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rated by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id INNER JOIN ratings_users ON ratings.user_id = ratings_users.user_id WHERE ratings_users.user_has_payment_method = 1 ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists that the user with user_id `35343706` follows?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists_users WHERE user_id = 35343706"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that the user with ID 46076803 created?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 46076803)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings AS r INNER JOIN ratings_users AS ru ON r.user_id = ru.user_id INNER JOIN lists_users AS lu ON r.user_id = lu.user_id AND ru.user_has_payment_method = 1 INNER JOIN movies AS m ON r.movie_id = m.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular films in the 'Films' list by user '15586054'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 15586054 AND list_id IN (SELECT list_id FROM lists_users WHERE user_id = 15586054) ORDER BY list_movie_number DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the list titled 'Barbet Schroeder'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r JOIN lists l ON r.movie_id = l.list_id WHERE l.list_title = 'Barbet Schroeder'"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists of movies created by users who are subscribers have more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers > 5 AND EXISTS (SELECT 1 FROM lists_users WHERE lists_users.list_id = lists.list_id AND lists_users.user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie titles were rated by users who have a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_subscriber = 1 GROUP BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list created by a user with ID 83953309?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 83953309"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of all movies in 'The Nortull Gang' list?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'The Nortull Gang')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in the 'Best of 2014 (2013)' list?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM lists L JOIN movies M ON L.list_id = M.movie_id WHERE L.list_title = 'Best of 2014 (2013)' ORDER BY M.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have at least one follower?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Penelope Spheeris?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Penelope Spheeris'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_id = (SELECT user_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does user 88425213 follow?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 88425213"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists_users ON lists_users.user_id = 68702873 AND lists_users.list_id = 182951 WHERE movie_id = (SELECT movie_id FROM lists WHERE user_id = 68702873 AND list_id = 182951)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 243179?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 243179"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie among Christopher Nolan's ranked movies?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE lists.list_title = 'Christopher Nolan Ranked' AND lists.list_id = movies.movie_id ORDER BY movies.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 lists by '2014' which have more than 0 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 0 AND list_id IN (SELECT list_id FROM lists WHERE list_title = '2014') ORDER BY list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has a rating score of 3 and is directed by Nicholas Kalikow?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = 3) AND director_name = 'Nicholas Kalikow'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 30793?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 30793"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the list with ID 100128?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 100128"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "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",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists contain at least 18 movies?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number >= 18"
  },
  {
    "db_id": "movie_platform",
    "question": "Which user has rated the movie 'Funny Face' with a score of 4?",
    "evidence": "",
    "SQL": "SELECT user_id FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Funny Face') AND rating_score = 4"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have a rating score of 2?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = 2"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of 'Love 1: Dog' movie by users who have a paid subscription?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Love 1: Dog') AND user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 most popular movies in the database?",
    "evidence": "",
    "SQL": "SELECT DISTINCT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have Pedro Costa as the title?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title = 'Pedro Costa'"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie, directed by Dino Risi, has the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies WHERE director_name = 'Dino Risi')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the popularity score of 0?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 396?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 396"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with 266 movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 266"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the lowest followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MIN(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie with the title 'Block' has the highest popularity among all movies?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_title = 'Block' ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies were added to the list `2016` by user `23229155`?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l, lists_users lu WHERE l.list_id = lu.list_id AND lu.user_id = 23229155 AND l.list_title = '2016'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies in the 'Prisioneros desaparecidos' list?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'TOP TEN [2010]') AND list_movie_number <= 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating among the movies in the list 'CINEMA INDIA'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'CINEMA INDIA') ORDER BY (SELECT rating_score FROM ratings WHERE movie_id = movies.movie_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have at least 2 movies?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_movie_number > 2"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie with a release year of 2004?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = 2004 AND movie_popularity = (SELECT MAX(movie_popularity) FROM movies WHERE movie_release_year = 2004)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies with the title 'Thriller/Horror' in the lists table?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'Thriller/Horror')"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists contain the movie 'Bilby'?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l WHERE l.list_id IN (SELECT lu.list_id FROM lists_users lu WHERE lu.user_id IN (SELECT ru.user_id FROM ratings_users ru WHERE ru.user_id = 6142796)) AND l.list_movie_number IN (SELECT m.movie_id FROM movies m WHERE m.movie_title = 'Bilby')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the movie 'Hide and Seek'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM movies WHERE movie_title = 'Hide and Seek'))"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are in the watchlist of user with ID 46001929?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 46001929"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies rated by users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT DISTINCT m.movie_title, m.movie_release_year, m.movie_image_url FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.user_subscriber = 1 ORDER BY m.movie_release_year"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movie release years for the lists that have the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, COUNT(*) as count FROM lists GROUP BY list_movie_number ORDER BY count DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is a part of the list titled 'Australia'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'Australia')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the name of the director who directed the movie with the release year 1955?",
    "evidence": "",
    "SQL": "SELECT director_name FROM movies WHERE movie_release_year = 1955"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating in the list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE m.movie_id IN (SELECT list_movie_number FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_id = 88298150))) ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 232313?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 232313"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers in the list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_eligible_for_trial = 1)) ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie was rated by a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest user rating?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM ratings, movies WHERE ratings.movie_id = movies.movie_id ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that have the most ratings?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title, COUNT(ratings.rating_id) AS count FROM movies, ratings WHERE movies.movie_id = ratings.movie_id GROUP BY movies.movie_title ORDER BY count DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Yasuhiro Kimura?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Yasuhiro Kimura'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating from the user with ID 97232344?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_id IN (SELECT rating_id FROM ratings WHERE user_id = 97232344 AND rating_score = (SELECT MAX(rating_score) FROM ratings WHERE user_id = 97232344)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies directed by Mitsuru Meike?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings, movies WHERE ratings.movie_id = movies.movie_id AND director_name = 'Mitsuru Meike'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in the branded content short films list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE lists.list_title = 'branded content short films' AND lists.list_id = movies.movie_id LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 55202?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 55202"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movie 'The Cat from Outer Space'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Cat from Outer Space')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the list titled 'open the magic door'?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists INNER JOIN lists_users ON lists.list_id = lists_users.list_id INNER JOIN movies ON lists.list_movie_number = movies.movie_id WHERE lists.list_title = 'open the magic door'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that was released in 2019?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year = '2019'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the ID 137711?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 137711"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie's popularity is 18?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = 18"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 13543?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 13543"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies does user '75598950' have on their list 'Repertory Cinema 2014'?",
    "evidence": "",
    "SQL": "SELECT movies.* FROM lists INNER JOIN lists_users ON lists.list_id = lists_users.list_id INNER JOIN movies ON lists.list_id = movies.movie_id WHERE lists_users.user_id = 75598950 AND lists.list_id = 83359"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the ID 162442 and who created it?",
    "evidence": "",
    "SQL": "SELECT lists.list_title, lists_users.user_id FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id WHERE lists.list_id = 162442"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the documentary in the 'DOCUMENTARIES' list created by the user with ID 98525344?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 98525344 AND list_title = 'DOCUMENTARIES'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does user '98624612' follow?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists_users JOIN lists ON lists_users.list_id = lists.list_id WHERE lists_users.user_id = 98624612"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 40803?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 40803"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that the user with ID 66776915 is following?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 66776915"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for the movie titled 'Ghost Season 2018-2019' in the lists table?",
    "evidence": "",
    "SQL": "SELECT AVG(list_movie_number) FROM lists WHERE list_title = 'Ghost Season 2018-2019'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "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",
    "question": "What is the title of the movie with the highest popularity rating in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 247592?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 247592"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated 5 stars by user 2158312?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = 5 AND user_id = 2158312"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 100128 and which movie is it most popular?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE lists.list_id = 100128 AND lists.list_movie_number = (SELECT MAX(list_movie_number) FROM lists WHERE list_id = 100128)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists GROUP BY list_id ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in 2007 according to the ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies WHERE movie_release_year = 2007 ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with ID 123359?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 123359"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for the movie `The Dragon Ring`?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Dragon Ring')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies in the Little Monster list?",
    "evidence": "",
    "SQL": "SELECT * FROM movies m JOIN lists_users lu ON m.movie_id = lu.user_id AND lu.list_id = (SELECT list_id FROM lists WHERE list_title = '') ORDER BY m.movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 228312?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 228312"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of movies directed by Marilyn Fox?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE m.director_name = 'Marilyn Fox'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movie titles in the list 'Horror' that have been reviewed?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN ratings_users ru ON l.user_id = ru.user_id JOIN ratings r ON ru.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE l.list_title = 'Horror'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are not followed by user with ID 50595801?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l LEFT JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_id = 50595801 AND lu.list_id IS NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for the movie 'Running Springs'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'Running Springs') "
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers of lists in the Beach Party Time? list?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_title = 'Beach Party Time?')"
  },
  {
    "db_id": "movie_platform",
    "question": "What Iranian films are there in the 'IRANIAN FILMS' list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 162238"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of the top 20 Chinese cinema movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title LIKE '%CHINESE CINEMA%' AND list_movie_number = 20"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 136721?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 136721"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie directed by Fay Ann Lee?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Fay Ann Lee'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the ID 65717?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 65717"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the list titled 'Chinese Films'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title = 'Chinese Films'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with id 144853?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 144853"
  },
  {
    "db_id": "movie_platform",
    "question": "What movie was rated 4 stars by user 28906484?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies, ratings WHERE ratings.rating_score = 4 AND ratings.user_id = 28906484"
  }
]