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: Show the album names and ids for albums that contain tracks with unit price bigger than 1.
SQL: SELECT T1.Title ,  T2.AlbumID FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId  =  T2.AlbumId WHERE T2.UnitPrice  >  1 GROUP BY T2.AlbumID
-- 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 titles and ids for albums containing tracks with unit price greater than 1?
SQL: SELECT T1.Title ,  T2.AlbumID FROM ALBUM AS T1 JOIN TRACK AS T2 ON T1.AlbumId  =  T2.AlbumId WHERE T2.UnitPrice  >  1 GROUP BY T2.AlbumID
-- 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 belong to rock genre?
SQL: SELECT COUNT(*) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId  =  T2.GenreId WHERE T1.Name  =  "Rock"
-- 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 part of the rock genre.
SQL: SELECT COUNT(*) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId  =  T2.GenreId WHERE T1.Name  =  "Rock"
-- 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 unit price of tracks that belong to Jazz genre?
SQL: SELECT AVG(UnitPrice) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId  =  T2.GenreId WHERE T1.Name  =  "Jazz"
-- 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 unit price of jazz tracks.
SQL: SELECT AVG(UnitPrice) FROM GENRE AS T1 JOIN TRACK AS T2 ON T1.GenreId  =  T2.GenreId WHERE T1.Name  =  "Jazz"
-- 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 first name and last name of the customer that has email "luisg@embraer.com.br"?
SQL: SELECT FirstName ,  LastName FROM CUSTOMER WHERE Email  =  "luisg@embraer.com.br"
-- 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 full name of the customer with the email "luisg@embraer.com.br".
SQL: SELECT FirstName ,  LastName FROM CUSTOMER WHERE Email  =  "luisg@embraer.com.br"
-- 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 customers have email that contains "gmail.com"?
SQL: SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"
-- 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 customers that have an email containing "gmail.com".
SQL: SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%"
-- 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 first name and last name employee helps the customer with first name Leonie?
SQL: SELECT T2.FirstName ,  T2.LastName FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId WHERE T1.FirstName  =  "Leonie"
-- 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 full names of employees who help customers with the first name Leonie.
SQL: SELECT T2.FirstName ,  T2.LastName FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId WHERE T1.FirstName  =  "Leonie"
-- 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 city does the employee who helps the customer with postal code 70174 live in?
SQL: SELECT T2.City FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId WHERE T1.PostalCode  =  "70174"
-- 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 cities corresponding to employees who help customers with the postal code 70174.
SQL: SELECT T2.City FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId  =  T2.EmployeeId WHERE T1.PostalCode  =  "70174"
-- 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 distinct cities does the employees live in?
SQL: SELECT COUNT(DISTINCT city) 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: Find the number of different cities that employees live in.
SQL: SELECT COUNT(DISTINCT city) 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: Find all invoice dates corresponding to customers with first name Astrid and last name Gruber.
SQL: SELECT T2.InvoiceDate FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T1.FirstName  =  "Astrid" AND LastName  =  "Gruber"
-- 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 invoice dates for customers with the first name Astrid and the last name Gruber?
SQL: SELECT T2.InvoiceDate FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T1.FirstName  =  "Astrid" AND LastName  =  "Gruber"
-- 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 all the customer last names that do not have invoice totals larger than 20.
SQL: SELECT LastName FROM CUSTOMER EXCEPT SELECT T1.LastName FROM CUSTOMER AS T1 JOIN Invoice AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T2.total  >  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 customers without invoice totals exceeding 20?
SQL: SELECT LastName FROM CUSTOMER EXCEPT SELECT T1.LastName FROM CUSTOMER AS T1 JOIN Invoice AS T2 ON T1.CustomerId  =  T2.CustomerId WHERE T2.total  >  20