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_54 (competition VARCHAR, main_article VARCHAR, captain VARCHAR, lost VARCHAR)
system
What Competition in Main Article of Bradford Bulls 1997 have Robbie Paul as Captain with less than 5 Lost?
user
SELECT competition FROM table_name_54 WHERE captain = "robbie paul" AND lost < 5 AND main_article = "bradford bulls 1997"
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_54 (competition VARCHAR, main_article VARCHAR, captain VARCHAR, lost VARCHAR)<|im_end|>
<|im_start|>user
What Competition in Main Article of Bradford Bulls 1997 have Robbie Paul as Captain with less than 5 Lost?<|im_end|>
