What is the lowest FA cup goals that have total goals less than 4, with Terry poole as the name?
CREATE TABLE table_name_6 (fa_cup_goals INTEGER, total_goals VARCHAR, name VARCHAR)
SELECT MIN(fa_cup_goals) FROM table_name_6 WHERE total_goals < 4 AND name = "terry poole"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (fa_cup_goals INTEGER, total_goals VARCHAR, name VARCHAR) Question: What is the lowest FA cup goals that have total goals less than 4, with Terry poole as the name? [/INST] SELECT MIN(fa_cup_goals) FROM table_name_6 WHERE total_goals < 4 AND name = "terry poole" </s>