You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_56 (vessel_name VARCHAR, built VARCHAR, class VARCHAR, flag VARCHAR, type VARCHAR)
system
What is the name of the Malta vessel built after 2010 that is a GL class Panamax vessel?
user
SELECT vessel_name FROM table_name_56 WHERE flag = "malta" AND type = "panamax" AND class = "gl" AND built > 2010
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_56 (vessel_name VARCHAR, built VARCHAR, class VARCHAR, flag VARCHAR, type VARCHAR)<|im_end|>
<|im_start|>user
What is the name of the Malta vessel built after 2010 that is a GL class Panamax vessel?<|im_end|>
