sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the publisher of the publication with the highest price.
SQL: SELECT Publisher FROM publication ORDER BY Price DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the publication dates of publications with 3 lowest prices.
SQL: SELECT Publication_Date FROM publication ORDER BY Price ASC LIMIT 3
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the title and publication dates of books.
SQL: SELECT T1.Title ,  T2.Publication_Date FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID  =  T2.Book_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show writers who have published a book with price more than 4000000.
SQL: SELECT T1.Writer FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID  =  T2.Book_ID WHERE T2.Price  >  4000000
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the titles of books in descending order of publication price.
SQL: SELECT T1.Title FROM book AS T1 JOIN publication AS T2 ON T1.Book_ID  =  T2.Book_ID ORDER BY T2.Price DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show publishers that have more than one publication.
SQL: SELECT Publisher FROM publication GROUP BY Publisher HAVING COUNT(*)  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show different publishers together with the number of publications they have.
SQL: SELECT Publisher ,  COUNT(*) FROM publication GROUP BY Publisher
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Please show the most common publication date.
SQL: SELECT Publication_Date FROM publication GROUP BY Publication_Date ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the writers who have written more than one book.
SQL: SELECT Writer FROM book GROUP BY Writer HAVING COUNT(*)  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the titles of books that are not published.
SQL: SELECT Title FROM book WHERE Book_ID NOT IN (SELECT Book_ID FROM publication)
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the publishers that have publications with price higher than 10000000 and publications with price lower than 5000000.
SQL: SELECT Publisher FROM publication WHERE Price  >  10000000 INTERSECT SELECT Publisher FROM publication WHERE Price  <  5000000
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the number of distinct publication dates?
SQL: SELECT COUNT (DISTINCT Publication_Date) FROM publication
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many distinct publication dates are there in our record?
SQL: SELECT COUNT (DISTINCT Publication_Date) FROM publication
-- Language PostgreSQL
        -- Tables: 
             -- Table: publication 
columns : [['publication id', 'number'], ['book id', 'number'], ['publisher', 'text'], ['publication date', 'text'], ['price', 'number']]

 -- Table: book 
columns : [['book id', 'number'], ['title', 'text'], ['issues', 'number'], ['writer', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the prices of publications whose publisher is either "Person" or "Wiley"
SQL: SELECT Price FROM publication WHERE Publisher  =  "Person" OR Publisher  =  "Wiley"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many actors are there?
SQL: SELECT count(*) FROM actor
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Count the number of actors.
SQL: SELECT count(*) FROM actor
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the name of actors in ascending alphabetical order.
SQL: SELECT Name FROM actor ORDER BY Name ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of actors, ordered alphabetically?
SQL: SELECT Name FROM actor ORDER BY Name ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the characters and duration of actors?
SQL: SELECT Character ,  Duration FROM actor
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the characters and durations for each actor.
SQL: SELECT Character ,  Duration FROM actor
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the name of actors whose age is not 20.
SQL: SELECT Name FROM actor WHERE Age != 20
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of actors who are not 20 years old?
SQL: SELECT Name FROM actor WHERE Age != 20
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the characters of actors in descending order of age?
SQL: SELECT Character FROM actor ORDER BY age DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the characters for actors, ordered by age descending.
SQL: SELECT Character FROM actor ORDER BY age DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the duration of the oldest actor?
SQL: SELECT Duration FROM actor ORDER BY Age DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the duration of the actor with the greatest age.
SQL: SELECT Duration FROM actor ORDER BY Age DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of musicals with nominee "Bob Fosse"?
SQL: SELECT Name FROM musical WHERE Nominee  =  "Bob Fosse"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the names of musicals who have the nominee Bob Fosse.
SQL: SELECT Name FROM musical WHERE Nominee  =  "Bob Fosse"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the distinct nominees of the musicals with the award that is not "Tony Award"?
SQL: SELECT DISTINCT Nominee FROM musical WHERE Award != "Tony Award"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the different nominees of musicals that have an award that is not the Tony Award.
SQL: SELECT DISTINCT Nominee FROM musical WHERE Award != "Tony Award"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show names of actors and names of musicals they are in.
SQL: SELECT T1.Name ,  T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of actors and the musicals that they are in?
SQL: SELECT T1.Name ,  T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show names of actors that have appeared in musical with name "The Phantom of the Opera".
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID WHERE T2.Name  =  "The Phantom of the Opera"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of actors who have been in the musical titled The Phantom of the Opera?
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID WHERE T2.Name  =  "The Phantom of the Opera"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show names of actors in descending order of the year their musical is awarded.
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID ORDER BY T2.Year DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of actors ordered descending by the year in which their musical was awarded?
SQL: SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID ORDER BY T2.Year DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show names of musicals and the number of actors who have appeared in the musicals.
SQL: SELECT T2.Name ,  COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many actors have appeared in each musical?
SQL: SELECT T2.Name ,  COUNT(*) FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show names of musicals which have at least three actors.
SQL: SELECT T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID HAVING COUNT(*)  >=  3
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of musicals who have at 3 or more actors?
SQL: SELECT T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID  =  T2.Musical_ID GROUP BY T1.Musical_ID HAVING COUNT(*)  >=  3
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show different nominees and the number of musicals they have been nominated.
SQL: SELECT Nominee ,  COUNT(*) FROM musical GROUP BY Nominee
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many musicals has each nominee been nominated for?
SQL: SELECT Nominee ,  COUNT(*) FROM musical GROUP BY Nominee
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Please show the nominee who has been nominated the greatest number of times.
SQL: SELECT Nominee FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Who is the nominee who has been nominated for the most musicals?
SQL: SELECT Nominee FROM musical GROUP BY Nominee ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the most common result of the musicals.
SQL: SELECT RESULT FROM musical GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the most frequent result across all musicals.
SQL: SELECT RESULT FROM musical GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the nominees that have been nominated more than two musicals.
SQL: SELECT Nominee FROM musical GROUP BY Nominee HAVING COUNT(*)  >  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Who are the nominees who have been nominated more than two times?
SQL: SELECT Nominee FROM musical GROUP BY Nominee HAVING COUNT(*)  >  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the name of musicals that do not have actors.
SQL: SELECT Name FROM musical WHERE Musical_ID NOT IN (SELECT Musical_ID FROM actor)
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of musicals who have no actors?
SQL: SELECT Name FROM musical WHERE Musical_ID NOT IN (SELECT Musical_ID FROM actor)
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the nominees that have nominated musicals for both "Tony Award" and "Drama Desk Award".
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" INTERSECT SELECT Nominee FROM musical WHERE Award  =  "Drama Desk Award"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Who are the nominees who have been nominated for both a Tony Award and a Drama Desk Award?
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" INTERSECT SELECT Nominee FROM musical WHERE Award  =  "Drama Desk Award"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the musical nominee with award "Bob Fosse" or "Cleavant Derricks".
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" OR Award  =  "Cleavant Derricks"
-- Language PostgreSQL
        -- Tables: 
             -- Table: musical 
columns : [['musical id', 'number'], ['name', 'text'], ['year', 'number'], ['award', 'text'], ['category', 'text'], ['nominee', 'text'], ['result', 'text']]

 -- Table: actor 
columns : [['actor id', 'number'], ['name', 'text'], ['musical id', 'number'], ['character', 'text'], ['duration', 'text'], ['age', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Who are the nominees who were nominated for either of the Bob Fosse or Cleavant Derricks awards?
SQL: SELECT Nominee FROM musical WHERE Award  =  "Tony Award" OR Award  =  "Cleavant Derricks"
-- Language PostgreSQL
        -- Tables: 
             -- Table: follows 
columns : [['user id', 'number'], ['follower id', 'number']]

 -- Table: tweets 
columns : [['id', 'number'], ['user id', 'number'], ['text', 'text'], ['create date', 'time']]

 -- Table: user profiles 
columns : [['uid', 'number'], ['name', 'text'], ['email', 'text'], ['partition id', 'number'], ['followers', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Find the emails of the user named "Mary".
SQL: SELECT email FROM user_profiles WHERE name  =  'Mary'
-- Language PostgreSQL
        -- Tables: 
             -- Table: follows 
columns : [['user id', 'number'], ['follower id', 'number']]

 -- Table: tweets 
columns : [['id', 'number'], ['user id', 'number'], ['text', 'text'], ['create date', 'time']]

 -- Table: user profiles 
columns : [['uid', 'number'], ['name', 'text'], ['email', 'text'], ['partition id', 'number'], ['followers', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the partition id of the user named "Iron Man".
SQL: SELECT partitionid FROM user_profiles WHERE name  =  'Iron Man'
-- Language PostgreSQL
        -- Tables: 
             -- Table: follows 
columns : [['user id', 'number'], ['follower id', 'number']]

 -- Table: tweets 
columns : [['id', 'number'], ['user id', 'number'], ['text', 'text'], ['create date', 'time']]

 -- Table: user profiles 
columns : [['uid', 'number'], ['name', 'text'], ['email', 'text'], ['partition id', 'number'], ['followers', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many users are there?
SQL: SELECT count(*) FROM user_profiles