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_80 (first_elected VARCHAR, committee VARCHAR, counties_represented VARCHAR, district VARCHAR)
system
What is the total number of First elected that has a country represented in Baltimore county, a district of 06.0 6, and a committee of economic matters?
user
SELECT COUNT(first_elected) FROM table_name_80 WHERE counties_represented = "baltimore county" AND district = "06.0 6" AND committee = "economic matters"
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_80 (first_elected VARCHAR, committee VARCHAR, counties_represented VARCHAR, district VARCHAR)<|im_end|>
<|im_start|>user
What is the total number of First elected that has a country represented in Baltimore county, a district of 06.0 6, and a committee of economic matters?<|im_end|>
