[
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the 'Top-Rated' list that were released after 2010?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.list_movie_number = m.movie_id WHERE lu.user_id IN (SELECT user_id FROM ratings_users ru WHERE ru.user_trialist = 0 AND ru.user_subscriber = 0) AND l.list_title = 'Top-Rated' AND m.movie_release_year > 2010"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the top 5 most popular lists?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers IN (SELECT list_followers FROM lists ORDER BY list_followers DESC LIMIT 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by users named John?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_avatar_image_url LIKE '%John%')"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have created lists that contain the movie with the title 'The Shawshank Redemption'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies WHERE movie_title = 'The Shawshank Redemption'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists created by users who have created lists with at least 5 movies?",
    "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 lists WHERE list_movie_number >= 5))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists of movies in the database where the title contains the word 'Super'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE '%Super%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists created by users with more than 50 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_followers > 50)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is followed by more than 5 users 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_users GROUP BY user_id HAVING COUNT(*) > 5))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in the list with id 5?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE lists.list_id = 5 AND lists.list_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 most popular movies that have been rated by users of the trial plan?",
    "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_trialist = 1 ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT movie_id FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies in the list titled 'My Favorite Movies'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_title = 'My Favorite Movies'"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating in a list with the most followers?",
    "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_followers = (SELECT MAX(l2.list_followers) FROM lists l2) AND r.rating_score = (SELECT MAX(r2.rating_score) FROM ratings r2) ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are rated high by users with a trial 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_trialist = 1 AND r.rating_score > 4 ORDER BY r.rating_score DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the users who are subscribed and have a payment method?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists, lists_users WHERE lists.list_id = lists_users.list_id AND lists_users.user_subscriber = 1 AND lists_users.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of a movie in the 'lists' table with a list title starting with 'The'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title LIKE 'The%')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the 'lists' table with 'list_movie_number' greater than 5?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by user with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists of movies created by the user with user_id = 1?",
    "evidence": "",
    "SQL": "SELECT l.* FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of movies with a release year between 2000 and 2010 that have been rated by at least one user?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_release_year FROM movies WHERE movie_release_year BETWEEN 2000 AND 2010 AND movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id HAVING COUNT(DISTINCT user_id) > 0)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies in the list with the most followers that have been released in the 1990s?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM lists L JOIN movies M ON L.list_id = M.movie_id WHERE L.list_followers = (SELECT MAX(L2.list_followers) FROM lists L2) AND M.movie_release_year >= 1990 AND M.movie_release_year <= 1999"
  },
  {
    "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_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies with more than one rating by different users?",
    "evidence": "",
    "SQL": "SELECT DISTINCT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id GROUP BY m.movie_title HAVING COUNT(DISTINCT r.user_id) > 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have not followed any list?",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists_users WHERE list_id IS NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the first list created by the user with user_id=1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1 ORDER BY list_creation_timestamp_utc LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have the highest average rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS avg_rating FROM ratings r JOIN movies m ON r.movie_id = m.movie_id GROUP BY m.movie_title ORDER BY avg_rating DESC LIMIT 10"
  },
  {
    "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 GROUP BY movie_title ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the movies table?",
    "evidence": "",
    "SQL": "SELECT * FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the top-rated movie by users who have both a trial and a payment method?",
    "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_has_payment_method = 1 ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the highest number of followers?",
    "evidence": "",
    "SQL": "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?",
    "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 is the title of the movie with the highest rating in a list created by a user who has a 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 = 1)) ORDER BY (SELECT rating_score FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_id = (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)))) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies rated by users with a trial subscription?",
    "evidence": "",
    "SQL": "SELECT DISTINCT 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"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that are most popular by lists having more than 100 followers?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies, lists WHERE movies.movie_id = (SELECT movie_id FROM ratings WHERE rating_score > 3) AND lists.list_id IN (SELECT list_id FROM lists_users WHERE list_followers > 100)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of all the movies in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies that have been added to a user's watchlist?",
    "evidence": "",
    "SQL": "SELECT M.movie_title, COUNT(L.list_id) AS popularity FROM lists L JOIN lists_users LU ON L.list_id = LU.list_id JOIN movies M ON L.list_movie_number = M.movie_id GROUP BY M.movie_title ORDER BY popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the list created by user with id 1?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists, lists_users, movies WHERE lists.user_id = lists_users.user_id AND lists.list_id = lists_users.list_id AND lists_users.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest average rating by users in a specific list?",
    "evidence": "",
    "SQL": "SELECT * FROM movies, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.rating_score > (SELECT AVG(rating_score) FROM ratings WHERE 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 ID 1234?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 1234"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in a list that was created by a user who is both a trialist and a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l, lists_users lu, movies m WHERE lu.list_id = l.list_id AND lu.user_id = l.user_id AND lu.user_trialist = 1 AND lu.user_subscriber = 1 AND l.list_movie_number = (SELECT MAX(l2.list_movie_number) FROM lists l2, lists_users lu2, movies m2 WHERE lu2.list_id = l2.list_id AND lu2.user_id = l2.user_id AND lu2.user_trialist = 1 AND lu2.user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that a user with id 1 created a list for?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE user_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are part of the user with ID 1's favorite lists?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists created by users who are also subscribers?",
    "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 are the top 5 most popular movies in the 'lists' table that have been updated recently?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 5) AND list_update_timestamp_utc LIKE '%last 7 days%' ORDER BY list_update_timestamp_utc 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 are all the list titles of lists created by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the list named 'My Favourite Movies'?",
    "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 lists_users WHERE list_title = 'My Favourite Movies')) ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in a user's favorite list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE list_followers > 0))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list of a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists, lists_users WHERE lists.list_id = lists_users.list_id AND lists_users.user_subscriber = 1 ORDER BY lists_users.list_id LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the list of movies?",
    "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)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have more than 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10"
  },
  {
    "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": "Which movies have the highest ratings from users who have not subscribed?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, r.rating_score FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_id IN (SELECT user_id FROM lists_users WHERE user_id NOT 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 highest number of ratings in the 'lists' database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER 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 most popular movie in the list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_id = (SELECT list_id FROM lists ORDER BY lists.list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the lists database?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in a list with the most followers?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title, COUNT(*) AS count 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 GROUP BY l.list_title, m.movie_title ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists include a movie titled 'Inception'?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_movie_number = (SELECT movie_id FROM movies WHERE movie_title = 'Inception')"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have a list with more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_followers > 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have been created by users who have a movie rating?",
    "evidence": "",
    "SQL": "SELECT DISTINCT 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_has_payment_method = 1"
  },
  {
    "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 is the title of the first movie in the list of the user with user_id = 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie among users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(r.rating_id) as count FROM ratings r, lists_users lu, movies m WHERE r.user_id = lu.user_id AND lu.list_id = 1 AND r.movie_id = m.movie_id GROUP BY m.movie_title ORDER BY count DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have created lists with more than 10 movies?",
    "evidence": "",
    "SQL": "SELECT user_id, user_id from lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_movie_number > 10)"
  },
  {
    "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 in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l WHERE l.list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_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 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, that is most popular among subscribers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE user_subscriber = 1 AND rating_score = (SELECT MAX(rating_score) FROM ratings) ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the 'Lists' table where the 'list_title' contains the word 'Best'? ",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE '%Best%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movie titles of the lists created by users who have paid for subscription?",
    "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_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in a list called 'Best 2022 Movies'?",
    "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_title = 'Best 2022 Movies'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that a user has in their lists?",
    "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 lu.user_id = m.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list created by the user with ID 123?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 123 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the names of all movies in the 'list_of_movies' list created by a user with ID '1'?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists_users, lists, movies WHERE lists_users.list_id = lists.list_id AND lists_users.user_id = 1 AND lists.list_movie_number = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of the movies in the lists created by users with a subscription?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings 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 that has been rated by user with ID 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.user_id = 1"
  },
  {
    "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 ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest ratings in the 'lists' database?",
    "evidence": "",
    "SQL": "SELECT movie_title, AVG(rating_score) AS average_rating FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id GROUP BY movie_title ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers in the lists table?",
    "evidence": "",
    "SQL": "SELECT list_movie_number FROM lists GROUP BY list_movie_number ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the number of movies listed in each of the top 5 most followed lists?",
    "evidence": "",
    "SQL": "SELECT l.list_title, COUNT(r.movie_id) AS num_movies FROM lists_users lu INNER JOIN lists l ON lu.list_id = l.list_id INNER JOIN ratings r ON lu.user_id = r.user_id GROUP BY l.list_title ORDER BY l.list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 movies with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS avg_rating FROM movies m JOIN ratings r ON m.movie_id = r.movie_id GROUP BY m.movie_title ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_id = (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies that have been rated by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id GROUP BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies have been created by users who are also directors of movies?",
    "evidence": "",
    "SQL": "SELECT L.list_title FROM lists L, lists_users LU, movies M, ratings R WHERE LU.list_id = L.list_id AND LU.user_id = R.user_id AND M.movie_id = R.movie_id AND LU.user_id = M.director_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular movies in a user's list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_movie_number = movies.movie_id JOIN ratings_users ON lists.user_id = ratings_users.user_id WHERE lists.list_followers > 0 AND ratings_users.user_trialist = 1 ORDER BY lists.list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular lists?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers 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 ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by users who are both subscribers and have a payment method?",
    "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 ru.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by users with the user ID 1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the given 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 lists of movies created by users who are trialists and have payment methods?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l INNER JOIN lists_users lu ON l.user_id = lu.user_id INNER JOIN ratings_users ru ON lu.user_id = ru.user_id WHERE ru.user_trialist = 1 AND ru.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists made by users with a payment method?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN ratings_users ru ON l.user_id = ru.user_id JOIN movies m ON ru.user_id = m.director_id WHERE l.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 are the lists created by users who have subscribed to the service?",
    "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 lists does user with ID 2 have?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE user_id = 2"
  },
  {
    "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_id = (SELECT MAX(rating_id) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies that have been rated by subscribers only?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN ratings_users ru ON r.user_id = ru.user_id JOIN lists_users lu ON ru.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 ru.user_subscriber = 1 GROUP BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by user ID 1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity that is also part of the lists with 'abc' as the list title?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'abc') AND movie_popularity = (SELECT MAX(movie_popularity) FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'abc'))"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have followed a list that contains a movie rated by a critic?",
    "evidence": "",
    "SQL": "SELECT u.list_id, l.list_title, m.movie_title, r.critic FROM lists_users u JOIN lists l ON u.list_id = l.list_id JOIN ratings r ON u.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE r.critic IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 rated movies in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies m, ratings r WHERE r.movie_id = m.movie_id ORDER BY r.rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the 'lists' 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 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 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 1"
  },
  {
    "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)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of lists that have a rating of 4 or higher and belong to a user with a trial subscription?",
    "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_trialist=1) AND list_id IN (SELECT list_id FROM ratings WHERE rating_score >= 4))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating from a user who is a subscriber?",
    "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 r.rating_score = (SELECT MAX(rating_score) FROM ratings r2)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles for the movies with a release year of 2010?",
    "evidence": "",
    "SQL": "SELECT DISTINCT L.list_title FROM lists L, movies M WHERE L.list_movie_number = M.movie_id AND M.movie_release_year = 2010"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number IN (SELECT movie_id 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, ratings WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) AND movies.movie_id = ratings.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists created by users who have payment method and are not trialist?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_has_payment_method = 1 AND user_trialist = 0)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies with a rating more than 4 and from the 2000s?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score > 4 AND m.movie_release_year >= 2000"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of all lists created by users who have paid for a premium subscription?",
    "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_has_payment_method = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list of movies created by 'Director X'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Director X' LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies in the lists that have at least 5 followers?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_followers >= 5) ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of a movie that is part of a list created by a user who has a payment method and has a avatar image?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r JOIN ratings_users ru ON r.user_id = ru.user_id JOIN lists_users lu ON ru.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_has_payment_method = 1 AND lu.user_avatar_image_url IS NOT NULL GROUP BY r.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 are the top 3 movies by popularity 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 are the movie titles in the list with list_id 12345?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_description, list_cover_image_url, list_title FROM lists WHERE list_id = 12345"
  },
  {
    "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 that has the highest popularity in a specific list?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE list_movie_number = movie_id ORDER BY movie_popularity 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_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1) GROUP BY list_id ORDER BY COUNT(list_id) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists created by users who have paid for a subscription and their corresponding user IDs?",
    "evidence": "",
    "SQL": "SELECT user_id, list_id FROM lists_users WHERE user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the 'lists' table sorted by the 'list_movie_number' column?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_movie_number DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the lists table?",
    "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 rated by users in the ratings table, sorted by the rating score?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users) ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are liked by users who also like movie 'The Shawshank Redemption'?",
    "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 r.rating_score > 3 AND ru.user_trialist = 0 AND ru.user_subscriber = 1 AND m.movie_title LIKE '%The Shawshank Redemption%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity score 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 most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists l JOIN movies m ON l.list_movie_number = m.movie_id WHERE l.list_followers = (SELECT MAX(list_followers) FROM lists) AND l.list_movie_number = m.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by users who have purchased a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, ratings r, ratings_users ru WHERE r.user_id = ru.user_id AND ru.user_subscriber = 1 AND m.movie_id = r.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 lists have the most 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 title of the most popular movie in a list that has more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5 ORDER BY list_movie_number DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do users with a specific director have?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists, lists_users, movies WHERE movies.movie_id = lists_users.list_id AND lists_users.user_id = lists.list_id AND movies.director_id = 'Director Name' GROUP BY list_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists made by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists created by a user with id 1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have a rating for the movie with title 'The Shawshank Redemption'?",
    "evidence": "",
    "SQL": "SELECT DISTINCT l.user_id FROM lists_users l JOIN ratings r ON l.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE m.movie_title = 'The Shawshank Redemption'"
  },
  {
    "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 ratings.movie_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) as avg_rating FROM movies m JOIN ratings r ON m.movie_id = r.movie_id GROUP BY m.movie_title ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does user 'user1' have?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 'user1')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by users who have paid for the service?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie 'The Shawshank Redemption' with the highest rating?",
    "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 = 'The Shawshank Redemption') AND rating_score = (SELECT MAX(rating_score) FROM ratings WHERE movie_id = (SELECT movie_id FROM movies WHERE movie_title = 'The Shawshank Redemption'))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies on a user's list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) as count 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 GROUP BY m.movie_title ORDER BY count DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists do Movie X from 2005 belong to?",
    "evidence": "",
    "SQL": "SELECT lists.list_id FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id WHERE lists_users.user_id IN (SELECT user_id FROM ratings_users WHERE user_id = (SELECT user_id FROM movies WHERE movie_title = 'Movie X' AND movie_release_year = 2005))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that a user with the user_id 1 created and have a list_title that starts with the word 'My'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1 AND list_title LIKE 'My%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the list with title 'Some Movie'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS avg_rating FROM ratings JOIN lists ON ratings.movie_id = lists.list_movie_number WHERE lists.list_title = 'Some Movie'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of all lists that have been followed by a subscriber and have at least 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_subscriber = 1 AND list_followers >= 10)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the most followers in the list table?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the list of user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_id = (SELECT user_id FROM lists_users WHERE list_id = (SELECT list_id FROM lists WHERE user_id = 1)) AND movie_id = (SELECT movie_id FROM lists WHERE user_id = 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 movies have been rated by users who have been a subscriber?",
    "evidence": "",
    "SQL": "SELECT DISTINCT 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 ORDER BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest popularity in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists created by a user with id 123?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies that have a critic score greater than or equal to 80 and have been rated by at least 5 people?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score >= 80 GROUP BY m.movie_title, m.movie_release_year HAVING COUNT(r.rating_id) >= 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the list 'My Movie List' and their corresponding ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM lists l, movies m, ratings r WHERE l.list_id = m.movie_id AND l.user_id = r.user_id AND l.list_title = 'My Movie List'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among the movies in the list with ID 1?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN ratings r ON l.list_id = r.movie_id JOIN movies m ON r.movie_id = m.movie_id WHERE l.list_id = 1 AND m.movie_popularity = (SELECT MAX(m2.movie_popularity) FROM movies m2 WHERE m2.movie_id = r.movie_id)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest rating from users?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM ratings, movies WHERE ratings.movie_id = movies.movie_id ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 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 average rating of a movie directed by Steven Spielberg?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE director_name = 'Steven Spielberg'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE list_id IN (SELECT list_id FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies) AND movie_id IN (SELECT list_movie_number FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the 'Top 5 Movies' 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_title = 'Top 5 Movies'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of lists with more than 100 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 100"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in the list that has a title 'My Favorite Movies'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists WHERE movie_id = (SELECT movie_id FROM lists WHERE list_title = 'My Favorite Movies')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies among users who have made a purchase?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(rating_id) as rating_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 JOIN lists_users lu2 ON m.movie_id = lu2.list_id WHERE lu2.user_has_payment_method = 1 GROUP BY m.movie_title ORDER BY rating_count DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id HAVING COUNT(*) > (SELECT AVG(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a rating score greater than 8?",
    "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 > 8"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies that are part of the most popular lists on the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > (SELECT AVG(list_followers) FROM lists) LIMIT 10"
  },
  {
    "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 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 most popular movie in the ratings table, sorted by the number of critic likes?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings INNER JOIN movies ON ratings.movie_id = movies.movie_id WHERE critic_likes = (SELECT MAX(critic_likes) FROM ratings) ORDER BY critic_likes 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 INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are present in a list titled 'Top Movie Picks' created by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l INNER JOIN movies m ON l.list_id = m.movie_id WHERE l.list_title = 'Top Movie Picks' AND l.user_id IN (SELECT user_id FROM lists_users lu WHERE lu.user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies rated by users who are both trialists and subscribers?",
    "evidence": "",
    "SQL": "SELECT * 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) ORDER BY ratings.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the movies in the user's lists that have more than 50 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 HAVING COUNT(list_id) > 50))"
  },
  {
    "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 that the user with user_id 1 has rated?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.user_id = (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE user_id = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of lists with more than 5 followers and more than 100 comments?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5 AND list_comments > 100"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has been rated 9/10 by a user who is a 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.rating_score = 9 AND ratings_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists created by a user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title for the list created by user with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, ratings r WHERE r.movie_id = m.movie_id AND r.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in a particular list?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE lists.list_id = movies.movie_id AND movie_popularity > (SELECT AVG(movie_popularity) FROM movies) LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who have a trial subscription?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_trialist = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movies.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 average rating score of the movies in the 'Top 250' list?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_title = 'Top 250')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies 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, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies added to 'movies' by the user with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(l.list_id) AS num_followers FROM lists l JOIN ratings_users ru ON l.user_id = ru.user_id JOIN movies m ON ru.user_id = m.director_id GROUP BY m.movie_title ORDER BY num_followers DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest average 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 AVG(rating_score) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the movie that has the most ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m, ratings r WHERE r.movie_id = m.movie_id GROUP BY m.movie_title ORDER BY COUNT(r.rating_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies in a given list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_image_url FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.list_id = m.movie_id ORDER BY l.list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the number of movies in the database?",
    "evidence": "",
    "SQL": "SELECT COUNT(DISTINCT movie_id) FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies that have the highest rating?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title, AVG(ratings.rating_score) AS average_rating FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movies.movie_title ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies directed by Martin Scorsese?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name = 'Martin Scorsese')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies by the user with the ID 1?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id = 1 ORDER BY rating_score 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 ratings.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the list with id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 1"
  },
  {
    "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 movie with the highest rating by a trialist?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE ratings.user_trialist = 1 AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings WHERE ratings.user_trialist = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of all movies by users who have subscribed and have a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(r.rating_score) AS average_rating FROM ratings r JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.user_subscriber = 1 AND lu.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is most likely to be watched by users who have a trial subscription and have previously rated a movie?",
    "evidence": "",
    "SQL": "SELECT movies.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_trialist = 1 AND ratings.rating_id IS NOT NULL GROUP BY movies.movie_title ORDER BY COUNT(ratings.rating_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is 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?",
    "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 movies are liked by users who have rated a movie with a score greater than 8?",
    "evidence": "",
    "SQL": "SELECT m.movie_title 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 l.list_movie_number = m.movie_id WHERE r.rating_score > 8"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies in the list titled 'Top Rated Movies'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title='Top Rated Movies' LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the list of the user with ID 123?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title FROM lists l, lists_users lu, movies m WHERE l.list_id = lu.list_id AND lu.user_id = 123 AND l.list_id = m.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the top 5 lists with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers IN (SELECT list_followers FROM lists ORDER BY list_followers DESC LIMIT 5) ORDER BY list_followers DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by a user who is both a subscriber and a trialist?",
    "evidence": "",
    "SQL": "SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1 AND user_trialist = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in a list with the title 'My Favorite Movies'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists, movies WHERE lists.list_title = 'My Favorite Movies' AND lists.list_id = movies.movie_id ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of movies that have been watched by users who are also trialists?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_trialist=1) AND 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 is the list title of the movie with the highest rating?",
    "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_trialist=1) AND list_id IN (SELECT list_id FROM ratings WHERE rating_score=(SELECT MAX(rating_score) FROM ratings)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the most popular movie in the movies table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE list_movie_number = (SELECT MAX(list_movie_number) FROM lists))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies that have a rating of at least 4 out of 5 from users?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score >= 4) ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 rated movies in the last 3 months?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE rating_timestamp_utc > DATE('now', '-3 month') ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the highest followers for movies released in 2015?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies WHERE movie_release_year = 2015) ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 rated movies in the 'action' genre, as rated by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) as average_rating FROM ratings r JOIN movies m ON r.movie_id = m.movie_id JOIN ratings_users ru ON r.user_id = ru.user_id GROUP BY m.movie_title HAVING AVG(r.rating_score) > 3.5 AND m.movie_title_language LIKE '%action%' ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in a list?",
    "evidence": "",
    "SQL": "SELECT list_title, list_movie_number, list_followers 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 on 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 are the titles of the top 5 most popular movies listed by a user?",
    "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 5) AND movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list that was created by user with id 123?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_id IN (SELECT l2.list_id FROM lists_users lu2 JOIN lists l2 ON lu2.list_id = l2.list_id WHERE lu2.user_id = 123) ORDER BY l.list_creation_timestamp_utc ASC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for movies by users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT AVG(r.rating_score) AS average_rating FROM ratings r INNER JOIN ratings_users ru ON r.user_id = ru.user_id INNER JOIN lists_users lu ON ru.user_id = lu.user_id WHERE lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 lists that have the most followers?",
    "evidence": "",
    "SQL": "SELECT l.list_id, l.list_title, COUNT(*) as follower_count FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id GROUP BY l.list_id, l.list_title ORDER BY follower_count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the list with ID 1?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of lists that contain the movie 'The Shawshank Redemption'?",
    "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 IN (SELECT user_id FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'The Shawshank Redemption'))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most recent list with a title that contains the word 'best'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE '%best%' ORDER BY list_update_timestamp_utc DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie titles have been added to at least 5 lists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists inner join movies on lists.list_movie_number = movies.movie_id group by movie_title having count(list_id) > 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 are the top 5 movies with the highest ratings that were released after 2010?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_release_year, rating_score FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE movie_release_year > 2010 ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among subscribers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN ratings_users ON movies.movie_id = ratings_users.user_id WHERE ratings_users.user_subscriber = 1 AND ratings_users.user_has_payment_method = 1 ORDER BY movies.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies that have a list update timestamp UTC greater than 2021-01-01?",
    "evidence": "",
    "SQL": "SELECT movie_id, movie_title FROM movies INNER JOIN lists ON lists.list_movie_number = movies.movie_id WHERE lists.list_update_timestamp_utc > '2021-01-01'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score = (SELECT MAX(r2.rating_score) FROM ratings r2)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies listed in the 'Awesome Movie List'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_title = 'Awesome Movie List'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT * 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 lists 'Movie Buffs' and 'Films for the Ages'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN lists_users lu ON lu.user_id = m.director_id WHERE lu.list_id IN (SELECT list_id FROM lists WHERE list_title IN ('Movie Buffs', 'Films for the Ages')) ORDER BY m.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies with a list title that contains the word 'comedy' and a director whose name contains the word 'coen'?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_title IN (SELECT list_title FROM lists WHERE list_title LIKE '%comedy%') AND director_name LIKE '%coen%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON lists.list_movie_number = movies.movie_id WHERE list_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 all lists that contain at least 5 movies?",
    "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 >= 5))"
  },
  {
    "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 5 rated movies in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies ORDER BY (SELECT AVG(rating_score) FROM ratings WHERE movie_id = movies.movie_id) DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have a title containing the word 'The' and have more than 10 followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE '%The%' AND list_followers > 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the list titled 'Best Movies of the 90s' and have a critic score of at least 8?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN lists l ON m.movie_id = l.list_movie_number WHERE l.list_title = 'Best Movies of the 90s' AND (SELECT r.rating_score FROM ratings r WHERE r.critic = 'Critic' AND r.movie_id = m.movie_id AND r.rating_score >= 8) IS NOT NULL GROUP BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have created more than one list and also have a payment method?",
    "evidence": "",
    "SQL": "SELECT lu.user_id, lu.user_avatar_image_url, lu.user_cover_image_url FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_has_payment_method = 1 AND lu.user_id IN (SELECT user_id FROM lists_users GROUP BY user_id HAVING COUNT(list_id) > 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have the most users?",
    "evidence": "",
    "SQL": "SELECT list_id, COUNT(*) as total_users FROM lists_users GROUP BY list_id ORDER BY total_users DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of all the lists in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies added by user 'user1'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = (SELECT user_id FROM lists_users WHERE list_id = lists.list_id AND user_id = 'user1')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT AVG(movie_popularity) FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies in the 'Star Wars' series that were released after 1980?",
    "evidence": "",
    "SQL": "SELECT DISTINCT m.movie_title FROM movies m WHERE m.movie_title LIKE '%Star Wars%' AND m.movie_release_year > 1980"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists belong to the user with id 1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in a list created by a user who has never been a subscriber?",
    "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 r.rating_score > (SELECT AVG(rating_score) FROM ratings) AND lu.user_subscriber = 0 LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that are in a list created by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT M.movie_title, M.movie_release_year FROM lists L, lists_users U, ratings R, movies M WHERE L.list_id = U.list_id AND U.user_id = R.user_id AND R.user_has_payment_method = 1 AND L.list_id = M.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with ID 1?",
    "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 = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie added to the list titled 'Movie Buff'?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE list_title = 'Movie Buff' ORDER BY list_update_timestamp_utc LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies listed by the user with ID 123?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do users named 'John' follow?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_id = 'John'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists that belong to a user with a trial plan?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists_users WHERE user_trialist = 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 are the titles of movies which have the most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT DISTINCT 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 GROUP BY m.movie_title ORDER BY l.list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie on the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE lists.list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)) AND lists.list_movie_number = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been favorably reviewed by users who have also created a list?",
    "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 HAVING COUNT(*) > 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles in the list 'Test List' created by 'User1'?",
    "evidence": "",
    "SQL": "SELECT 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 = 'Test List' AND lists_users.user_id = (SELECT user_id FROM lists_users WHERE list_title = 'Test List' AND user_id = 'User1')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies added to the lists of subscribers?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1) AND movie_id IN (SELECT movie_id FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies watched by users who have been subscribers for more than a year?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id JOIN ratings_users ON lists_users.user_id = ratings_users.user_id WHERE lists_users.user_subscriber = 1 AND lists_users.user_trialist = 0 AND rating_timestamp_utc IS NOT NULL"
  },
  {
    "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 with the highest rating in the lists database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY MAX(rating_score) LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies 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 INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies that a user has rated as their favorite?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings) 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 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 list of movies with more than 1000 ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id GROUP BY m.movie_title HAVING COUNT(r.rating_id) > 1000"
  },
  {
    "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 all the lists of movies created by a particular director?",
    "evidence": "",
    "SQL": "SELECT l.* 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 JOIN movies m ON l.list_movie_number = m.movie_id WHERE m.director_name = 'Director Name'"
  },
  {
    "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 most followers on the list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE list_followers = (SELECT MAX(list_followers) FROM lists) 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 are the titles of the movies listed in the 'Test 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_movie_number = m.movie_id WHERE l.list_title = 'Test List'"
  },
  {
    "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 AVG(rating_score) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are on the top 10 most popular lists?",
    "evidence": "",
    "SQL": "SELECT movie_id, movie_title FROM lists JOIN movies ON lists.list_movie_number = movies.movie_id WHERE list_followers > 10000 ORDER BY list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 lists of movies by most followers?",
    "evidence": "",
    "SQL": "SELECT list_title, COUNT(list_id) AS followers FROM lists GROUP BY list_title ORDER BY followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is most popular among users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM movies M JOIN ratings_users RU ON M.movie_id = RU.user_id WHERE RU.user_subscriber = 1 GROUP BY M.movie_title ORDER BY COUNT(*) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is most popular among users who have a list with more than 10 items?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id JOIN movies ON lists.list_movie_number = movies.movie_id GROUP BY movies.movie_title HAVING COUNT(lists.list_id) > 10 ORDER BY COUNT(lists.list_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated highest by all users in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY AVG(rating_score) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title 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 lists has user 1 created?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE lu.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating from a user who has a payment method?",
    "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 > (SELECT AVG(rating_score) FROM ratings) AND ratings_users.user_has_payment_method = 1 GROUP BY movies.movie_title ORDER BY COUNT(ratings.rating_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists that contain a movie released in the year 1990 and have been followed by more than 5 users?",
    "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 IN (SELECT list_id FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies WHERE movie_release_year = 1990))) AND list_followers > 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 are the titles of the top 10 highest rated movies?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id ORDER BY ratings.rating_score DESC LIMIT 10"
  },
  {
    "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 are the top 5 movies with the most followers in a list?",
    "evidence": "",
    "SQL": "SELECT l.list_title, COUNT(*) as followers_count FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id GROUP BY l.list_title ORDER BY followers_count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating 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 ratings_users WHERE user_trialist=1)) AND list_movie_number = (SELECT MAX(list_movie_number) FROM lists WHERE list_movie_number IN (SELECT list_movie_number FROM lists WHERE list_movie_number IN (SELECT list_movie_number FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))))"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie in a user's favorite list has the highest rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id JOIN ratings r ON r.user_id = lu.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE lu.user_id = 1 ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in a list with the most followers?",
    "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_followers = (SELECT MAX(list_followers) FROM lists) AND M.movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies liked by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title, movies.movie_release_year FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method = 1) ORDER BY ratings.rating_score DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of all movies on the list with the title 'Top 100 Movies'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN lists ON lists.list_id = ratings.movie_id WHERE lists.list_title = 'Top 100 Movies'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users ORDER BY user_subscriber DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are currently trending among a specific set of users?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE list_followers > 10000)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies in a list with a title that contains 'The' and published after 2015?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title, movie_title, movie_release_year FROM lists, movies WHERE lists.list_title LIKE '%The%' AND movie_release_year > 2015 AND lists.list_movie_number = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies in a list by a user with the username 'john'?",
    "evidence": "",
    "SQL": "SELECT AVG(movie_popularity) FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id INNER JOIN lists_users ON ratings.user_id = lists_users.user_id INNER JOIN lists ON lists_users.list_id = lists.list_id WHERE lists_users.user_id IN (SELECT user_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_avatar_image_url = '<https://example.com/john_avatar>'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are rated by users who also own lists and have payment methods?",
    "evidence": "",
    "SQL": "SELECT m.movie_title 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 INNER JOIN movies m ON r.movie_id = m.movie_id WHERE lu.user_has_payment_method = 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 movies.movie_id = lists_users.list_id GROUP BY movie_title ORDER BY COUNT(lists_users.user_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been favorited by users who have also favorited the list 'Top 100 Movies'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM lists_users lu INNER JOIN lists l ON lu.list_id = l.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 = 'Top 100 Movies' AND r.rating_score > 0"
  },
  {
    "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 titles of all lists with more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5"
  },
  {
    "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_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY SUM(rating_score) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the top 3 most popular lists on the platform?",
    "evidence": "",
    "SQL": "SELECT DISTINCT movies.movie_title FROM lists, movies WHERE lists.list_id IN (SELECT list_id FROM lists ORDER BY lists.list_followers DESC LIMIT 3) AND lists.list_movie_number = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular movies in the lists table?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number > 0 ORDER BY list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the 'lists' table that have at least one rating and are added by the user with id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 1) AND list_id IN (SELECT list_id FROM ratings WHERE rating_id IS NOT NULL)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by users who have a payment method?",
    "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 titles of the lists that contain the movie 'The Shawshank Redemption'? ",
    "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 IN (SELECT user_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 = 'The Shawshank Redemption')))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists in the database that contain more than 10 movies?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_movie_number > 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 lists with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title, COUNT(*) as followers FROM lists GROUP BY list_title ORDER BY followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies added to a list by user with ID 1234?",
    "evidence": "",
    "SQL": "SELECT AVG(movie_popularity) FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 1234))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest ratings in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the 'Adventure' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movies.movie_title_language LIKE '%Adventure%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists created by a user with a trial subscription?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE 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 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 popularity in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_movie_number IN (SELECT list_movie_number FROM lists GROUP BY list_movie_number ORDER BY COUNT(*) DESC LIMIT 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the most popular 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 = (SELECT user_id FROM ratings_users WHERE user_trialist = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie that was released in 1995 and has a rating of 4.5?",
    "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 IN (SELECT user_id FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_release_year = 1995) AND rating_score = 4.5)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are available in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists INNER JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_id = (SELECT list_id FROM lists ORDER BY lists.list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in a list of movies called 'Favorite Movies' made by a user with the username 'john'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, lists l, lists_users lu WHERE lu.user_id = l.user_id AND lu.list_id = l.list_id AND l.list_title = 'Favorite Movies' AND m.movie_id = l.list_movie_number LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies rated 5/5 by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r INNER JOIN lists_users lu ON r.user_id = lu.user_id INNER 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 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 average popularity of the movies in the lists of users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(movie_popularity) FROM movies JOIN lists_users ON movies.movie_id IN (SELECT list_id FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_has_payment_method = 1)) JOIN lists ON lists.list_id = lists_users.list_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list 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 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 are the movies that are part of the list named 'A' created by user with id 1?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l, lists_users lu, movies m WHERE l.list_id = lu.list_id AND lu.user_id = 1 AND l.list_id = m.movie_id AND l.list_title = 'A'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does a user with the ID 1 own?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have at least 5 movies?",
    "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 user_id IN (SELECT user_id FROM ratings WHERE rating_id IN (SELECT rating_id FROM ratings GROUP BY rating_id HAVING COUNT(*) >= 5))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest average rating from users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS avg_rating FROM movies m LEFT JOIN ratings r ON m.movie_id = r.movie_id INNER JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.user_subscriber = 1 GROUP BY m.movie_title ORDER BY avg_rating 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 ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of a list that has 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 created by the user with ID 1234?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1234"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in list with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who are not subscribers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_id 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 = 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": "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 followed by more than 50 users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_followers > 50"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies added by user with id 1 in the last 30 days?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE user_id = 1) AND DATE(rating_timestamp_utc) >= DATE('now', '-30 days'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular movies in a specific year?",
    "evidence": "",
    "SQL": "SELECT movie_title, COUNT(rating_id) AS total_ratings FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE movie_release_year = 2020 GROUP BY movie_title ORDER BY total_ratings DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies that are also in the list titled 'Movie Review'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE lists.list_title = 'Movie Review' AND lists.list_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that have been rated by users who are both trialists and subscribers?",
    "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_trialist = 1 AND ru.user_subscriber = 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 are the titles of the movies in the lists created by users who have a cover image URL?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title FROM lists l JOIN lists_users lu ON l.user_id = lu.user_id JOIN movies m ON lu.list_id = l.list_id WHERE lu.user_id IN (SELECT lu2.user_id FROM lists_users lu2 WHERE lu2.user_cover_image_url IS NOT NULL)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in the 'Lists' table with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers IN (SELECT MAX(list_followers) FROM lists GROUP BY list_id LIMIT 3) ORDER BY list_followers DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have a trialist account and created at least one list?",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists_users WHERE user_trialist = 1 GROUP BY user_id HAVING COUNT(list_id) > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of users who are subscribers and have a payment method?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1 AND user_has_payment_method = 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, movie_title FROM lists INNER JOIN movies ON lists.list_id = movies.movie_id ORDER BY lists.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists that are followed by at least 10 users?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id HAVING COUNT(*) >= 10)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the lists made by a user named 'john'?",
    "evidence": "",
    "SQL": "SELECT l.list_title, 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 lu.user_id IN (SELECT user_id FROM lists_users WHERE user_id = (SELECT user_id FROM lists_users WHERE user_avatar_image_url = 'john'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among the lists that I have followed?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER JOIN lists l ON m.movie_id NOT IN (SELECT rl.movie_id FROM ratings rl INNER JOIN lists_users rlku ON rlku.user_id = rl.user_id AND rlku.list_id = l.list_id) WHERE m.movie_popularity = (SELECT MAX(mo.movie_popularity) FROM movies mo)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest number of followers on the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title, list_followers FROM lists, movies WHERE lists.list_id = movies.movie_id ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies with a title language English that have a rating score greater than 7 from a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_title_language = 'English' AND (SELECT rating_score FROM ratings WHERE ratings.movie_id = movies.movie_id AND ratings.user_id IN (SELECT user_id FROM ratings_users WHERE ratings_users.user_subscriber = 1)) > 7"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists created by user 'user1'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 'user1')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of the movies in the lists created by users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT AVG(movies.movie_popularity) FROM movies JOIN lists_users ON movies.movie_id = lists_users.user_id WHERE lists_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by the user with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 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 movie titles of the top 5 most popular movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating among the lists of user 'user1'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, lists l, lists_users lu WHERE l.list_id = lu.list_id AND lu.user_id = 'user1' AND m.movie_id = l.list_movie_number AND m.movie_popularity = (SELECT MAX(m2.movie_popularity) FROM movies m2, lists l2, lists_users lu2 WHERE l2.list_id = lu2.list_id AND lu2.user_id = 'user1' AND m2.movie_id = l2.list_movie_number)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies rated by users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT * FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1) ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists have a list title that contains the word 'movie' and have more than 1 movie in them?",
    "evidence": "",
    "SQL": "SELECT list_id, list_title FROM lists WHERE list_title LIKE '%movie%' AND list_movie_number > 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is the most popular in the list of all movies?",
    "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 the list with id 1?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies in the list with the ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title, list_movie_number, list_cover_image_url, list_first_image_url, list_second_image_url, list_third_image_url FROM lists WHERE list_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists were created by a user with a trial subscription?",
    "evidence": "",
    "SQL": "SELECT l.list_id, l.list_title, lu.user_id, lu.user_trialist FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_id, movie_title, list_followers FROM lists INNER JOIN movies ON lists.list_id = movies.movie_id ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are most popular among the lists' followers?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title, COUNT(ratings.rating_id) AS count FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id JOIN movies ON lists.list_movie_number = movies.movie_id JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movies.movie_title ORDER BY count DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity and how many followers does the list it belongs to have?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, l.list_followers FROM movies m JOIN lists l ON m.movie_id = l.list_id JOIN lists_users lu ON l.list_id = lu.list_id WHERE m.movie_popularity = (SELECT MAX(movie_popularity) FROM movies) ORDER BY l.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies in a list that has over 10 followers?",
    "evidence": "",
    "SQL": "SELECT AVG(movies.movie_popularity) FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_followers > 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the list created by a user named John?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists_users, lists WHERE lists_users.user_id = 1 AND lists_users.list_id = lists.list_id AND lists.list_title IN (SELECT list_title FROM lists WHERE user_id = 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 are the lists that include the movie 'The Shawshank Redemption'?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON lu.list_id = m.movie_id WHERE m.movie_title = 'The Shawshank Redemption'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in a user's first list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = (SELECT list_id FROM lists_users WHERE user_id = (SELECT user_id FROM ratings_users WHERE user_id = 1 LIMIT 1)) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the list with the title 'Sample List' and were rated by users who are subscribers?",
    "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 = 'Sample List' AND lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been favorited by user 'abc'?",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m JOIN lists_users lu ON m.movie_id = lu.list_id JOIN lists l ON lu.list_id = l.list_id WHERE l.user_id = (SELECT user_id FROM lists_users WHERE user_id = 'abc') AND l.list_title LIKE '%Favorited Movies%'"
  },
  {
    "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 listed in the 'The Shawshank Redemption' list?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title FROM lists WHERE list_title = 'The Shawshank Redemption'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists does the user with the most followers own?",
    "evidence": "",
    "SQL": "SELECT l.list_id, l.list_title, COUNT(*) as num_followers FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id GROUP BY lu.list_id, l.list_title ORDER BY num_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been listed by users who are both trialists and subscribers?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_trialist = 1 AND user_subscriber = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists created by users that have more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT * 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 HAVING COUNT(*) > 5))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies with a rating score higher than 80 that have been listed by users with a trial subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score > 80 AND r.user_id IN (SELECT user_id FROM lists_users lu WHERE lu.user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 most popular movies?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "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 movies with the highest average ratings in lists created by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS average_rating FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN lists_users lu ON r.user_id = lu.user_id JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_has_payment_method = 1 GROUP BY m.movie_title ORDER BY average_rating DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 10 most popular movies?",
    "evidence": "",
    "SQL": "SELECT DISTINCT m.movie_title FROM movies m ORDER BY m.movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists contain at least one movie released in the year 2000?",
    "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_movie_number IN (SELECT movie_id FROM movies WHERE movie_release_year = 2000)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT AVG(movie_popularity) FROM lists, movies WHERE lists.list_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 highest rated movies in the lists database?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM ratings, movies WHERE ratings.movie_id = movies.movie_id ORDER BY rating_score DESC 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 ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles and release years of the movies in the list of user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year 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 lu.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movies.movie_title ORDER BY AVG(ratings.rating_score) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been added to the 'Example List' by user 'user-12345'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, l.list_title FROM movies m JOIN lists_users lu ON lu.list_id = l.list_id JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 'user-12345' AND l.list_title = 'Example List'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of movies in a list named 'Top 10 Sci-Fi Movies'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r JOIN lists l ON r.movie_id = (SELECT movie_id FROM movies WHERE movie_title LIKE '%Sci-Fi%') JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.list_id = (SELECT list_id FROM lists WHERE list_title = 'Top 10 Sci-Fi Movies')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of a movie that is included in a list created by a user who is not a trialist?",
    "evidence": "",
    "SQL": "SELECT AVG(r.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_followers > 0 AND lu.user_trialist = 0 GROUP BY r.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies in the top 10 lists of users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(m.movie_popularity) FROM lists as l JOIN lists_users as lu ON l.list_id = lu.list_id JOIN movies as m ON l.list_movie_number = m.movie_id WHERE lu.user_has_payment_method = 1 AND l.list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method = 1 LIMIT 10))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies recommended by users with a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, ratings_users ru, ratings r WHERE m.movie_id=r.movie_id AND r.user_id=ru.user_id AND ru.user_has_payment_method=1 ORDER BY r.rating_score DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating in the list that has the most followers?",
    "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_movie_number = m.movie_id WHERE l.list_followers = (SELECT MAX(list_followers) FROM lists) ORDER BY m.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been added to the lists of users who have paid for the subscription?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies JOIN lists_users ON movies.movie_id = lists_users.list_id WHERE lists_users.user_has_payment_method = 1 AND lists_users.list_id IN (SELECT list_id FROM lists_users GROUP BY list_id HAVING COUNT(list_id) > 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity, and what is its director?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.director_name FROM movies m JOIN (SELECT MAX(m2.movie_popularity) AS max_popularity FROM movies m2) AS t ON m.movie_popularity = t.max_popularity"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have more than 50 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 50"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has 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 are the top 3 movies with the highest ratings in the year 2010?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_release_year = 2010 ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists that have at least 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers >= 10"
  },
  {
    "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 lists created by users who have subscribed to the service?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id IN (SELECT list_id FROM lists_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 movies WHERE movie_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the lists table?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title, list_movie_number FROM lists LEFT JOIN movies ON lists.list_id = movies.movie_id ORDER BY list_movie_number DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have a movie with a rating of 8.5 or higher?",
    "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 IN (SELECT user_id FROM ratings WHERE rating_score >= 8.5)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies listed by users who have both trialist and subscriber status?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN lists_users ru ON ru.user_id = lu.user_id JOIN movies m ON l.list_movie_number = m.movie_id WHERE ru.user_trialist = 1 AND ru.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do users with the highest number of followers have?",
    "evidence": "",
    "SQL": "SELECT L.list_title, L.list_id FROM lists L INNER JOIN lists_users LU ON L.list_id = LU.list_id INNER JOIN (SELECT user_id, COUNT(*) AS follower_count FROM lists_users GROUP BY user_id ORDER BY follower_count DESC LIMIT 1) UC ON LU.user_id = UC.user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest ratings in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT * FROM lists, movies WHERE lists.list_id = movies.movie_id ORDER BY movies.movie_popularity DESC LIMIT 5"
  },
  {
    "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 GROUP BY list_id ORDER BY COUNT(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have at least 500 followers on a list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers >= 500"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies that have been listed most frequently by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(l.list_id) AS count FROM lists l JOIN movies m ON l.list_id = m.movie_id GROUP BY m.movie_title ORDER BY count DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 movies with the highest rating that are not by Martin Scorsese?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id=r.movie_id WHERE m.director_name NOT LIKE '%Martin Scorsese%' ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been favorited by more than 5 people on the list with the title 'Awesome Movies'?",
    "evidence": "",
    "SQL": "SELECT 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 = 'Awesome Movies' AND lists.list_followers > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies rated by users who have subscribed and have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, 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 = 1 AND ru.user_has_payment_method = 1 ORDER BY r.rating_score DESC LIMIT 10"
  },
  {
    "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 5 rated movies in the database?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS avg_rating FROM ratings r JOIN movies m ON r.movie_id = m.movie_id GROUP BY m.movie_title ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies with a release year of 2015 that have been rated by a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.* 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 m.movie_release_year = 2015 AND ru.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies contain more than 5 movies and have been updated after 2020?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number > 5 AND list_update_timestamp_utc > '2020-01-01 00:00:00'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest popularity 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 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 most popular movies in each list, ordered by their average rating?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title, AVG(r.rating_score) AS average_rating 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 GROUP BY l.list_title, m.movie_title ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of users who follow at least one list with movie rating higher than 8 and has more than 10 followers?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN lists_users lu2 ON lu.list_id = lu2.list_id JOIN lists lu3 ON lu.list_id = lu3.list_id JOIN ratings r ON lu3.list_id = r.movie_id WHERE lu2.user_id = lu.user_id AND r.rating_score > 8 AND lu3.list_followers > 10 GROUP BY l.list_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the top-rated movie in the ' lists' table?",
    "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 average popularity of movies in lists created by users who have been subscribers?",
    "evidence": "",
    "SQL": "SELECT AVG(movies.movie_popularity) FROM movies, lists, lists_users WHERE movies.movie_id IN (SELECT list_movie_number FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_subscriber = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the top 5 most popular movies among a specific user's lists?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = (SELECT user_id FROM ratings_users WHERE user_trialist = 1) AND list_movie_number <= 5 ORDER BY list_movie_number DESC"
  },
  {
    "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 are the top 5 most popular movies according to the given database?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top-rated movies in the lists_users table that have more than 100 followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers > 100 ORDER BY list_movie_number DESC"
  },
  {
    "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 are the top 3 most popular movies in the 'lists' table that have a rating?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title, rating_score FROM lists INNER JOIN movies ON lists.list_id = movies.movie_id INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating score of movies in a list titled 'Top Movies of 2020' created by a user who has a payment method?",
    "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 WHERE lists.list_title = 'Top Movies of 2020' AND lists_users.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 lists created by the most popular movie critics?",
    "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_subscriber = 1 ORDER BY lu.user_trialist DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies are followed by user with user_id = 123?",
    "evidence": "",
    "SQL": "SELECT l.list_id, l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies by list title popularity?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) AS total FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.list_movie_number = m.movie_id GROUP BY m.movie_title ORDER BY total DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists belong to the user with ID 1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "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 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 is the title of the movie with the most followers on the list with the ID 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_id = 1 AND lists.list_id = movies.movie_id ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of movies with more than 10 movies by a user named 'John'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.user_id IN (SELECT user_id FROM lists_users WHERE user_id = (SELECT user_id FROM lists_users WHERE list_title = 'John')) GROUP BY m.movie_title HAVING COUNT(m.movie_title) > 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(l.list_followers) as followers_count FROM lists l JOIN movies m ON l.list_id = m.movie_id GROUP BY m.movie_title ORDER BY followers_count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies rated by users with a payment method?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE user_has_payment_method = 1 ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a rating of at least 4 and are also in a user's favorite list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM lists l, lists_users lu, movies m, ratings r WHERE l.list_id = lu.list_id AND lu.user_id = r.user_id AND r.rating_score >= 4 AND l.list_id IN (SELECT list_id FROM lists WHERE list_followers > 0)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie 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 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most rated movies by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, SUM(r.rating_score) AS total_rating FROM ratings r INNER JOIN movies m ON r.movie_id = m.movie_id GROUP BY m.movie_title ORDER BY total_rating DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie on the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_popularity 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_followers = (SELECT MAX(list_followers) FROM lists) ORDER BY m.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists created by users have more than 5 items?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE user_id IN (SELECT user_id FROM lists_users) AND list_movie_number > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list 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 are the titles of the top 3 most popular movies in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the most ratings from users who have subscribed?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1)) ORDER BY (SELECT COUNT(*) FROM ratings WHERE movie_id = movies.movie_id) DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in the list named 'Favorite Movies' under user 'John'? ",
    "evidence": "",
    "SQL": "SELECT list_title, list_movie_number, movie_title FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id JOIN movies ON lists.list_movie_number = movies.movie_id WHERE lists_users.user_id = (SELECT user_id FROM lists_users WHERE user_id = 'John' AND list_id = 'Favorite Movies')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists of movies created by a particular user?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users)"
  },
  {
    "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 and its corresponding user?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, ru.user_avatar_image_url 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 r.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 JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings) ORDER BY movie_title LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in the lists database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 1) 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 INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score IS NOT NULL 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 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number 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?",
    "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 1 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 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 is the number of lists created by a user who has paid for a subscription and has a profile picture?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM lists_users WHERE user_has_payment_method = 1 AND user_cover_image_url IS NOT NULL GROUP BY user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 lists in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating among all the movies?",
    "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 have more than 50 followers?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_followers > 50"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies from the top 100 lists of 2022?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_movie_number <= 100 AND list_update_timestamp_utc LIKE '%2022%' AND list_title IN (SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers in all lists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id 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 are all the titles of the movies in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies with highest ratings?",
    "evidence": "",
    "SQL": "SELECT * FROM movies, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.rating_score > 8 ORDER BY ratings.rating_score DESC LIMIT 10"
  },
  {
    "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 ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the list that the user with user_id = 1 created?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers for a movie list with a title containing the word 'Super'? ",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_title LIKE '%Super%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of a movie that has been followed by more than 5 users in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_followers > 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l, ratings r, movies m WHERE l.list_id = r.user_id AND r.rating_id = m.movie_id AND l.list_followers = (SELECT MAX(f.list_followers) FROM lists f) AND r.rating_score = (SELECT MAX(f.rating_score) FROM ratings f)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie on the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_followers = (SELECT MAX(list_followers) FROM lists) ORDER BY m.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 INNER JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies in the 'lists' table have been updated most recently?",
    "evidence": "",
    "SQL": "SELECT list_title, list_update_timestamp_utc FROM lists ORDER BY list_update_timestamp_utc DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_movie_number = m.movie_id WHERE l.list_followers > 0 ORDER BY l.list_followers DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists that the user with ID 1 has created?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists_users WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 rated movies in the 'lists' table that have a list_title containing the word 'comedy'? ",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_title LIKE '%comedy%' ORDER BY list_movie_number DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies among users who have a valid payment method?",
    "evidence": "",
    "SQL": "SELECT M.movie_title, COUNT(*) as count 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_has_payment_method = 1 GROUP BY M.movie_title ORDER BY count DESC LIMIT 3"
  },
  {
    "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 rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most comments on a list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE lists.list_movie_number = movies.movie_id AND lists.list_comments = (SELECT MAX(list_comments) 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 WHERE rating_id = (SELECT MAX(rating_id) 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": "Which movie titles are in the list created by a user who has a payment method?",
    "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 user_has_payment_method = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists that contain movies released before 2010?",
    "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_trialist=0 OR user_subscriber=1) AND list_movie_number IN (SELECT movie_id FROM movies WHERE movie_release_year < 2010))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies in lists that have more than 1000 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 1000"
  },
  {
    "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 are the most popular movies with a director named Martin Scorsese?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year FROM movies m WHERE m.director_name = 'Martin Scorsese' ORDER BY m.movie_popularity DESC"
  },
  {
    "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 are the top 5 lists with the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has been rated by a user with the user_id 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.user_id = 1 AND ratings.movie_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the users who have a list with a movie titled 'The Shawshank Redemption'?",
    "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 IN (SELECT list_id FROM lists WHERE list_title LIKE '%The Shawshank Redemption%')))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest ratings in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the list created by a user who has a trial subscription?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_trialist = 1) AND list_id IN (SELECT list_id FROM lists_users WHERE user_trialist = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the list created by user with id 123?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists WHERE user_id = 123))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest average rating among the movies in the lists of users who have a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id 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 GROUP BY m.movie_id ORDER BY AVG(r.rating_score) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies with the highest rating, sorted by the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE rating_timestamp_utc IS NOT NULL ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of movies in a list created by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(list_movie_number) FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_has_payment_method=1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by a user with the name 'John'? ",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_id IN (SELECT lu.user_id FROM lists_users lu WHERE lu.user_id IN (SELECT ru.user_id FROM ratings_users ru WHERE ru.user_avatar_image_url LIKE '%John%'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers of movies in the list with ID 1234?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists WHERE list_id = 1234"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are listed in a specific list that are released after 2000 and have a rating higher than 4?",
    "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_movie_number = m.movie_id WHERE m.movie_release_year > 2000 AND m.movie_popularity > 4"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest popularity score among all the movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_popularity FROM lists l INNER JOIN movies m ON l.list_movie_number = m.movie_id ORDER BY m.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the names of the movies rated by users who are trialists and have payment methods?",
    "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_trialist = 1 AND ru.user_has_payment_method = 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 is the title of the most popular movie in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists_users AS lu JOIN lists AS l ON lu.list_id = l.list_id JOIN movies AS m ON l.list_id = m.movie_id WHERE lu.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 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating from all the lists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE list_movie_number = movies.movie_id AND list_followers = (SELECT max(list_followers) FROM lists) ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the 'Horror' genre?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE m.movie_title_language = 'Horror'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in a list with more than 10 followers?",
    "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.list_id = m.movie_id WHERE l.list_followers > 10 ORDER BY l.list_followers 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 m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists that have at least one movie with a rating score above 8?",
    "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_score > 8))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies rated by users from New York who have been subscribers to the platform for at least 6 months?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS avg_rating FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN lists_users lu ON r.user_id = lu.user_id AND lu.user_subscriber = 1 AND lu.user_trialist = 0 WHERE lu.user_avatar_image_url LIKE '%@ny.gov%' GROUP BY m.movie_title ORDER BY avg_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list 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 5 most popular movies by user trialist who are also subscribers?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_trialist = 1 AND user_subscriber = 1))) ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the movies with a rating score of 80 or higher from the users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT l.list_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 WHERE r.rating_score >= 80 AND r.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the most followers in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies has user 1 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 IN (SELECT user_id FROM lists_users WHERE list_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest rating?",
    "evidence": "",
    "SQL": "SELECT * FROM movies, ratings WHERE movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movie has the highest rating in the list of lists?",
    "evidence": "",
    "SQL": "SELECT movie_title, rating_score FROM ratings JOIN lists ON ratings.user_id = lists.user_id JOIN movies ON ratings.movie_id = movies.movie_id WHERE list_id IN (SELECT list_id FROM lists) ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have been rated by users who have followed a list with at least 10 followers?",
    "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 JOIN lists l ON lu.list_id = l.list_id WHERE l.list_followers > 9 GROUP BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that are liked by users who have both a trialist and a subscriber?",
    "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_trialist = 1 AND ratings_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of all lists created by user with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number GROUP BY movie_title ORDER BY lists.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in a list with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title FROM lists WHERE list_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in a list where the user id is 1?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number JOIN lists_users ON lists.list_id = lists_users.list_id WHERE lists_users.user_id = 1 ORDER BY movies.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have a list with more than 100 movies?",
    "evidence": "",
    "SQL": "SELECT LU.user_id FROM lists_users LU WHERE LU.list_id IN (SELECT list_id FROM lists WHERE list_movie_number > 100)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the top 5 most popular movies?",
    "evidence": "",
    "SQL": "SELECT L.list_title FROM lists L JOIN movies M ON L.list_id = M.movie_id ORDER BY M.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 WHERE movie_id IN (SELECT movie_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 is the title of the movie that the user with id 1 has the highest rated movie?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r, movies m, lists_users lu, lists_users lu2 WHERE r.user_id = lu.user_id AND lu.user_id = 1 AND m.movie_id = r.movie_id AND r.rating_score = (SELECT max(r2.rating_score) FROM ratings r2 WHERE r2.user_id = lu.user_id)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 123?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists created by a user named 'userX'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 'userX')"
  },
  {
    "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 10 most popular movies, according to the ratings?",
    "evidence": "",
    "SQL": "SELECT * FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is 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 most popular movie with a list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l, movies m WHERE l.list_movie_number = m.movie_id ORDER BY l.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have been rated by users with trial subscriptions?",
    "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_trialist = 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 are the movie titles in the 'Favorite Movies' list of the user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1 AND list_id IN (SELECT list_id FROM lists_users WHERE user_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of users who have rated movies?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists INNER JOIN lists_users ON lists.user_id = lists_users.user_id INNER JOIN ratings ON lists.user_id = ratings.user_id GROUP BY list_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists created by user with ID 123?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the number of lists that have more than 5 followers and at least one movie?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM lists WHERE list_followers > 5 AND 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 ratings)) )"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest popularity among the top 50 most followed lists?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title, movies.movie_popularity FROM movies, lists WHERE movies.movie_id IN (SELECT lists.list_movie_number FROM lists ORDER BY lists.list_followers DESC LIMIT 50) ORDER BY movies.movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in a list owned by a user with the id 123?",
    "evidence": "",
    "SQL": "SELECT AVG(r.rating_score) FROM ratings r INNER JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.user_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers a list has?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies by users who are subscribers and have a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS avg_rating FROM ratings WHERE user_subscriber = 1 AND user_has_payment_method = 1 GROUP BY movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in a list with over 100 followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_followers > 100 ORDER BY l.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies rated by users in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(m.movie_title) AS count 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 GROUP BY m.movie_title ORDER BY count DESC 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 ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of the movies in the lists created by a user who is a subscriber and has a payment method?",
    "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 lu.user_subscriber = 1 AND lu.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movie titles that have a rating_score greater than 8 in the 'Good' list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE list_id = 'Good' AND rating_score > 8"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies that have a rating greater than or equal to 4.0?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score >= 4.0"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have the highest rating in the year 2015?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, m.movie_image_url, AVG(r.rating_score) AS average_rating FROM movies m LEFT JOIN ratings r ON m.movie_id = r.movie_id WHERE m.movie_release_year = 2015 GROUP BY m.movie_title, m.movie_release_year, m.movie_image_url ORDER BY average_rating DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are rated by users in the 'Trialist' status?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r INNER JOIN movies m ON r.movie_id = m.movie_id INNER JOIN ratings_users ru ON r.user_id = ru.user_id WHERE ru.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the movies that have at least 100 ratings and are included in at least 2 lists?",
    "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_movie_number = m.movie_id WHERE lu.user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists GROUP BY list_id HAVING COUNT(list_id) > 1)) AND m.movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id HAVING COUNT(rating_id) > 99)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers on the list with the ID 123?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists, movies WHERE list_id = 123 AND movies.movie_id = (SELECT movie_id FROM lists WHERE list_id = 123 ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the lists that have a rating greater than 8 and were created by a user who has a subscription?",
    "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 r.rating_score > 8 AND ru.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists contain the movie 'The Shawshank Redemption'?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE m.movie_title = 'The Shawshank Redemption' AND l.list_id IN (SELECT lu.list_id FROM lists_users lu WHERE lu.user_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating from a user who is a trialist?",
    "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.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title with the highest rating and its corresponding rating score?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, 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 are the titles of the movies in the list with id 123 and user_id 456?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 123 AND user_id = 456"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies with the highest ratings in a specific list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m, ratings r, lists l WHERE m.movie_id = r.movie_id AND r.rating_score = (SELECT MAX(rating_score) FROM ratings r2 WHERE r2.movie_id = m.movie_id) AND l.list_id = r.user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie rated by users who are also trialists?",
    "evidence": "",
    "SQL": "SELECT DISTINCT movie_title FROM movies, ratings_users, ratings WHERE ratings.user_id = ratings_users.user_id AND ratings_users.user_trialist = 1 ORDER BY ratings.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 movies with the highest ratings from users in the 'lists_users' table?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score = (SELECT MAX(r2.rating_score) FROM ratings r2 WHERE r2.user_id IN (SELECT lu.user_id FROM lists_users lu))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list names with at least 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers >= 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by the user with user_id=1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id=1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies from the lists created by users who have been subscribers since the creation of the lists?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1) ORDER BY rating_timestamp_utc LIMIT 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists created by the user with id 123?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists created by user_id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list of a user with id 123?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 123 ORDER BY list_id LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list 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 list title of the movie with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies that have been rated by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, ratings r WHERE m.movie_id = r.movie_id GROUP BY m.movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies listed by the user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in a list created by a user who has a payment method?",
    "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_has_payment_method=1 LIMIT 1)) ORDER BY list_update_timestamp_utc ASC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies that have been rated by a user named John?",
    "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 = 0 AND user_avatar_image_url = '<http://www.example.com/avatar/image/John>')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in the highest rated lists?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) as rating_count 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 GROUP BY m.movie_title ORDER BY rating_count DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 lists with the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity rating in the lists 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 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 WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists that the user with ID 1 has created?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies in the list with the id 1?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title FROM lists WHERE list_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a title language of English and a popularity above 5?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_title_language = 'English' AND movie_popularity > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the 'lists' table that have a 'list_title' containing the word 'Star' and 'list_description' is not null?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title LIKE '%Star%' AND list_description IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies?",
    "evidence": "",
    "SQL": "SELECT * FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies added to a list by a user?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists, lists_users, movies WHERE lists.user_id = lists_users.user_id AND lists.list_id = lists_users.list_id AND lists.list_movie_number = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of movies with more than 10 ratings and a popularity score greater than 5, sorted by their popularity score in descending order?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 5 GROUP BY movie_id HAVING COUNT(rating_score) > 10) ORDER BY movie_popularity DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies that have been rated by at least one user with a movie rating score of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER 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 most popular movie with 3 images?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings WHERE rating_score IN (SELECT MAX(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE list_third_image_url IS NOT NULL))))) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the year 2020?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_release_year = 2020 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 WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_id IN (SELECT MAX(rating_id) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title 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 top 5 most popular movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_movie_number DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most number of followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN lists ON movies.movie_id = lists.list_movie_number 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 WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have watched at least 5 movies and also have a trial subscription?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_subscriber = 1) AND list_id IN (SELECT list_id FROM lists WHERE list_movie_number >= 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id GROUP BY m.movie_id ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the 'Top Movies' list of user 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_id IN (SELECT list_id FROM lists_users WHERE user_id = 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 ORDER BY rating_score DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies rated by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM ratings, movies, ratings_users WHERE ratings.user_id = ratings_users.user_id AND ratings.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "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": "Which users have a subscription and created more than 5 lists?",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists_users WHERE user_subscriber = 1 AND list_id IN (SELECT list_id FROM lists WHERE user_id IN (SELECT user_id FROM lists_users GROUP BY user_id HAVING COUNT(list_id) > 5))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists created by users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_subscriber = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the highest 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 highest rating by users who have a payment method?",
    "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 = (SELECT MAX(r2.rating_score) FROM ratings r2)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that are also part of at least one list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who are also subscribers and have paid for a trial?",
    "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 ru.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been added by users with a payment method to a list with at least 50 movies and are from the year 2022?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists_users INNER JOIN lists ON lists_users.list_id = lists.list_id INNER JOIN movies ON lists.list_movie_number = movies.movie_id WHERE lists_users.user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method = 1) AND lists.list_movie_number >= 50 AND movies.movie_release_year = 2022"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies among users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) AS count FROM ratings r JOIN ratings_users ru ON r.user_id = ru.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE ru.user_has_payment_method = 1 GROUP BY m.movie_title ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do users who have rated the movie with title 'Inception' follow?",
    "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 ru.user_id FROM ratings_users ru JOIN ratings r ON ru.user_id = r.user_id WHERE r.movie_id = (SELECT m.movie_id FROM movies m WHERE m.movie_title = 'Inception'))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists where the user with the ID 1 has not updated the list in the last 30 days?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1 AND list_update_timestamp_utc < datetime('now', '-30 days')"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been added to a list by a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT * FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are included in the lists created by the user with the username 'user1'?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id JOIN ratings r ON lu.user_id = r.user_id JOIN movies m ON r.movie_id = m.movie_id WHERE lu.user_id IN (SELECT user_id FROM lists_users WHERE user_cover_image_url = 'https://example.com/user1_avatar.jpg')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that are followed by more than one user and have a rating score greater than 3?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_score > 3 AND movie_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings_users GROUP BY user_id HAVING count(*) > 1) GROUP BY list_id HAVING count(*) > 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest average rating from users who have a paid subscription?",
    "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.user_subscriber = 1 GROUP BY m.movie_title ORDER BY AVG(r.rating_score) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have been added to the most lists?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id GROUP BY m.movie_title ORDER BY COUNT(l.list_id) DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in the list titled 'Best Movies' created by user with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id=1) AND list_title='Best Movies'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie listed in the list with user_id = 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1 ORDER BY list_id LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies in the 'Star Wars' franchise that have a rating of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_title LIKE '%Star Wars%' AND (SELECT AVG(rating_score) FROM ratings WHERE movie_id = movies.movie_id AND user_subscriber = 1) >= 4"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first list in the database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists 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 title of the movie that has the most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_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 movie with the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(rating_id) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN ratings r ON l.list_id=r.movie_id JOIN movies m ON r.movie_id=m.movie_id GROUP BY m.movie_title ORDER BY COUNT(l.list_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have a list of at least 5 movies?",
    "evidence": "",
    "SQL": "SELECT distinct l.user_id from lists_users l where (select count(*) from lists l2 where l2.user_id = l.user_id) >= 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has been rated 5/5 by the user who has a trial 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.rating_score = 5 AND ratings_users.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles for the lists with more than 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do user 'userId' follow?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists_users WHERE user_id = 'userId'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists created by a user who has a payment method and is a subscriber?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1 AND 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, ratings WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) AND movies.movie_id = ratings.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of all lists that have at least one rating from a user who has a payment method?",
    "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 GROUP BY list_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies in the list have a rating above 80?",
    "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_movie_number = m.movie_id INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score > 80 AND lu.user_id = l.user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists created by the user with user_id=1?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "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 ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies in the top 100 ratings?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id WHERE ratings.rating_score > 80 ORDER BY ratings.rating_score DESC LIMIT 100"
  },
  {
    "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 are the movie titles of the top 10 most popular movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title FROM lists ORDER BY list_movie_number DESC LIMIT 10"
  },
  {
    "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 ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers in a list?",
    "evidence": "",
    "SQL": "SELECT 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 is the title of the movie with the highest popularity that is part of a list created by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON NOT EXISTS (SELECT 1 FROM ratings WHERE ratings.movie_id = m.movie_id AND ratings.user_id = lu.user_id) WHERE l.list_followers > 0 ORDER BY m.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, ratings WHERE ratings.movie_id = movies.movie_id ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "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 are the top 10 most popular movies?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of a movie that has more than 100 ratings?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings WHERE rating_id IN (SELECT rating_id FROM ratings GROUP BY movie_id HAVING COUNT(rating_id) > 100)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the movies rated by users who are also movie critics?",
    "evidence": "",
    "SQL": "SELECT l.list_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 WHERE r.critic = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in the 'Movies' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have updated their list titled 'Best Movies of All Time'?",
    "evidence": "",
    "SQL": "SELECT lu.user_id FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE l.list_title = 'Best Movies of All Time'"
  },
  {
    "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 in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity IN (SELECT MAX(movie_popularity) FROM movies) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest rating?",
    "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_trialist = 1 AND user_subscriber = 1 AND user_eligible_for_trial = 1 AND user_has_payment_method = 1) AND list_id IN (SELECT list_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 popularity rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies from a specific user's watchlist have a rating higher than 7.5?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, lists_users lu, lists l WHERE m.movie_id IN (SELECT rl.movie_id FROM ratings rl, lists_users rl2 WHERE rl2.user_id = lu.user_id AND rl.rating_score > 7.5) AND lu.list_id = l.list_id AND l.user_id = lu.user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie on the list created by the user with user ID 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_id IN (SELECT list_id FROM lists_users WHERE user_id = 1) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT movie_title, COUNT(*) as count FROM movies JOIN lists_users ON movies.movie_id = lists_users.list_id GROUP BY movie_title ORDER BY count DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE ratings.movie_id = movies.movie_id GROUP BY movie_title ORDER BY AVG(ratings.rating_score) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the lists created by the user who created the list with title 'My Top Movies'?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists WHERE list_title='My Top Movies')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title for 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 titles of the movies that have been added to the list with the ID 123?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title FROM lists WHERE list_id = 123"
  },
  {
    "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": "Which lists have at least 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_followers >= 10"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been added to at least two lists?",
    "evidence": "",
    "SQL": "SELECT distinct m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.list_movie_number = m.movie_id GROUP BY m.movie_title HAVING COUNT(*) >= 2"
  },
  {
    "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 added to lists by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM movies M, lists L, lists_users LU, ratings_users RU WHERE M.movie_id = RU.user_id AND LU.user_id = RU.user_id AND LU.list_id = L.list_id AND RU.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists of movies sorted by their release year in descending order?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title, m.movie_release_year FROM lists AS l JOIN movies AS m ON l.list_movie_number = m.movie_id ORDER BY m.movie_release_year 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 most popular movie in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_movie_number, list_title 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 WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 rated movies in the 'Adventure' genre, rated by users who have paid for a subscription?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS average_rating 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_has_payment_method = 1 AND m.movie_title_language = 'Adventure' GROUP BY m.movie_title ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by a user who is both a trialist and a subscriber?",
    "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_trialist = 1 AND ru.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have created a list with a title containing the word 'TV Shows'?",
    "evidence": "",
    "SQL": "SELECT user_id FROM lists WHERE list_title LIKE '%TV Shows%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists) AND list_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the lists created by users who have made a payment?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM ratings_users WHERE user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the names of movies directed by Steven Spielberg in the database?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE director_name = 'Steven Spielberg'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest ratings from the users in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users) ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the number of users who have followed a list that has been updated in the past week?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE l.list_update_timestamp_utc >= DATE('now', '-7 days')"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have created lists with more than 50 movies?",
    "evidence": "",
    "SQL": "SELECT lu.user_id FROM lists_users lu WHERE lu.list_id IN (SELECT l.list_id FROM lists l WHERE l.list_movie_number > 50)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the list of top rated movies?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 lists that have been followed by the most users?",
    "evidence": "",
    "SQL": "SELECT list_id, count(*) as follower_count FROM lists_users GROUP BY list_id ORDER BY follower_count DESC LIMIT 3"
  },
  {
    "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 movie with the highest rating from a user who is a subscriber?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings, lists_users WHERE ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) AND ratings.user_id = lists_users.user_id AND lists_users.user_subscriber = 1 AND lists_users.user_id = ratings.user_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists JOIN movies ON lists.list_id = movies.movie_id WHERE lists.list_followers > 0 ORDER BY lists.list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity that is liked by the critic?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, ratings WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies) AND critic_likes > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies have more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies that have been listed by users with a rating of 5 or more?",
    "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) AND rating_score >= 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in lists_user A's lists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 'A')) ORDER BY movie_popularity 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_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the list of a user with user_id = 10?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in a list that has a cover image?",
    "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_cover_image_url IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the top 3 movies in the 'lists' table with the most followers?",
    "evidence": "",
    "SQL": "SELECT DISTINCT list_movie_number, list_title FROM lists WHERE list_followers > (SELECT MAX(list_followers) FROM lists) ORDER BY list_followers DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie in each list created by a user who has never created a trial or paid account?",
    "evidence": "",
    "SQL": "SELECT L.list_title, M.movie_title, M.movie_popularity FROM lists L LEFT JOIN lists_users LU ON L.user_id = LU.user_id LEFT JOIN ratings R ON LU.user_id = R.user_id LEFT JOIN movies M ON R.movie_id = M.movie_id WHERE LU.user_trialist = 0 AND LU.user_subscriber = 0 GROUP BY L.list_title, M.movie_title ORDER BY M.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for the movies in the list created by a user with a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings, lists_users WHERE ratings.user_id = lists_users.user_id AND lists_users.list_id IN (SELECT list_id FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_has_payment_method = 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the top 10 most popular movies in each list of the user who has the most followers?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title FROM lists l, lists_users lu, lists ls, movies m WHERE lu.user_id = l.user_id AND ls.list_id = l.list_id AND lu.list_id = ls.list_id AND l.list_followers = (SELECT MAX(list_followers) FROM lists) AND m.movie_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)))) LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie listed in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_id LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists of movies that the user with id 123 has followed?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 123 AND list_followers > 0"
  },
  {
    "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 all the lists created by users with the name 'Jane Doe'?",
    "evidence": "",
    "SQL": "SELECT list_id, list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_cover_image_url LIKE '%Jane Doe%')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest number of followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists INNER 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 is the title of the movie that was updated most recently in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_update_timestamp_utc DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest rating according to the critics?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.critic IS NOT NULL ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists that have been followed by at least 50 users?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE (SELECT COUNT(*) FROM lists_users WHERE lists_users.list_id = lists.list_id) >= 50"
  },
  {
    "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 most popular movies by their ratings, excluding movies with no ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS avg_rating FROM ratings r JOIN movies m ON r.movie_id = m.movie_id GROUP BY m.movie_title HAVING AVG(r.rating_score) IS NOT NULL ORDER BY AVG(r.rating_score) DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 123?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in the top-rated list?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies, lists WHERE lists.list_id = (SELECT list_id FROM lists WHERE list_title = 'Top Rated') AND movies.movie_id = (SELECT movie_id FROM ratings WHERE rating_score IN (SELECT MAX(rating_score) FROM ratings) LIMIT 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in all lists?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists) ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in a list with the most followers?",
    "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 list_followers = (SELECT MAX(list_followers) FROM lists) ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of users who created lists with more than 100 movies?",
    "evidence": "",
    "SQL": "SELECT * FROM lists_users WHERE (list_id, user_id) IN (SELECT list_id, user_id FROM lists WHERE list_movie_number > 100)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies that have a release year greater than 2015?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2015"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have a movie with a rating of 5 stars?",
    "evidence": "",
    "SQL": "SELECT l.list_id, l.list_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 WHERE r.rating_score = 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have been rated by the user who has a trial subscription?",
    "evidence": "",
    "SQL": "SELECT movies.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_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists that the user with id 1 follows?",
    "evidence": "",
    "SQL": "SELECT L.list_title FROM lists_users LU JOIN lists L ON LU.list_id = L.list_id WHERE LU.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that a user with a trial subscription has rated, along with their ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score 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 ru.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies in the list of the user with ID 1?",
    "evidence": "",
    "SQL": "SELECT l.list_title AS movie_title FROM lists l INNER JOIN lists_users lu ON l.list_id = lu.list_id INNER JOIN lists_users r ON lu.list_id = r.list_id WHERE r.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie on the list created by user with user ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1 AND list_id = (SELECT list_id FROM lists ORDER BY list_creation_timestamp_utc 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_id = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies that a user with a trial plan has rated, ordered by the rating score?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score, r.rating_timestamp_utc 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 ru.user_trialist = 1 ORDER BY r.rating_score DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the list named 'Best Movies of the 90s' by user 'John'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_title = 'Best Movies of the 90s' AND l.user_id IN (SELECT user_id FROM lists_users WHERE user_id = (SELECT user_id FROM lists_users WHERE user_cover_image_url = 'John')) ORDER BY m.movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity of movies with at least 10 followers?",
    "evidence": "",
    "SQL": "SELECT AVG(m.movie_popularity) AS avg_popularity FROM movies m JOIN lists l ON m.movie_id = l.list_id WHERE l.list_followers >= 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies that have been rated by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, r.rating_score, r.critic, r.critic_likes, r.critic_comments 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 movies with the highest popularity in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT movie_id, movie_title, movie_popularity FROM movies WHERE movie_id IN (SELECT DISTINCT movie_id FROM lists WHERE list_id IN (SELECT list_id FROM lists_users)) ORDER BY movie_popularity DESC"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among the users who follow the list with ID 1?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON NOT EXISTS (SELECT 1 FROM ratings WHERE ratings.user_id = lu.user_id AND ratings.movie_id = m.movie_id) WHERE l.list_id = 1 ORDER BY m.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 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 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 all movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been added to user John's list by user Jane?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.user_id IN (SELECT user_id FROM lists_users WHERE user_id = 'John' OR user_id = 'Jane') AND l.list_id IN (SELECT list_id FROM lists_users WHERE user_id = 'Jane' AND user_id = 'John')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies based on user ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id GROUP BY movie_title ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies has a user with the user ID 1 rated in 2022?",
    "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.user_id = 1 AND strftime('%Y', ratings.rating_timestamp_utc) = '2022'"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists do user 1 have?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies added by the user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN lists_users lu ON m.movie_id = lu.list_id WHERE lu.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles that have more than 5 comments?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_comments > 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 movie with the highest rating?",
    "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)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most number of followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists 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 titles of all lists that contain movies with a rating greater than 8?",
    "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 IN (SELECT user_id FROM ratings WHERE rating_score > 8)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of movies created by Christopher Nolan?",
    "evidence": "",
    "SQL": "SELECT m.movie_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 JOIN movies m ON ru.user_id = m.director_id WHERE m.director_name = 'Christopher Nolan'"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies in the list 'Favorite Films' have a rating above 8?",
    "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 = 'Favorite Films' AND r.rating_score > 8"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE list_followers > 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating on the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_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 JOIN movies AS m ON r.movie_id = m.movie_id WHERE l.list_followers = (SELECT MAX(list_followers) FROM lists) AND r.rating_score = (SELECT MAX(rating_score) FROM ratings) GROUP BY m.movie_title LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists contain movies released in the year 2000 or later?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_movie_number > 2000"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies by list title?",
    "evidence": "",
    "SQL": "SELECT list_title, COUNT(*) as count FROM lists JOIN movies ON lists.list_movie_number = movies.movie_id GROUP BY list_title ORDER BY count DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest popularity rating 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 3 movies with the highest ratings?",
    "evidence": "",
    "SQL": "SELECT * FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie on the list created by the user with id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1 ORDER BY list_movie_number LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for movies in the list with the most followers?",
    "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 JOIN movies m ON r.movie_id = m.movie_id WHERE l.list_followers = (SELECT MAX(list_followers) FROM lists) GROUP BY r.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are rated by users with more than one payment method?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies, ratings, ratings_users WHERE ratings.user_id = ratings_users.user_id AND ratings_users.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_id = (SELECT MAX(rating_id) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular movies, considering the number of followers, and sorted by popularity?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_popularity, l.list_followers FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON lu.user_id = m.director_id ORDER BY m.movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the lists created by users with payment methods?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_has_payment_method = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in a list with the most followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_movie_number = m.movie_id WHERE l.list_followers = (SELECT MAX(l2.list_followers) FROM lists l2) ORDER BY m.movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the top 10 most popular lists?",
    "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_movie_number = m.movie_id WHERE lu.user_trialist = 1 AND lu.user_subscriber = 1 ORDER BY l.list_followers DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the 'list' table?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists created by users named 'John'?",
    "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 lists_users WHERE user_cover_image_url LIKE '%John%'))"
  },
  {
    "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_id IN (SELECT movie_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))"
  },
  {
    "db_id": "movie_platform",
    "question": "Which users have created lists with more than 10 movies and have also rated at least 5 movies?",
    "evidence": "",
    "SQL": "SELECT l.user_id FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE l.list_movie_number > 10 AND EXISTS (SELECT 1 FROM ratings r WHERE r.user_id = lu.user_id AND r.rating_score IS NOT NULL LIMIT 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a list of at least 5 followers?",
    "evidence": "",
    "SQL": "SELECT * FROM movies JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_followers >= 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 lists with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists that contain the movie with title 'Toy Story'?",
    "evidence": "",
    "SQL": "SELECT l.list_title FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id WHERE NOT EXISTS (SELECT 1 FROM lists_users lu2 WHERE lu2.list_id = l.list_id AND lu2.user_id = (SELECT user_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id NOT IN (SELECT user_id FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title = 'Toy Story')))))"
  },
  {
    "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 are the titles of movies that have been listed in more than one user's list?",
    "evidence": "",
    "SQL": "SELECT distinct m.movie_title FROM movies m JOIN lists l ON m.movie_id IN (SELECT movie_id FROM lists WHERE list_id IN (SELECT list_id FROM lists_users)) GROUP BY m.movie_title HAVING COUNT(*) > 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for movies directed by Quentin Tarantino?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE m.director_name = 'Quentin Tarantino'"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are rated by users who are also followers of a specific list?",
    "evidence": "",
    "SQL": "SELECT m.* FROM ratings r, movies m, lists l, lists_users lu WHERE r.user_id = lu.user_id AND lu.list_id = l.list_id AND l.list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies with a rating score more than 4 in a list created by a user with a trial subscription?",
    "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 r.rating_score > 4 AND lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in each list?",
    "evidence": "",
    "SQL": "SELECT lists.list_title, movies.movie_title FROM lists, movies, lists_users WHERE lists.user_id = lists_users.user_id AND lists.list_id = lists_users.list_id AND movies.movie_id = (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(rating_id) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the lists that a specific user with the user ID 1 has followed?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_id IN (SELECT list_id FROM lists_users WHERE user_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies that have a rating with a score of 4 or higher?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings, movies WHERE rating_score >= 4 AND ratings.movie_id = movies.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 are the titles of the lists owned by a user with a trial subscription?",
    "evidence": "",
    "SQL": "SELECT DISTINCT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_subscriber = 1 AND lu.user_eligible_for_trial = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the most popular movie in a user's watched list?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users) AND list_id IN (SELECT list_id FROM lists WHERE user_id IN (SELECT user_id FROM lists_users) AND EXISTS (SELECT * FROM ratings WHERE movie_id = (SELECT movie_id FROM movies ORDER BY movie_popularity DESC LIMIT 1)) ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are included in the most popular lists?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(*) as count FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.list_movie_number = m.movie_id GROUP BY m.movie_title ORDER BY count DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists have a list_title that starts with 'The'? ",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_title LIKE 'The%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list of movies released in the year 2000 or later that are part of a list and have been rated by a subscriber?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, l.list_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 m.movie_release_year >= 2000 AND lu.user_subscriber = 1 GROUP BY m.movie_title, m.movie_release_year, l.list_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id JOIN lists ON movies.movie_id = lists.list_movie_number"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the top 10 most popular movies in the database that have more than 10,000 ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY COUNT(rating_id) DESC LIMIT 10) AND movie_popularity > 10000"
  },
  {
    "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 list titles of all lists that have more than 50 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 50"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in a list?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists JOIN movies ON lists.list_id = movies.movie_id ORDER BY lists.list_id LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all lists that have at least 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers >= 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list of movies rated by the user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_id = (SELECT user_id FROM lists_users WHERE list_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies with the highest ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id ORDER BY r.rating_score DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the most popular movie 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 list with the most followers among all lists in the database?",
    "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 5 movies in the 'lists' table with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers IN (SELECT list_followers FROM lists ORDER BY list_followers DESC LIMIT 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the top 5 most popular lists?",
    "evidence": "",
    "SQL": "SELECT DISTINCT movies.movie_title FROM lists, movies WHERE movies.movie_id IN (SELECT list_movie_number FROM lists WHERE list_followers > 0 ORDER BY list_followers DESC LIMIT 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of all movies in the list of lists_users with user_id = 1?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 1) AND movie_id IN (SELECT movie_id FROM lists WHERE user_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 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 first movie in the top 10 movies with the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists) LIMIT 1) ORDER BY list_movie_number 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 average popularity of the movies listed by a user with ID 1?",
    "evidence": "",
    "SQL": "SELECT AVG(movies.movie_popularity) AS avg_popularity FROM movies INNER JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in the list of movies with most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (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 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 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles in the list with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies rated by users in the 'Netflix' list?",
    "evidence": "",
    "SQL": "SELECT movie_title 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.list_id IN (SELECT list_id FROM lists WHERE list_title = 'Netflix') ORDER BY movie_title"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been rated by subscribers and have a rating score of at least 80?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, r.rating_score FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.user_subscriber = 1 AND r.rating_score >= 80"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie rated highest by users who follow a particular list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists, lists_users, ratings WHERE lists.list_id = lists_users.list_id AND lists_users.user_id = ratings.user_id AND lists.list_followers > 0 ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity among all the movies in the 'lists' 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 that the user with ID 1 has rated?",
    "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_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie on the 'Movie Buffs' list?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists INNER JOIN movies ON lists.list_movie_number = movies.movie_id WHERE list_id IN (SELECT list_id FROM lists WHERE list_title = 'Movie Buffs') ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the movie title of the top 3 most followed lists?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists AS l INNER JOIN lists_users AS lu ON l.list_id = lu.list_id INNER JOIN movies AS m ON lu.user_id IN (SELECT user_id FROM lists_users WHERE list_id IN (SELECT list_id FROM lists ORDER BY list_followers DESC LIMIT 3)) ORDER BY m.movie_title LIMIT 3"
  },
  {
    "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 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 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 first movie in 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) ORDER BY list_movie_number LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of a movie with a title matching 'Star Wars'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_title LIKE '%Star Wars%')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies that a user with id 1 has rated?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, r.rating_score FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_id = 1 ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 highest-rated movies in the lists_users table?",
    "evidence": "",
    "SQL": "SELECT movie_title, AVG(rating_score) AS avg_rating FROM ratings, movies WHERE ratings.movie_id = movies.movie_id AND user_id IN (SELECT user_id FROM lists_users) GROUP BY movie_title ORDER BY avg_rating DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 movies in terms of popularity?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies ORDER BY movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average popularity rating of the top 5 movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT AVG(m.movie_popularity) FROM movies m JOIN lists l ON m.movie_id = l.list_movie_number ORDER BY m.movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for the top 5 movies by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) AS average_rating FROM ratings JOIN lists_users ON ratings.user_id = lists_users.user_id WHERE lists_users.user_has_payment_method = 1 GROUP BY movie_id ORDER BY rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the lists that contain at least one movie released before 2000?",
    "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 IN (SELECT list_id FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies WHERE movie_release_year < 2000))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON movies.movie_id = ratings.movie_id WHERE ratings.rating_id IN (SELECT rating_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)) 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": "Which movies have been rated by users who are also subscribed?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, r.rating_score FROM movies m, ratings r, ratings_users ru WHERE m.movie_id = r.movie_id AND r.user_id = ru.user_id AND ru.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 most popular movies in the given database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "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, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are followed by user with ID 1?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies INNER JOIN lists_users ON movies.movie_id = lists_users.list_id INNER JOIN lists ON lists_users.list_id = lists.list_id WHERE lists_users.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles in the list with title 'My Favorite Movies'?",
    "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 = 'My Favorite Movies'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that have been favorited by at least one user?",
    "evidence": "",
    "SQL": "SELECT DISTINCT movie_title FROM movies INNER JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_followers > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles with at least 5 comments in the 'Top Movies' list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_title = 'Top Movies' AND l.list_comments >= 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title, COUNT(list_id) AS followers FROM lists JOIN movies ON lists.list_id = movies.movie_id GROUP BY movie_title ORDER BY followers DESC LIMIT 3"
  },
  {
    "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 WHERE movie_id = (SELECT movie_id FROM ratings GROUP BY movie_id ORDER BY rating_score DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with ID 123?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT DISTINCT list_movie_number, list_title FROM lists ORDER BY list_movie_number DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 rated movies in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title, AVG(rating_score) as rating FROM lists_users INNER JOIN lists ON lists_users.list_id = lists.list_id INNER JOIN ratings ON lists_users.user_id = ratings.user_id INNER JOIN movies ON ratings.movie_id = movies.movie_id GROUP BY movie_title ORDER BY rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the highest rating?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id GROUP BY m.movie_title ORDER BY r.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 WHERE 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 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 JOIN ratings ON movies.movie_id = ratings.movie_id WHERE rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies that have been liked by a user who also has a payment method?",
    "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"
  },
  {
    "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 m INNER JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in the list with the most followers?",
    "evidence": "",
    "SQL": "SELECT AVG(r.rating_score) FROM lists, ratings r WHERE lists.list_id = r.movie_id AND lists.list_followers = (SELECT MAX(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(*) DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most users who have rated it?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies JOIN ratings ON 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 are the list titles for users who have created more than 5 lists?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id IN (SELECT user_id FROM lists_users GROUP BY user_id HAVING COUNT(list_id) > 5)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are listed in a list with at least 10 followers?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers >= 10 AND list_movie_number > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list 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 average rating of movies in the list 'Top 100' by user with id '1'?",
    "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_id = (SELECT list_id FROM lists WHERE list_title = 'Top 100') AND lu.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating for movies listed by user with id 123?",
    "evidence": "",
    "SQL": "SELECT AVG(r.rating_score) AS average_rating FROM ratings r JOIN lists_users lu ON r.user_id = lu.user_id WHERE lu.user_id = 123"
  },
  {
    "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) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the number of movies in the list with id 1 that were released after 2010?",
    "evidence": "",
    "SQL": "SELECT COUNT(*) FROM lists INNER JOIN movies ON lists.list_id = 1 AND lists.list_movie_number = movies.movie_id AND movies.movie_release_year > 2010"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating that has a director and a release year?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id=r.movie_id WHERE r.rating_score>=(SELECT MAX(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_id IS NOT NULL AND movie_release_year IS NOT NULL)) AND m.director_id IS NOT NULL AND m.movie_release_year IS NOT NULL"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the lists that have at least 3 ratings?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id HAVING COUNT(DISTINCT user_id) >= 3)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the lists table?",
    "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 most popular movies among users who have a trial subscription?",
    "evidence": "",
    "SQL": "SELECT movie_title, COUNT(*) AS popularity FROM ratings_users, ratings, movies WHERE ratings_users.user_id = ratings.user_id AND ratings.movie_id = movies.movie_id AND ratings.user_trialist = 1 GROUP BY movie_title ORDER BY 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_movie_number, list_title FROM lists ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the top 5 rated movies in the list titled 'Top Rated' owned by user 'user1'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id 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 = 'Top Rated' AND lu.user_id = 'user1' ORDER BY r.rating_score 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 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 title of the movie with the most followers?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies with more than 5000 followers in 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 > 5000"
  },
  {
    "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 that has been most frequently rated by users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id GROUP BY m.movie_title ORDER BY COUNT(r.rating_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are made by the user with ID 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are created by a user with the name 'John Doe'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_cover_image_url LIKE '%John%') AND user_cover_image_url LIKE '%Doe%')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies rated by subscribers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) AS average_rating 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 GROUP BY m.movie_title ORDER BY average_rating 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, ratings WHERE movies.movie_id = ratings.movie_id AND ratings.rating_score = (SELECT MAX(rating_score) FROM ratings) LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are managed by a user who has a trial subscription?",
    "evidence": "",
    "SQL": "SELECT DISTINCT l.list_title FROM lists l, lists_users lu WHERE lu.user_id = l.user_id AND lu.user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies in the list that are rated above 3 and also rated by a user who is a subscriber?",
    "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 r.rating_score > 3 AND lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 lists by popularity?",
    "evidence": "",
    "SQL": "SELECT * FROM lists ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have been 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"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list names that contain movies directed by Quentin Tarantino?",
    "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 user_cover_image_url = (SELECT user_cover_image_url FROM lists_users WHERE user_id IN (SELECT user_id FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE director_name = 'Quentin Tarantino')))))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies listed in the list with title 'action movies'?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN movies m ON l.list_id = m.movie_id WHERE l.list_title = 'action movies' ORDER BY m.movie_release_year"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies in the 'lists' table, sorted by their list movie number?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_movie_number IS NOT NULL ORDER BY list_movie_number DESC"
  },
  {
    "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 movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies rated highest by users in the top 10 lists?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_popularity, COUNT(r.rating_id) AS rating_count FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON lu.user_id = m.director_id JOIN ratings r ON m.movie_id = r.movie_id WHERE l.list_followers >= 10 GROUP BY m.movie_title, m.movie_popularity ORDER BY rating_count DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title for the list with the most number of 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 movies from users with the most followers in the lists table?",
    "evidence": "",
    "SQL": "SELECT movie_title, COUNT(list_followers) FROM lists, movies WHERE lists.list_id = movies.movie_id GROUP BY movie_title ORDER BY COUNT(list_followers) 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, ratings WHERE movies.movie_id = ratings.movie_id ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average number of followers of all lists in the database?",
    "evidence": "",
    "SQL": "SELECT AVG(list_followers) FROM lists"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users with a trial subscription?",
    "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"
  },
  {
    "db_id": "movie_platform",
    "question": "Which lists are made by users who have paid for subscription?",
    "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 is the list title of the movie with the highest rating and most comments?",
    "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_trialist = 1) AND list_id = (SELECT list_id FROM ratings WHERE rating_score = (SELECT MAX(rating_score) FROM ratings))) ORDER BY list_comments DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that have been added to a list by a user who has a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id JOIN movies m ON l.list_movie_number = m.movie_id WHERE lu.user_has_payment_method = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity in the movie list created by a user named 'a'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies INNER JOIN lists ON movies.movie_id = lists.list_movie_number WHERE lists.list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists WHERE list_title LIKE '%a%')) ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies that are also in the lists created by users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings_users ru ON m.movie_id = ru.user_id JOIN lists_users lu ON ru.user_id = lu.user_id WHERE lu.user_subscriber = 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 list of movie titles with a release year more than 2010 and a popularity greater than 500, from the list of movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_release_year > 2010 AND movie_popularity > 500"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all the movies in the list with the ID 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists WHERE list_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating and directed by Martin Scorsese?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE m.director_name = 'Martin Scorsese' ORDER BY r.rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have at least 3 movies and have been updated in the last 30 days?",
    "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_update_timestamp_utc > DATE('now', '-30 days')) GROUP BY list_id HAVING COUNT(DISTINCT user_id) > 3)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of lists that have more than 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 movie that has 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 are the list titles that have more than 50 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_followers > 50"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of lists created by users who have both a trialist and a subscriber account?",
    "evidence": "",
    "SQL": "SELECT DISTINCT l.list_title FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id WHERE lu.user_trialist = 1 AND lu.user_subscriber = 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 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 ORDER BY list_followers DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the most popular movie in a list with the highest number of followers?",
    "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 ORDER BY l.list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular movies in the lists?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_popularity FROM movies INNER JOIN lists ON lists.list_id = movies.movie_id WHERE list_id IN (SELECT list_id FROM lists WHERE list_movie_number = (SELECT COUNT(*) FROM lists WHERE list_id = lists.list_id)) ORDER BY movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "Which list contains the most number of followers?",
    "evidence": "",
    "SQL": "SELECT list_id, list_followers FROM lists ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that has the most followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM ratings_users WHERE user_id IN (SELECT user_id FROM ratings WHERE rating_score > 3)) ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that is most followed by users?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT list_movie_number FROM lists GROUP BY list_movie_number ORDER BY COUNT(*) DESC LIMIT 1) "
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the first movie in the list that has more than 5 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 WHERE list_followers > 5) 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 IN (SELECT movie_id FROM ratings ORDER BY rating_score DESC LIMIT 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists are following the movie 'The Shawshank Redemption'?",
    "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 = 'The Shawshank Redemption')))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of all movies that are in the lists of at least 5 users?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id 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 HAVING COUNT(list_id) >= 5)))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that have more than 10,000 ratings and have been rated by users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m, ratings r WHERE r.movie_id = m.movie_id AND r.user_has_payment_method = 1 AND r.rating_id IN (SELECT rating_id FROM ratings GROUP BY rating_id HAVING COUNT(rating_id) > 10000)"
  },
  {
    "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 movie title of the movie with the most followers in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM lists 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 is the title of the movie that has 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 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 average rating score of movies directed by Quentin Tarantino?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings, movies WHERE movies.director_name = 'Quentin Tarantino' AND ratings.movie_id = movies.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers in a list?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists, movies WHERE lists.list_movie_number = movies.movie_id AND lists.list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are in the top 5 most popular lists in the last week?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l, lists_users lu, movies m WHERE lu.list_id = l.list_id AND lu.user_id = l.user_id AND l.list_update_timestamp_utc >= DATE('now', '-7 days') AND m.movie_id = l.list_movie_number ORDER BY l.list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list of movies that the user with id 123 has favorited?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN lists_users lu ON m.movie_id = lu.list_id WHERE lu.user_id = 123"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in a list with more than 2 followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM lists l JOIN ratings_users ru ON l.user_id = ru.user_id JOIN movies m ON l.list_id = m.movie_id WHERE l.list_followers > 2"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of a movie with a release year greater than 2000?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM movies WHERE movie_release_year > 2000)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies in the list with the highest number of followers?",
    "evidence": "",
    "SQL": "SELECT l.list_title, m.movie_title, m.movie_popularity, COUNT(*) AS followers_count FROM lists l, movies m WHERE l.list_movie_number = m.movie_id AND l.list_followers > 0 GROUP BY l.list_title, m.movie_title ORDER BY followers_count DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in the list of movies with the highest ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, AVG(r.rating_score) as average_rating FROM ratings r JOIN movies m ON r.movie_id = m.movie_id GROUP BY m.movie_title ORDER BY average_rating DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies are popular among users with a payment method?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_release_year, m.movie_popularity FROM movies m JOIN ratings_users ru ON m.movie_id = ru.user_id WHERE ru.user_has_payment_method = 1"
  },
  {
    "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 average rating of all movies in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings r INNER JOIN lists l ON r.movie_id = l.list_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest popularity that is listed by the user with user_id 1?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies) AND movie_id IN (SELECT movie_id FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id WHERE lists_users.user_id = 1)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movie titles of the lists that have more than 10 followers?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM lists_users GROUP BY list_id HAVING COUNT(list_id) > 10)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles in the list with the id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the movies that are also rated by the user with user_id 123?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE user_id = 123)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the most popular movie title in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists ORDER BY list_followers DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list 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 in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_movie_number IN (SELECT MAX(list_movie_number) FROM lists GROUP BY list_id)) ORDER BY movie_popularity DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 most popular movies listed in a user's list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(m.movie_title) AS popularity FROM lists_users lu JOIN lists l ON lu.list_id = l.list_id JOIN movies m ON l.list_movie_number = m.movie_id GROUP BY m.movie_title ORDER BY popularity 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 is the title of the most popular movie among users who have a payment method?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists_users, ratings_users WHERE lists_users.user_id = ratings_users.user_id AND ratings_users.user_has_payment_method = 1 ORDER BY ratings_users.user_trialist DESC LIMIT 1"
  },
  {
    "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 = (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies from the lists with more than 5 followers?",
    "evidence": "",
    "SQL": "SELECT movie_title, list_followers FROM lists, movies WHERE lists.list_id = movies.movie_id AND list_followers > 5 ORDER BY list_followers DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies in a list titled 'Popular Movies'?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists WHERE lists.list_title = 'Popular Movies' AND movies.movie_id = lists.list_movie_number ORDER BY movie_popularity DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 5 movies with the most ratings?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM ratings JOIN movies ON ratings.movie_id = movies.movie_id GROUP BY movie_title ORDER BY COUNT(rating_id) DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the lists with the title 'Movie Buff' created by user 'John'? ",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists, movies, lists_users WHERE lists.list_title = 'Movie Buff' AND lists_users.list_id = lists.list_id AND lists_users.user_id = lists.user_id AND movies.movie_id = lists.list_movie_number"
  },
  {
    "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 GROUP BY movie_title ORDER BY rating_score DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest average rating?",
    "evidence": "",
    "SQL": "SELECT * FROM ratings GROUP BY movie_id ORDER BY AVG(rating_score) DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who have also created a list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_id FROM movies m JOIN ratings r ON m.movie_id = r.movie_id JOIN lists_users lu ON r.user_id = lu.user_id JOIN lists l ON lu.list_id = l.list_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are in the top 10 of the most popular lists?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists JOIN movies ON lists.list_movie_number = movies.movie_id WHERE lists.list_followers > 100 ORDER BY lists.list_followers DESC LIMIT 10"
  },
  {
    "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 titles of lists with more than 10 followers that contain the movie 'Inception'?",
    "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 IN (SELECT list_id FROM lists WHERE list_movie_number IN (SELECT movie_id FROM movies WHERE movie_title = 'Inception'))) AND list_followers > 10)"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are part of a list with a title containing the word 'best'?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM lists LEFT JOIN lists_users ON lists.list_id = lists_users.list_id LEFT JOIN movies ON lists.list_movie_number = movies.movie_id WHERE lists.list_title LIKE '%best%'"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies with the highest popularity in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies ORDER BY movie_popularity DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most number of followers in a list?",
    "evidence": "",
    "SQL": "SELECT list_title, list_movie_number FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the most popular movies in the 'lists' table by the number of followers?",
    "evidence": "",
    "SQL": "SELECT list_title, COUNT(list_followers) as followers_count FROM lists GROUP BY list_title ORDER BY followers_count DESC LIMIT 10"
  },
  {
    "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 are the titles of all lists that have at least one movie rated by the same user?",
    "evidence": "",
    "SQL": "SELECT L.list_title FROM lists L, ratings R, lists_users LU, ratings_users RU WHERE L.list_id = LU.list_id AND LU.user_id = RU.user_id AND R.user_id = RU.user_id GROUP BY L.list_title HAVING COUNT(R.movie_id) > 0"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie that a user with the username 'username' has rated and has a rating score of 5?",
    "evidence": "",
    "SQL": "SELECT M.movie_title FROM ratings R, movies M, lists_users LU WHERE R.user_id = LU.user_id AND LU.user_id = 'username' AND R.rating_score = 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies in a list titled 'Top 100 Comedies'?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE movie_id IN (SELECT movie_id FROM lists WHERE list_title = 'Top 100 Comedies') GROUP BY movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies in the list with ID 1 are rated by users who are also followers of that list?",
    "evidence": "",
    "SQL": "SELECT movies.movie_title FROM movies, lists, lists_users, ratings WHERE lists.list_id = lists_users.list_id AND lists_users.list_id = 1 AND ratings.user_id = lists_users.user_id AND lists_users.list_id = ratings.movie_id"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the first movie in a list of a subscriber user?",
    "evidence": "",
    "SQL": "SELECT list_title, movie_title FROM lists JOIN lists_users ON lists.list_id = lists_users.list_id JOIN movies ON lists.list_movie_number = movies.movie_id WHERE lists_users.user_subscriber = 1 AND lists.list_id IN (SELECT list_id FROM lists_users WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_subscriber = 1 ORDER BY lists_users.list_update_date_utc LIMIT 1))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies that have been rated by a specific user?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.user_id = [user_id]"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the users who have updated their lists after 2022-01-01 and before 2022-12-31?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_update_timestamp_utc BETWEEN '2022-01-01' AND '2022-12-31' AND user_id IN (SELECT user_id FROM lists_users WHERE list_update_date_utc BETWEEN '2022-01-01' AND '2022-12-31')"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the most followers?",
    "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_movie_number = m.movie_id WHERE lu.list_id IN (SELECT list_id FROM lists WHERE list_followers = (SELECT MAX(list_followers) FROM lists)) GROUP BY m.movie_title LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 3 movies with the highest rating in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies INNER JOIN ratings ON movies.movie_id = ratings.movie_id ORDER BY ratings.rating_score DESC LIMIT 3"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest popularity?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT movie_id FROM movies WHERE movie_popularity = (SELECT MAX(movie_popularity) FROM movies))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the lists that have the most 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 title of the movie with the highest rating among the movies listed in the 'lists' table?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies WHERE movie_id IN (SELECT movie_id FROM ratings WHERE rating_id IN (SELECT max(rating_id) FROM ratings GROUP BY movie_id))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of movies that have been added to at least one list by users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT DISTINCT movie_title FROM movies INNER JOIN ratings_users ON movies.movie_id = ratings_users.user_id INNER JOIN lists_users ON ratings_users.user_id = lists_users.user_id INNER JOIN lists ON lists_users.list_id = lists.list_id WHERE ratings_users.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title for 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 names of movies with a rating score greater than 8?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM movies m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score > 8"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists created by 'user1' contain movies released after 2010?",
    "evidence": "",
    "SQL": "SELECT list_id FROM lists WHERE user_id IN (SELECT user_id FROM lists_users WHERE user_id = 'user1') AND list_movie_number > 2010"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in all lists created by users who are not trialists?",
    "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.user_trialist = 0 GROUP BY m.movie_title ORDER BY COUNT(lu.list_id) DESC LIMIT 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the list titles of the lists created by user with user ID 2?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 2"
  },
  {
    "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 list title of the movie with the highest rating score?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE list_id IN (SELECT list_id FROM ratings WHERE rating_id IN (SELECT MAX(rating_id) 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 movie that has the highest rating in the 'lists' table?",
    "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 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": "Which movies were rated by users who are subscribed?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN ratings_users ru ON r.user_id = ru.user_id JOIN lists_users lu ON ru.user_id = lu.user_id JOIN lists l ON lu.list_id = l.list_id JOIN movies m ON l.list_movie_number = m.movie_id WHERE lu.user_subscriber = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies are listed by the user who created a list titled 'Favorite Movies'?",
    "evidence": "",
    "SQL": "SELECT m.* FROM lists l JOIN movies m ON l.list_movie_number = m.movie_id WHERE l.user_id IN (SELECT user_id FROM lists_users WHERE list_title = 'Favorite Movies')"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies that have the highest ratings?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_id, r.rating_score FROM movies m JOIN ratings r ON m.movie_id = r.movie_id ORDER BY r.rating_score DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movies in the list of user 1?",
    "evidence": "",
    "SQL": "SELECT m.* FROM movies m JOIN lists_users lu ON m.movie_id = lu.list_id WHERE lu.user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What lists of movies does user 1 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 = 1"
  },
  {
    "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_followers = (SELECT MAX(list_followers) FROM lists)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the title of the movie with the highest rating in the list followed by 'Bob'? ",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies m, lists l, lists_users lu WHERE l.list_id = lu.list_id AND lu.user_id = 3 AND m.movie_id = (SELECT movie_id FROM ratings r WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings r2 WHERE r2.movie_id = m.movie_id))"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 10 most popular movies in a user's list with more than 10 followers?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, m.movie_popularity FROM lists l JOIN lists_users lu ON l.list_id = lu.list_id JOIN movies m ON l.list_movie_number = m.movie_id WHERE l.list_followers > 10 ORDER BY m.movie_popularity DESC LIMIT 10"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles of the lists owned by the user with id 1?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists WHERE user_id = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What are all the movies in the database?",
    "evidence": "",
    "SQL": "SELECT * FROM movies"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the titles of the top 10 most popular movies on a specific list?",
    "evidence": "",
    "SQL": "SELECT movie_title FROM movies, lists WHERE lists.list_id = movies.movie_id AND lists.list_id IN (SELECT list_id FROM lists WHERE list_followers > 10 ORDER BY list_followers DESC LIMIT 10)"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the list title of the movie with the highest popularity in the given database?",
    "evidence": "",
    "SQL": "SELECT list_title FROM lists INNER JOIN movies ON lists.list_movie_number = movies.movie_id WHERE movies.movie_popularity = (SELECT MAX(movie_popularity) FROM movies)"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the top 5 movies in a specific list with more than 5 followers and a list title that starts with the letter 'A'?",
    "evidence": "",
    "SQL": "SELECT * FROM lists WHERE list_followers > 5 AND list_title LIKE 'A%' ORDER BY list_followers DESC LIMIT 5"
  },
  {
    "db_id": "movie_platform",
    "question": "What are the movie titles that have a rating score of more than 8 and have been rated by at least 100 users?",
    "evidence": "",
    "SQL": "SELECT m.movie_title FROM ratings r JOIN movies m ON r.movie_id = m.movie_id WHERE r.rating_score > 8 GROUP BY m.movie_title HAVING COUNT(r.user_id) > 100"
  },
  {
    "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 5 most popular movies among the users who have at least 2 followers in a list?",
    "evidence": "",
    "SQL": "SELECT m.movie_title, COUNT(l.list_id) AS popularity FROM lists l JOIN movies m ON l.list_id = (SELECT list_id FROM lists_users WHERE list_followers >= 2) GROUP BY m.movie_title ORDER BY popularity DESC LIMIT 5"
  },
  {
    "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 m JOIN ratings r ON m.movie_id = r.movie_id WHERE r.rating_score = (SELECT MAX(rating_score) FROM ratings)"
  },
  {
    "db_id": "movie_platform",
    "question": "Which movies have been rated by users who have a payment method set?",
    "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"
  },
  {
    "db_id": "movie_platform",
    "question": "What is the average rating of movies watched by users with a trial account?",
    "evidence": "",
    "SQL": "SELECT AVG(rating_score) FROM ratings WHERE user_trialist = 1"
  },
  {
    "db_id": "movie_platform",
    "question": "What movies have a rating score of 8 or higher from users who are subscribers?",
    "evidence": "",
    "SQL": "SELECT movie_title, movie_release_year, rating_score 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 >= 8 AND ratings_users.user_subscriber = 1"
  }
]