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_76 (chimoré_municipality INTEGER, pojo_municipality VARCHAR, totora_municipality VARCHAR)
system
What is the highest chimore municipalities with 9 pojo municipalities and less than 7 totora municipalities?
user
SELECT MAX(chimoré_municipality) FROM table_name_76 WHERE pojo_municipality = 9 AND totora_municipality < 7
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_76 (chimoré_municipality INTEGER, pojo_municipality VARCHAR, totora_municipality VARCHAR)<|im_end|>
<|im_start|>user
What is the highest chimore municipalities with 9 pojo municipalities and less than 7 totora municipalities?<|im_end|>
