sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: addresses 
columns : [['address id', 'number'], ['address content', 'text'], ['city', 'text'], ['zip postcode', 'text'], ['state province county', 'text'], ['country', 'text'], ['other address details', 'text']]

 -- Table: products 
columns : [['product id', 'number'], ['product details', 'text']]

 -- Table: customers 
columns : [['customer id', 'number'], ['payment method', 'text'], ['customer name', 'text'], ['date became customer', 'time'], ['other customer details', 'text']]

 -- Table: customer addresses 
columns : [['customer id', 'number'], ['address id', 'number'], ['date address from', 'time'], ['address type', 'text'], ['date address to', 'time']]

 -- Table: customer contact channels 
columns : [['customer id', 'number'], ['channel code', 'text'], ['active from date', 'time'], ['active to date', 'time'], ['contact number', 'text']]

 -- Table: customer orders 
columns : [['order id', 'number'], ['customer id', 'number'], ['order status', 'text'], ['order date', 'time'], ['order details', 'text']]

 -- Table: order items 
columns : [['order id', 'number'], ['product id', 'number'], ['order quantity', '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 are the names of customers who have purchased both products Latte and Americano?
SQL: SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Latte' INTERSECT SELECT t1.customer_name FROM customers AS t1 JOIN customer_orders AS t2 ON t1.customer_id  =  t2.customer_id JOIN order_items AS t3 ON t2.order_id  =  t3.order_id JOIN products AS t4 ON t3.product_id  =  t4.product_id WHERE t4.product_details  =  'Americano'
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 artists are there?
SQL: SELECT count(*) FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Count the number of artists.
SQL: SELECT count(*) FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 age of all music artists.
SQL: SELECT Age FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the ages of all music artists?
SQL: SELECT Age FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 average age of all artists?
SQL: SELECT avg(Age) FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the average age across all artists.
SQL: SELECT avg(Age) FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the famous titles of the artist "Triumfall"?
SQL: SELECT Famous_Title FROM artist WHERE Artist  =  "Triumfall"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the famous titles of the artist called "Triumfall".
SQL: SELECT Famous_Title FROM artist WHERE Artist  =  "Triumfall"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the distinct Famous release dates?
SQL: SELECT distinct(Famous_Release_date) FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Give the distinct famous release dates for all artists.
SQL: SELECT distinct(Famous_Release_date) FROM artist
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the dates of ceremony and the results of all music festivals
SQL: SELECT Date_of_ceremony ,  RESULT FROM music_festival
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the dates of ceremony and results for each music festival?
SQL: SELECT Date_of_ceremony ,  RESULT FROM music_festival
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the category of music festivals with result "Awarded"?
SQL: SELECT Category FROM music_festival WHERE RESULT  =  "Awarded"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the categories of music festivals that have the result "Awarded".
SQL: SELECT Category FROM music_festival WHERE RESULT  =  "Awarded"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the maximum and minimum week on top of all volumes?
SQL: SELECT max(Weeks_on_Top) ,  min(Weeks_on_Top) FROM volume
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Give the maximum and minimum weeks on top across all volumes.
SQL: SELECT max(Weeks_on_Top) ,  min(Weeks_on_Top) FROM volume
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the songs in volumes with more than 1 week on top?
SQL: SELECT Song FROM volume WHERE Weeks_on_Top  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Give the songs included in volumes that have more than 1 week on top.
SQL: SELECT Song FROM volume WHERE Weeks_on_Top  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 list all songs in volumes in ascending alphabetical order.
SQL: SELECT Song FROM volume ORDER BY Song
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the the songs in volumes, listed in ascending order?
SQL: SELECT Song FROM volume ORDER BY Song
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 artists do the volumes associate to?
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Count the number of distinct artists who have volumes.
SQL: SELECT COUNT(DISTINCT Artist_ID) FROM volume
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 date of ceremony of the volumes that last more than 2 weeks on top.
SQL: SELECT T1.Date_of_ceremony FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T2.Weeks_on_Top  >  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the dates of ceremony at music festivals corresponding to volumes that lasted more than 2 weeks on top?
SQL: SELECT T1.Date_of_ceremony FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T2.Weeks_on_Top  >  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 songs that have result "nominated" at music festivals.
SQL: SELECT T2.Song FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T1.Result  =  "Nominated"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the songs in volumes that have resulted in a nomination at music festivals?
SQL: SELECT T2.Song FROM music_festival AS T1 JOIN volume AS T2 ON T1.Volume  =  T2.Volume_ID WHERE T1.Result  =  "Nominated"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the issue dates of volumes associated with the artist "Gorgoroth"?
SQL: SELECT T2.Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.Artist  =  "Gorgoroth"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the issue dates of volumes that are by the artist named Gorgoroth.
SQL: SELECT T2.Issue_Date FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.Artist  =  "Gorgoroth"
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the songs in volumes associated with the artist aged 32 or older?
SQL: SELECT T2.Song FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  >=  32
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return names of songs in volumes that are by artists that are at least 32 years old.
SQL: SELECT T2.Song FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  >=  32
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 average weeks on top of volumes associated with the artist aged 25 or younger?
SQL: SELECT avg(T2.Weeks_on_Top) FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  25
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the average number of weeks on top for volumes by artists that are at most 25 years old.
SQL: SELECT avg(T2.Weeks_on_Top) FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T1.age  <=  25
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the famous title of the artists associated with volumes with more than 2 weeks on top?
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the famous titles for artists that have volumes that lasted more than 2 weeks on top.
SQL: SELECT T1.Famous_Title FROM artist AS T1 JOIN volume AS T2 ON T1.Artist_ID  =  T2.Artist_ID WHERE T2.Weeks_on_Top  >  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 list the age and famous title of artists in descending order of age.
SQL: SELECT Famous_Title ,  Age FROM artist ORDER BY Age DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the famous titles and ages of each artist, listed in descending order by age?
SQL: SELECT Famous_Title ,  Age FROM artist ORDER BY Age DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 famous release date of the artist with the oldest age?
SQL: SELECT Famous_Release_date FROM artist ORDER BY Age DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the famous release date for the oldest artist.
SQL: SELECT Famous_Release_date FROM artist ORDER BY Age DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 categories of the music festivals and the count.
SQL: SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the number of music festivals of each category.
SQL: SELECT Category ,  COUNT(*) FROM music_festival GROUP BY Category
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 most common result of the music festival?
SQL: SELECT RESULT FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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: Return the result that is most frequent at music festivals.
SQL: SELECT RESULT FROM music_festival GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 categories of the music festivals with count more than 1.
SQL: SELECT Category FROM music_festival GROUP BY Category HAVING COUNT(*)  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 are the categories of music festivals for which there have been more than 1 music festival?
SQL: SELECT Category FROM music_festival GROUP BY Category HAVING COUNT(*)  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: artist 
columns : [['artist id', 'number'], ['artist', 'text'], ['age', 'number'], ['famous title', 'text'], ['famous release date', 'text']]

 -- Table: volume 
columns : [['volume id', 'number'], ['volume issue', 'text'], ['issue date', 'text'], ['weeks on top', 'number'], ['song', 'text'], ['artist id', 'number']]

 -- Table: music festival 
columns : [['id', 'number'], ['music festival', 'text'], ['date of ceremony', 'text'], ['category', 'text'], ['volume', 'number'], ['result', '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 song in the volume with the maximum weeks on top?
SQL: SELECT Song FROM volume ORDER BY Weeks_on_Top DESC LIMIT 1