sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses are located in Chico?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Chico"
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses opened in 1958.
SQL: SELECT campus FROM campuses WHERE YEAR  =  1958
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses that opened in 1958?
SQL: SELECT campus FROM campuses WHERE YEAR  =  1958
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 name of the campuses opened before 1800.
SQL: SELECT campus FROM campuses WHERE YEAR  <  1800
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses opened before 1800?
SQL: SELECT campus FROM campuses WHERE YEAR  <  1800
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus was opened between 1935 and 1939?
SQL: SELECT campus FROM campuses WHERE YEAR  >=  1935 AND YEAR  <=  1939
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses opened between 1935 and 1939?
SQL: SELECT campus FROM campuses WHERE YEAR  >=  1935 AND YEAR  <=  1939
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 name of the campuses that is in Northridge, Los Angeles or in San Francisco, San Francisco.
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Northridge" AND county  =  "Los Angeles" UNION SELECT campus FROM campuses WHERE LOCATION  =  "San Francisco" AND county  =  "San Francisco"
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses are located in Northridge, Los Angeles or in San Francisco, San Francisco?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Northridge" AND county  =  "Los Angeles" UNION SELECT campus FROM campuses WHERE LOCATION  =  "San Francisco" AND county  =  "San Francisco"
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus fee of "San Jose State University" in year 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Jose State University" AND T2.year  =  1996
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus fee for San Jose State University in 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Jose State University" AND T2.year  =  1996
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus fee of "San Francisco State University" in year 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Francisco State University" AND T2.year  =  1996
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus fee for San Francisco State University in 1996?
SQL: SELECT campusfee FROM campuses AS T1 JOIN csu_fees AS T2 ON T1.id  =  t2.campus WHERE t1.campus  =  "San Francisco State University" AND T2.year  =  1996
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 count of universities whose campus fee is greater than the average campus fee.
SQL: SELECT count(*) FROM csu_fees WHERE campusfee  >  (SELECT avg(campusfee) FROM csu_fees)
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 universities have a campus fee higher than average?
SQL: SELECT count(*) FROM csu_fees WHERE campusfee  >  (SELECT avg(campusfee) FROM csu_fees)
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 universities have a campus fee greater than the average?
SQL: SELECT count(*) FROM csu_fees WHERE campusfee  >  (SELECT avg(campusfee) FROM csu_fees)
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 university is in Los Angeles county and opened after 1950?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles" AND YEAR  >  1950
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses are located in Los Angeles county and opened after 1950?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles" AND YEAR  >  1950
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 year has the most degrees conferred?
SQL: SELECT YEAR FROM degrees GROUP BY YEAR ORDER BY sum(degrees) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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: In what year was the most degrees conferred?
SQL: SELECT YEAR FROM degrees GROUP BY YEAR ORDER BY sum(degrees) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus has the most degrees conferred in all times?
SQL: SELECT campus FROM degrees GROUP BY campus ORDER BY sum(degrees) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus has the most degrees  conferrred over its entire existence?
SQL: SELECT campus FROM degrees GROUP BY campus ORDER BY sum(degrees) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus has the most faculties in year 2003?
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2003 ORDER BY T2.faculty DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus has the most faculties in 2003?
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2003 ORDER BY T2.faculty DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 fee on a CSU campus in 1996
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  1996
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 fee for a CSU campus in the year of 1996?
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  1996
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 fee on a CSU campus in 2005?
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  2005
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 fee for a CSU campus in the year of 2005?
SQL: SELECT avg(campusfee) FROM csu_fees WHERE YEAR  =  2005
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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: report the total number of degrees granted between 1998 and 2002.
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T2.year  >=  1998 AND T2.year  <=  2002 GROUP BY T1.campus
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 degrees were conferred between 1998 and 2002?
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T2.year  >=  1998 AND T2.year  <=  2002 GROUP BY T1.campus
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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: For each Orange county campus, report the number of degrees granted after 2000.
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T1.county  =  "Orange" AND T2.year  >=  2000 GROUP BY T1.campus
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 number of degrees granted after 2000 for each Orange county campus?
SQL: SELECT T1.campus ,  sum(T2.degrees) FROM campuses AS T1 JOIN degrees AS T2 ON T1.id  =  T2.campus WHERE T1.county  =  "Orange" AND T2.year  >=  2000 GROUP BY T1.campus
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', 'number']]

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



Question: Find the names of the campus which has more faculties in 2002 than every campus in Orange county.
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND faculty  >  (SELECT max(faculty) FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND T1.county  =  "Orange")
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 the campus that have more faculties in 2002 than the maximum number in Orange county?
SQL: SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND faculty  >  (SELECT max(faculty) FROM campuses AS T1 JOIN faculty AS T2 ON T1.id  =  T2.campus WHERE T2.year  =  2002 AND T1.county  =  "Orange")
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus had more than 400 total enrollment but more than 200 full time enrollment in year 1956?
SQL: SELECT T1.campus FROM campuses AS t1 JOIN enrollments AS t2 ON t1.id  =  t2.campus WHERE t2.year  =  1956 AND totalenrollment_ay  >  400 AND FTE_AY  >  200
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campus started in year 1956, has more than 200 full time students, and more than 400 students enrolled?
SQL: SELECT T1.campus FROM campuses AS t1 JOIN enrollments AS t2 ON t1.id  =  t2.campus WHERE t2.year  =  1956 AND totalenrollment_ay  >  400 AND FTE_AY  >  200
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses are there in Los Angeles county?
SQL: SELECT count(*) FROM campuses WHERE county  =  "Los Angeles"
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses exist are in the county of LA?
SQL: SELECT count(*) FROM campuses WHERE county  =  "Los Angeles"