sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 first names of all customers that live in Brazil and have an invoice.
SQL: SELECT DISTINCT T1.FirstName FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T1.country  =  "Brazil"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 different first names for customers from Brazil who have also had an invoice?
SQL: SELECT DISTINCT T1.FirstName FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T1.country  =  "Brazil"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 address of all customers that live in Germany and have invoice.
SQL: SELECT DISTINCT T1.Address FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T1.country  =  "Germany"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 addresses of customers living in Germany who have had an invoice?
SQL: SELECT DISTINCT T1.Address FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T1.country  =  "Germany"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 phone numbers of all employees.
SQL: SELECT Phone FROM EMPLOYEE
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 phone numbers for each employee?
SQL: SELECT Phone FROM EMPLOYEE
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 tracks are in the AAC audio file media type?
SQL: SELECT COUNT(*) FROM MEDIATYPE AS T1 JOIN TRACK AS T2 ON T1.MediaTypeId  =  T2.MediaTypeId WHERE T1.Name  =  "AAC audio file"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 tracks that are of the media type "AAC audio file".
SQL: SELECT COUNT(*) FROM MEDIATYPE AS T1 JOIN TRACK AS T2 ON T1.MediaTypeId  =  T2.MediaTypeId WHERE T1.Name  =  "AAC audio file"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 average duration in milliseconds of tracks that belong to Latin or Pop genre?
SQL: SELECT AVG(Milliseconds) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId  =  T2.GenreId WHERE T1.Name  =  "Latin" OR T1.Name  =  "Pop"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 average millisecond length of Latin and Pop tracks.
SQL: SELECT AVG(Milliseconds) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId  =  T2.GenreId WHERE T1.Name  =  "Latin" OR T1.Name  =  "Pop"
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 employee first names and ids of employees who serve at least 10 customers.
SQL: SELECT T1.FirstName ,  T1.SupportRepId FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId GROUP BY T1.SupportRepId HAVING COUNT(*)  >=  10
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 first names and support rep ids for employees serving 10 or more customers?
SQL: SELECT T1.FirstName ,  T1.SupportRepId FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId GROUP BY T1.SupportRepId HAVING COUNT(*)  >=  10
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 employee last names that serves no more than 20 customers.
SQL: SELECT T1.LastName FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId GROUP BY T1.SupportRepId HAVING COUNT(*)  <=  20
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 last names of employees who serve at most 20 customers?
SQL: SELECT T1.LastName FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId GROUP BY T1.SupportRepId HAVING COUNT(*)  <=  20
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 list all album titles in alphabetical order.
SQL: SELECT Title FROM ALBUM ORDER BY Title
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 all the album titles, in alphabetical order?
SQL: SELECT Title FROM ALBUM ORDER BY Title
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 list the name and id of all artists that have at least 3 albums in alphabetical order.
SQL: SELECT T2.Name ,  T1.ArtistId FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistID GROUP BY T1.ArtistId HAVING COUNT(*)  >=  3 ORDER BY T2.Name
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 and ids of artists with 3 or more albums, listed in alphabetical order?
SQL: SELECT T2.Name ,  T1.ArtistId FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistID GROUP BY T1.ArtistId HAVING COUNT(*)  >=  3 ORDER BY T2.Name
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 names of artists that do not have any albums.
SQL: SELECT Name FROM ARTIST EXCEPT SELECT T2.Name FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistId
-- Language PostgreSQL
        -- Tables: 
             -- Table: album 
columns : [['album id', 'number'], ['title', 'text'], ['artist id', 'number']]

 -- Table: artist 
columns : [['artist id', 'number'], ['name', 'text']]

 -- Table: customer 
columns : [['customer id', 'number'], ['first name', 'text'], ['last name', 'text'], ['company', 'text'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text'], ['support representative id', 'number']]

 -- Table: employee 
columns : [['employee id', 'number'], ['last name', 'text'], ['first name', 'text'], ['title', 'text'], ['reports to', 'number'], ['birth date', 'time'], ['hire date', 'time'], ['address', 'text'], ['city', 'text'], ['state', 'text'], ['country', 'text'], ['postal code', 'text'], ['phone', 'text'], ['fax', 'text'], ['email', 'text']]

 -- Table: genre 
columns : [['genre id', 'number'], ['name', 'text']]

 -- Table: invoice 
columns : [['invoice id', 'number'], ['customer id', 'number'], ['invoice date', 'time'], ['billing address', 'text'], ['billing city', 'text'], ['billing state', 'text'], ['billing country', 'text'], ['billing postal code', 'text'], ['total', 'number']]

 -- Table: invoice line 
columns : [['invoice line id', 'number'], ['invoice id', 'number'], ['track id', 'number'], ['unit price', 'number'], ['quantity', 'number']]

 -- Table: media type 
columns : [['media type id', 'number'], ['name', 'text']]

 -- Table: playlist 
columns : [['play list id', 'number'], ['name', 'text']]

 -- Table: playlist track 
columns : [['play list id', 'number'], ['track id', 'number']]

 -- Table: track 
columns : [['track id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', '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 artists who have not released any albums?
SQL: SELECT Name FROM ARTIST EXCEPT SELECT T2.Name FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId  =  T2.ArtistId