sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 top 10 employee work longest in the company. List employee's first and last name.
SQL: SELECT first_name , last_name FROM employees ORDER BY hire_date ASC LIMIT 10;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 and last names of the top 10 longest-serving employees?
SQL: SELECT first_name , last_name FROM employees ORDER BY hire_date ASC LIMIT 10;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 employees whose title is IT Staff from each city?
SQL: SELECT count(*) ,  city FROM employees WHERE title  =  'IT Staff' GROUP BY city
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 employees who are IT staff are from each city?
SQL: SELECT count(*) ,  city FROM employees WHERE title  =  'IT Staff' GROUP BY city
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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: Which employee manage most number of peoples? List employee's first and last name, and number of people report to that employee.
SQL: SELECT T2.first_name , T2.last_name ,  count(T1.reports_to) FROM employees AS T1 JOIN employees AS T2 ON T1.reports_to = T2.id GROUP BY T1.reports_to ORDER BY count(T1.reports_to) DESC LIMIT 1;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 and last names of all the employees and how many people report to them?
SQL: SELECT T2.first_name , T2.last_name ,  count(T1.reports_to) FROM employees AS T1 JOIN employees AS T2 ON T1.reports_to = T2.id GROUP BY T1.reports_to ORDER BY count(T1.reports_to) DESC LIMIT 1;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 orders does Lucas Mancini has?
SQL: SELECT count(*) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 orders does Luca Mancini have in his invoices?
SQL: SELECT count(*) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 total amount of money spent by Lucas Mancini?
SQL: SELECT sum(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 much money did Lucas Mancini spend?
SQL: SELECT sum(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini";
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 all media types.
SQL: SELECT name FROM media_types;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 all the media types?
SQL: SELECT name FROM media_types;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 all different genre types.
SQL: SELECT DISTINCT name FROM genres;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 names of the genres?
SQL: SELECT DISTINCT name FROM genres;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

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

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



Question: List the name of all playlist.
SQL: SELECT name FROM playlists;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 all the playlists?
SQL: SELECT name FROM playlists;
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

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

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



Question: Who is the composer of track Fast As a Shark?
SQL: SELECT composer FROM tracks WHERE name = "Fast As a Shark";
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 composer who created the track "Fast As a Shark"?
SQL: SELECT composer FROM tracks WHERE name = "Fast As a Shark";
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 long does track Fast As a Shark has?
SQL: SELECT milliseconds FROM tracks WHERE name = "Fast As a Shark";
-- Language PostgreSQL
        -- Tables: 
             -- Table: sqlite sequence 
columns : [['name', 'number'], ['seq', 'text']]

 -- Table: artists 
columns : [['id', 'text'], ['name', 'text']]

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

 -- Table: employees 
columns : [['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: customers 
columns : [['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 rep id', 'number']]

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

 -- Table: invoices 
columns : [['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: media types 
columns : [['id', 'number'], ['name', 'text']]

 -- Table: tracks 
columns : [['id', 'number'], ['name', 'text'], ['album id', 'number'], ['media type id', 'number'], ['genre id', 'number'], ['composer', 'text'], ['milliseconds', 'number'], ['bytes', 'number'], ['unit price', 'number']]

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

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

 -- Table: playlist tracks 
columns : [['playlist id', 'number'], ['track id', '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 milliseconds long is Fast As a Shark?
SQL: SELECT milliseconds FROM tracks WHERE name = "Fast As a Shark";