sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 detail of the location UK Gallery?
SQL: SELECT Other_Details FROM LOCATIONS WHERE Location_Name  =  "UK Gallery"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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: Return the detail of the location named "UK Gallery".
SQL: SELECT Other_Details FROM LOCATIONS WHERE Location_Name  =  "UK Gallery"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 location names contain the word "film"?
SQL: SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE "%film%"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 all the locations whose names contain the word "film".
SQL: SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE "%film%"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 distinct names are associated with all the photos?
SQL: SELECT count(DISTINCT Name) FROM PHOTOS
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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: Count the number of distinct names associated with the photos.
SQL: SELECT count(DISTINCT Name) FROM PHOTOS
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 distinct visit dates?
SQL: SELECT DISTINCT Visit_Date FROM VISITS
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 all the distinct visit dates.
SQL: SELECT DISTINCT Visit_Date FROM VISITS
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 the tourist attractions that can be accessed by bus?
SQL: SELECT Name FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 tourist attractions can we get to by bus? Tell me the names of the attractions.
SQL: SELECT Name FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 and opening hours of the tourist attractions that can be accessed by bus or walk?
SQL: SELECT Name ,  Opening_Hours FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus" OR How_to_Get_There  =  "walk"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 names and opening hours of the tourist attractions that we get to by bus or walk.
SQL: SELECT Name ,  Opening_Hours FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus" OR How_to_Get_There  =  "walk"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 star rating descriptions of the hotels with price above 10000?
SQL: SELECT T2.star_rating_description FROM HOTELS AS T1 JOIN Ref_Hotel_Star_Ratings AS T2 ON T1.star_rating_code  =  T2.star_rating_code WHERE T1.price_range  >  10000
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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: Give me the star rating descriptions of the hotels that cost more than 10000.
SQL: SELECT T2.star_rating_description FROM HOTELS AS T1 JOIN Ref_Hotel_Star_Ratings AS T2 ON T1.star_rating_code  =  T2.star_rating_code WHERE T1.price_range  >  10000
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 details and opening hours of the museums?
SQL: SELECT T1.Museum_Details ,  T2.Opening_Hours FROM MUSEUMS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Museum_ID  =  T2.Tourist_Attraction_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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: Give me the detail and opening hour for each museum.
SQL: SELECT T1.Museum_Details ,  T2.Opening_Hours FROM MUSEUMS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Museum_ID  =  T2.Tourist_Attraction_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 name of the tourist attraction that is associated with the photo "game1"?
SQL: SELECT T2.Name FROM PHOTOS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T1.Name  =  "game1"
-- Language PostgreSQL
        -- Tables: 
             -- Table: ref hotel star ratings 
columns : [['star rating code', 'text'], ['star rating description', 'text']]

 -- Table: locations 
columns : [['location id', 'number'], ['location name', 'text'], ['address', 'text'], ['other details', 'text']]

 -- Table: ref attraction types 
columns : [['attraction type code', 'text'], ['attraction type description', 'text']]

 -- Table: visitors 
columns : [['tourist id', 'number'], ['tourist details', 'text']]

 -- Table: features 
columns : [['feature id', 'number'], ['feature details', 'text']]

 -- Table: hotels 
columns : [['hotel id', 'number'], ['star rating code', 'text'], ['pets allowed yn', 'text'], ['price range', 'number'], ['other hotel details', 'text']]

 -- Table: tourist attractions 
columns : [['tourist attraction id', 'number'], ['attraction type code', 'text'], ['location id', 'number'], ['how to get there', 'text'], ['name', 'text'], ['description', 'text'], ['opening hours', 'text'], ['other details', 'text']]

 -- Table: street markets 
columns : [['market id', 'number'], ['market details', 'text']]

 -- Table: shops 
columns : [['shop id', 'number'], ['shop details', 'text']]

 -- Table: museums 
columns : [['museum id', 'number'], ['museum details', 'text']]

 -- Table: royal family 
columns : [['royal family id', 'number'], ['royal family details', 'text']]

 -- Table: theme parks 
columns : [['theme park id', 'number'], ['theme park details', 'text']]

 -- Table: visits 
columns : [['visit id', 'number'], ['tourist attraction id', 'number'], ['tourist id', 'number'], ['visit date', 'time'], ['visit details', 'text']]

 -- Table: photos 
columns : [['photo id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['description', 'text'], ['filename', 'text'], ['other details', 'text']]

 -- Table: staff 
columns : [['staff id', 'number'], ['tourist attraction id', 'number'], ['name', 'text'], ['other details', 'text']]

 -- Table: tourist attraction features 
columns : [['tourist attraction id', 'number'], ['feature 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 tourist attraction is associated with the photo "game1"? Return its name.
SQL: SELECT T2.Name FROM PHOTOS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Tourist_Attraction_ID  =  T2.Tourist_Attraction_ID WHERE T1.Name  =  "game1"