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_77 (location VARCHAR, distance__km_ VARCHAR, rapid VARCHAR)
system
What location is less than 7.1 km away, and has a Rapid of ●?
user
SELECT location FROM table_name_77 WHERE distance__km_ < 7.1 AND rapid = "●"
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_77 (location VARCHAR, distance__km_ VARCHAR, rapid VARCHAR)<|im_end|>
<|im_start|>user
What location is less than 7.1 km away, and has a Rapid of ●?<|im_end|>
