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_19524523_1 (champ_car_world_series__2004_2007_ INTEGER, usac__1956_1995_ VARCHAR)
system
What is the most Champ Car wins for any driver with a USAC record of 2?
user
SELECT MAX(champ_car_world_series__2004_2007_) FROM table_19524523_1 WHERE usac__1956_1995_ = 2
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_19524523_1 (champ_car_world_series__2004_2007_ INTEGER, usac__1956_1995_ VARCHAR)<|im_end|>
<|im_start|>user
What is the most Champ Car wins for any driver with a USAC record of 2?<|im_end|>
