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 INVOICES (Product_ID VARCHAR)
system
What is the product ID of the most frequently ordered item on invoices?
user
SELECT Product_ID FROM INVOICES GROUP BY Product_ID ORDER BY COUNT(*) DESC LIMIT 1
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 INVOICES (Product_ID VARCHAR)<|im_end|>
<|im_start|>user
What is the product ID of the most frequently ordered item on invoices?<|im_end|>
