target-benchmark/spider-queries huggingface dataset:
Database: video_game (tables: player)
Question: Give the maximum and minimum rank of the year across all players.
SQL: SELECT max(Rank_of_the_year) ,  min(Rank_of_the_year) FROM player
Database: video_game (tables: player)
Question: How many players have rank of the year smaller than 3?
SQL: SELECT count(*) FROM player WHERE Rank_of_the_year  <=  3
Database: video_game (tables: player)
Question: Count the number of players that have a rank of year of at most 3.
SQL: SELECT count(*) FROM player WHERE Rank_of_the_year  <=  3
Database: video_game (tables: player)
Question: List all player names in ascending alphabetical order.
SQL: SELECT Player_name FROM player ORDER BY Player_name ASC
Database: video_game (tables: player)
Question: What are the names of all players in alphabetical order?
SQL: SELECT Player_name FROM player ORDER BY Player_name ASC
Database: video_game (tables: player)
Question: List names and colleges of all players in descending order of rank of the year.
SQL: SELECT Player_name ,  College FROM player ORDER BY Rank_of_the_year DESC
Database: video_game (tables: player)
Question: What are the names and colleges of all players, ordered by rank of year descending?
SQL: SELECT Player_name ,  College FROM player ORDER BY Rank_of_the_year DESC
Database: video_game (tables: game, game_player, player)
Question: Please show the names and rank of players that have played the game titled "Super Mario World".
SQL: SELECT T3.Player_name ,  T3.rank_of_the_year FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T1.Title  =  "Super Mario World"
Database: video_game (tables: game, game_player, player)
Question: What are the names and ranks of players who have played the game with the title "Super Mario World"?
SQL: SELECT T3.Player_name ,  T3.rank_of_the_year FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T1.Title  =  "Super Mario World"
Database: video_game (tables: game, game_player, player)
Question: Show the distinct developer of games played by players that go to college "Auburn".
SQL: SELECT DISTINCT T1.Developers FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.College  =  "Auburn"
Database: video_game (tables: game, game_player, player)
Question: What are the different developers of games that are played by players that attend Auburn college?
SQL: SELECT DISTINCT T1.Developers FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.College  =  "Auburn"
Database: video_game (tables: game, game_player, player)
Question: What is the average number of units sold in millions of games played by players with position "Guard"?
SQL: SELECT avg(Units_sold_Millions) FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.Position  =  "Guard"
Database: video_game (tables: game, game_player, player)
Question: Return the average number of units sold in millions among games played by players who have the position Guard.
SQL: SELECT avg(Units_sold_Millions) FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.Position  =  "Guard"
Database: video_game (tables: platform, game)
Question: Please list the title and platform name of games.
SQL: SELECT T1.Title ,  T2.Platform_name FROM game AS T1 JOIN platform AS T2 ON T1.Platform_ID  =  T2.Platform_ID
Database: video_game (tables: platform, game)
Question: What are the titles and platform names of all games?
SQL: SELECT T1.Title ,  T2.Platform_name FROM game AS T1 JOIN platform AS T2 ON T1.Platform_ID  =  T2.Platform_ID
Database: video_game (tables: platform, game)
Question: Please list the title of games with platforms that have market district in Asia or USA.
SQL: SELECT T1.Title FROM game AS T1 JOIN platform AS T2 ON T1.Platform_ID  =  T2.Platform_ID WHERE T2.Market_district  =  "Asia" OR T2.Market_district  =  "USA"
Database: video_game (tables: platform, game)
Question: What are the titles of games that have platforms in the market districts of Asia or the USA?
SQL: SELECT T1.Title FROM game AS T1 JOIN platform AS T2 ON T1.Platform_ID  =  T2.Platform_ID WHERE T2.Market_district  =  "Asia" OR T2.Market_district  =  "USA"
Database: video_game (tables: game)
Question: List the name of each franchise and the number of games belonging to that franchise.
SQL: SELECT Franchise ,  COUNT(*) FROM game GROUP BY Franchise
Database: video_game (tables: game)
Question: How many games are there from each Franchise?
SQL: SELECT Franchise ,  COUNT(*) FROM game GROUP BY Franchise
Database: video_game (tables: game)
Question: List the name of franchise that have the most number of games.
SQL: SELECT Franchise FROM game GROUP BY Franchise ORDER BY COUNT(*) DESC LIMIT 1
Database: video_game (tables: game)
Question: Which franchise has the most games?
SQL: SELECT Franchise FROM game GROUP BY Franchise ORDER BY COUNT(*) DESC LIMIT 1
Database: video_game (tables: game)
Question: List the names of franchises that have at least two games.
SQL: SELECT Franchise FROM game GROUP BY Franchise HAVING COUNT(*)  >=  2
Database: video_game (tables: game)
Question: What are the names of franchises that have two or more games?
SQL: SELECT Franchise FROM game GROUP BY Franchise HAVING COUNT(*)  >=  2
Database: video_game (tables: game_player, player)
Question: List the name of players that do not play any game.
SQL: SELECT Player_name FROM player WHERE Player_ID NOT IN (SELECT Player_ID FROM game_player)
Database: video_game (tables: game_player, player)
Question: What are the names of players who do not play any games?
SQL: SELECT Player_name FROM player WHERE Player_ID NOT IN (SELECT Player_ID FROM game_player)
Database: video_game (tables: game, game_player, player)
Question: Show the title of games that are played by both players from college "Oklahoma" and players from college "Auburn".
SQL: SELECT T1.Title FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.College  =  "Oklahoma" INTERSECT SELECT T1.Title FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.College  =  "Auburn"
Database: video_game (tables: game, game_player, player)
Question: What are the titles of games that are played by players from Oklahoma college or Auburn college?
SQL: SELECT T1.Title FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.College  =  "Oklahoma" INTERSECT SELECT T1.Title FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.College  =  "Auburn"
Database: video_game (tables: game)
Question: Show all distinct franchises of games.
SQL: SELECT DISTINCT Franchise FROM game
Database: video_game (tables: game)
Question: What are all the distinct franchises?
SQL: SELECT DISTINCT Franchise FROM game
Database: video_game (tables: game, game_player, player)
Question: Show the title of games that are not played by any player who is in the Guard position.
SQL: SELECT Title FROM game EXCEPT SELECT T1.Title FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.Position  =  "Guard"
Database: video_game (tables: game, game_player, player)
Question: What are the titles of games not played by any players who play the Guard position?
SQL: SELECT Title FROM game EXCEPT SELECT T1.Title FROM game AS T1 JOIN game_player AS T2 ON T1.Game_ID  =  T2.Game_ID JOIN player AS T3 ON T2.Player_ID  =  T3.Player_ID WHERE T3.Position  =  "Guard"
Database: book_press (tables: press)
Question: list all the names of press in descending order of the profit of the year.
SQL: SELECT name FROM press ORDER BY Year_Profits_billion DESC
Database: book_press (tables: press)
Question: Sorted all the press by year profits in descending order, and return press names.
SQL: SELECT name FROM press ORDER BY Year_Profits_billion DESC
Database: book_press (tables: press)
Question: What are the names of the publishers that made more than 15 billion profits each year or 1 billion each month?
SQL: SELECT name FROM press WHERE Year_Profits_billion  >  15 OR Month_Profits_billion  >  1
Database: book_press (tables: press)
Question: Find the press whose yearly profit is more than 15 billion or whose monthly profit is more than 1 billion. Return the press names.
SQL: SELECT name FROM press WHERE Year_Profits_billion  >  15 OR Month_Profits_billion  >  1
Database: book_press (tables: press)
Question: what are the average and maximum profit of a year for all presses?
SQL: SELECT avg(Year_Profits_billion) ,  max(Year_Profits_billion) FROM press
Database: book_press (tables: press)
Question: Find the average and maximum yearly profit for each press.
SQL: SELECT avg(Year_Profits_billion) ,  max(Year_Profits_billion) FROM press
Database: book_press (tables: press)
Question: Find the name of the publisher whose monthly profit is the highest.
SQL: SELECT name FROM press ORDER BY Month_Profits_billion DESC LIMIT 1
Database: book_press (tables: press)
Question: Which press has the largest monthly profit? Give me the press name.
SQL: SELECT name FROM press ORDER BY Month_Profits_billion DESC LIMIT 1
Database: book_press (tables: press)
Question: Find the name of the publisher whose monthly profit is the highest or the lowest.
SQL: SELECT name FROM press WHERE Month_Profits_billion  =  (SELECT min(Month_Profits_billion) FROM press) OR Month_Profits_billion  =  (SELECT max(Month_Profits_billion) FROM press)
Database: book_press (tables: press)
Question: What are the names of the press that makes the highest monthly profit or the lowest monthly profit?
SQL: SELECT name FROM press WHERE Month_Profits_billion  =  (SELECT min(Month_Profits_billion) FROM press) OR Month_Profits_billion  =  (SELECT max(Month_Profits_billion) FROM press)
Database: book_press (tables: author)
Question: how many authors are under age 30?
SQL: SELECT count(*) FROM author WHERE age  <  30
Database: book_press (tables: author)
Question: Count the number of authors of age below 30.
SQL: SELECT count(*) FROM author WHERE age  <  30
Database: book_press (tables: author)
Question: find the average age of authors for each gender.
SQL: SELECT avg(age) ,  gender FROM author GROUP BY gender
Database: book_press (tables: author)
Question: For each gender, return gender and the average age of authors.
SQL: SELECT avg(age) ,  gender FROM author GROUP BY gender
Database: book_press (tables: author)
Question: find the number of authors who are older than 30 for each gender.
SQL: SELECT count(*) ,  gender FROM author WHERE age  >  30 GROUP BY gender
Database: book_press (tables: author)
Question: How many authors are of age above 30 for each gender?
SQL: SELECT count(*) ,  gender FROM author WHERE age  >  30 GROUP BY gender
Database: book_press (tables: book)
Question: List all book titles in the order of their release date from the most recent to the past.
SQL: SELECT title FROM book ORDER BY release_date DESC
Database: book_press (tables: book)
Question: Sort all the books in descending order of release date, and return the book titles.
SQL: SELECT title FROM book ORDER BY release_date DESC
Database: book_press (tables: book)
Question: Find the number of books for each series.
SQL: SELECT count(*) ,  book_series FROM book GROUP BY book_series
Database: book_press (tables: book)
Question: How many books does each book series have? Return the counts and book series.
SQL: SELECT count(*) ,  book_series FROM book GROUP BY book_series
Database: book_press (tables: book)
Question: Find the titles and publish dates of the top 5 best sale books.
SQL: SELECT title ,  release_date FROM book ORDER BY sale_amount DESC LIMIT 5
Database: book_press (tables: book)
Question: What are the 5 best books in terms of sale amount? Give me their titles and release dates.
SQL: SELECT title ,  release_date FROM book ORDER BY sale_amount DESC LIMIT 5
Database: book_press (tables: book)
Question: Find the book series that have some book selling more than 1000 and some book less 500.
SQL: SELECT book_series FROM book WHERE sale_amount  >  1000 INTERSECT SELECT book_series FROM book WHERE sale_amount  <  500
Database: book_press (tables: book)
Question: Which book series contain both books with sale amount above 1000 and books with sale amount below 500?
SQL: SELECT book_series FROM book WHERE sale_amount  >  1000 INTERSECT SELECT book_series FROM book WHERE sale_amount  <  500
Database: book_press (tables: author, book)
Question: Find the name of authors who publish their books in both "MM" and "LT" series.
SQL: SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id WHERE t2.book_series  =  'MM' INTERSECT SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id WHERE t2.book_series  =  'LT'
Database: book_press (tables: author, book)
Question: Which authors publish books in both "MM" and "LT" series? Give me the author names.
SQL: SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id WHERE t2.book_series  =  'MM' INTERSECT SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id WHERE t2.book_series  =  'LT'
Database: book_press (tables: author, book)
Question: Find the name and age of the authors who do not have any book in the record.
SQL: SELECT name ,  age FROM author WHERE author_id NOT IN (SELECT author_id FROM book)
Database: book_press (tables: author, book)
Question: Which authors in the record have not published any books ? Give me their names .
SQL: select name from author where author_id not in (select author_id from book)
Database: book_press (tables: author, book)
Question: Find the names of authors who have more than one book in the database.
SQL: SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id GROUP BY t2.author_id HAVING count(*)  >  1
Database: book_press (tables: author, book)
Question: Which authors have published more than 1 book according to the database? Give me their names.
SQL: SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id GROUP BY t2.author_id HAVING count(*)  >  1
Database: book_press (tables: author, book, press)
Question: Find the title, author name, and publisher name for the top 3 best sales books.
SQL: SELECT t1.name ,  t2.title ,  t3.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id JOIN press AS t3 ON t2.press_id  =  t3.press_id ORDER BY t2.sale_amount DESC LIMIT 3
Database: book_press (tables: author, book, press)
Question: What are the 3 best selling books? Show their titles, author names, and press names.
SQL: SELECT t1.name ,  t2.title ,  t3.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id JOIN press AS t3 ON t2.press_id  =  t3.press_id ORDER BY t2.sale_amount DESC LIMIT 3
Database: book_press (tables: book, press)
Question: Find the name and total book sale amount of each press.
SQL: SELECT sum(t1.sale_amount) ,  t2.name FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id GROUP BY t1.press_id
Database: book_press (tables: book, press)
Question: What are the name and total book sale amount of each press?
SQL: SELECT sum(t1.sale_amount) ,  t2.name FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id GROUP BY t1.press_id
Database: book_press (tables: book, press)
Question: Find the number of books that are sold more than 1000 for each publisher. List the press name as well.
SQL: SELECT count(*) ,  t2.name FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id WHERE sale_amount  >  1000 GROUP BY t2.name
Database: book_press (tables: book, press)
Question: For each press, return its name and the number of books that have sale amount above 1000.
SQL: SELECT count(*) ,  t2.name FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id WHERE sale_amount  >  1000 GROUP BY t2.name
Database: book_press (tables: author, book)
Question: What is the name of the author of best selling book?
SQL: SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id ORDER BY t2.sale_amount DESC LIMIT 1
Database: book_press (tables: author, book)
Question: Who wrote the best selling book? Give me the author name.
SQL: SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id ORDER BY t2.sale_amount DESC LIMIT 1
Database: book_press (tables: author, book)
Question: find the name and gender of the author who published the most books.
SQL: SELECT t1.name ,  t1.gender FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id GROUP BY t2.author_id ORDER BY count(*) DESC LIMIT 1
Database: book_press (tables: author, book)
Question: Who wrote the largest number of books? Give me the author name and gender.
SQL: SELECT t1.name ,  t1.gender FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id GROUP BY t2.author_id ORDER BY count(*) DESC LIMIT 1
Database: book_press (tables: author, book, press)
Question: Find the names of the authors who did not have any book with the "Accor" press.
SQL: SELECT name FROM author EXCEPT SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id JOIN press AS t3 ON t2.press_id  =  t3.press_id WHERE t3.name  =  'Accor'
Database: book_press (tables: author, book, press)
Question: Which authors have never published under the "Accor" press? Give me their names.
SQL: SELECT name FROM author EXCEPT SELECT t1.name FROM author AS t1 JOIN book AS t2 ON t1.author_id  =  t2.author_id JOIN press AS t3 ON t2.press_id  =  t3.press_id WHERE t3.name  =  'Accor'
Database: book_press (tables: book, press)
Question: Find the name and the yearly profit in billion for press that published more than two books.
SQL: SELECT t2.name ,  t2.Year_Profits_billion FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id GROUP BY t2.press_id HAVING count(*)  >  2
Database: book_press (tables: book, press)
Question: Find the press that published more than two books, and return its name and yearly profit in billion.
SQL: SELECT t2.name ,  t2.Year_Profits_billion FROM book AS t1 JOIN press AS t2 ON t1.press_id  =  t2.press_id GROUP BY t2.press_id HAVING count(*)  >  2
Database: cre_Doc_Workflow (tables: authors)
Question: How many authors do we have?
SQL: SELECT count(*) FROM Authors
Database: cre_Doc_Workflow (tables: authors)
Question: Show all author names.
SQL: SELECT author_name FROM Authors
Database: cre_Doc_Workflow (tables: authors)
Question: Show the names and other details for all authors.
SQL: SELECT author_name ,  other_details FROM Authors
Database: cre_Doc_Workflow (tables: authors)
Question: Show the other details for the author Addison Denesik.
SQL: SELECT other_details FROM Authors WHERE author_name  =  "Addison Denesik"
Database: cre_Doc_Workflow (tables: documents)
Question: Show the number of documents.
SQL: SELECT count(*) FROM Documents
Database: cre_Doc_Workflow (tables: documents)
Question: Who is the author of the document with id 4?
SQL: SELECT author_name FROM Documents WHERE document_id  =  4
Database: cre_Doc_Workflow (tables: documents)
Question: Who is the author of the document "Travel to Brazil"?
SQL: SELECT author_name FROM Documents WHERE document_name  =  "Travel to Brazil"
Database: cre_Doc_Workflow (tables: documents)
Question: How many documents does has the author Era Kerluke written?
SQL: SELECT count(*) FROM Documents WHERE author_name  =  "Era Kerluke"
Database: cre_Doc_Workflow (tables: documents)
Question: Show the names and descriptions for all documents.
SQL: SELECT document_name ,  document_description FROM Documents
Database: cre_Doc_Workflow (tables: documents)
Question: Show the ids and names for all documents by author Bianka Cummings.
SQL: SELECT document_id ,  document_name FROM Documents WHERE author_name  =  "Bianka Cummings"
Database: cre_Doc_Workflow (tables: documents, authors)
Question: Show the author name and details for the document "Travel to China".
SQL: SELECT T2.author_name ,  T2.other_details FROM Documents AS T1 JOIN Authors AS T2 ON T1.author_name  =  T2.author_name WHERE document_name  =  "Travel to China"
Database: cre_Doc_Workflow (tables: documents)
Question: Show all author names and number of documents corresponding to each.
SQL: SELECT author_name ,  count(*) FROM Documents GROUP BY author_name
Database: cre_Doc_Workflow (tables: documents)
Question: What is the name of the author with most number of documents?
SQL: SELECT author_name FROM Documents GROUP BY author_name ORDER BY count(*) DESC LIMIT 1
Database: cre_Doc_Workflow (tables: documents)
Question: Show the names for authors with at least two documents.
SQL: SELECT author_name FROM Documents GROUP BY author_name HAVING count(*)  >=  2
Database: cre_Doc_Workflow (tables: business_processes)
Question: How many business processes do we have?
SQL: SELECT count(*) FROM Business_processes
Database: cre_Doc_Workflow (tables: business_processes)
Question: Show the next process id, process name, process description for process with id 9.
SQL: SELECT next_process_id ,  process_name ,  process_description FROM Business_processes WHERE process_id  =  9
Database: cre_Doc_Workflow (tables: business_processes)
Question: What is the process name for the next process of the process with id 9?
SQL: SELECT process_name FROM Business_processes WHERE process_id  =  (SELECT next_process_id FROM Business_processes WHERE process_id  =  9)
Database: cre_Doc_Workflow (tables: process_outcomes)
Question: Show the number of process outcomes.
SQL: SELECT count(*) FROM Process_outcomes
Database: cre_Doc_Workflow (tables: process_outcomes)
Question: List the codes and descriptions for all process outcomes.
SQL: SELECT process_outcome_code ,  process_outcome_description FROM Process_outcomes
Database: cre_Doc_Workflow (tables: process_outcomes)
Question: What is the description for the process outcome code working?
SQL: SELECT process_outcome_description FROM Process_outcomes WHERE process_outcome_code  =  "working"
Database: cre_Doc_Workflow (tables: process_status)
Question: Show the number of process status.
SQL: SELECT count(*) FROM Process_status
Database: cre_Doc_Workflow (tables: process_status)
Question: List the codes and descriptions for all process status.
SQL: SELECT process_status_code ,  process_status_description FROM Process_status
Database: cre_Doc_Workflow (tables: process_status)
Question: What is the description for process status code ct?
SQL: SELECT process_status_description FROM Process_status WHERE process_status_code  =  "ct"
Database: cre_Doc_Workflow (tables: staff)
Question: How many staff do we have?
SQL: SELECT count(*) FROM Staff
Database: cre_Doc_Workflow (tables: staff)
Question: Show the ids and details for all staff.
SQL: SELECT staff_id ,  staff_details FROM Staff
Database: cre_Doc_Workflow (tables: staff)
Question: What are the details for the staff member with id 100.
SQL: SELECT staff_details FROM Staff WHERE staff_id  =  100
Database: cre_Doc_Workflow (tables: ref_staff_roles)
Question: Show the number of staff roles.
SQL: SELECT count(*) FROM Ref_staff_roles
Database: cre_Doc_Workflow (tables: ref_staff_roles)
Question: List the codes and descriptions for all staff roles.
SQL: SELECT staff_role_code ,  staff_role_description FROM Ref_staff_roles
Database: cre_Doc_Workflow (tables: ref_staff_roles)
Question: What is the description for staff role code HR?
SQL: SELECT staff_role_description FROM Ref_staff_roles WHERE staff_role_code  =  "HR"
Database: cre_Doc_Workflow (tables: documents_processes)
Question: How many documents have a process?
SQL: SELECT count(DISTINCT document_id) FROM Documents_processes
Database: cre_Doc_Workflow (tables: documents_processes)
Question: List all process ids with a document.
SQL: SELECT DISTINCT process_id FROM Documents_processes