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 country (Name VARCHAR, Continent VARCHAR, population INTEGER)
system
What are the African countries that have a  population less than any country in Asia?
user
SELECT Name FROM country WHERE Continent = "Africa" AND population < (SELECT MAX(population) FROM country WHERE Continent = "Asia")
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 country (Name VARCHAR, Continent VARCHAR, population INTEGER)<|im_end|>
<|im_start|>user
What are the African countries that have a  population less than any country in Asia?<|im_end|>
