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_18077713_1 (revenue__us_$million_ VARCHAR, net_profit__us_$m_ VARCHAR)
system
How many dollars is the revenue when the net profit is 55.4 million dollars?
user
SELECT revenue__us_$million_ FROM table_18077713_1 WHERE net_profit__us_$m_ = "55.4"
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_18077713_1 (revenue__us_$million_ VARCHAR, net_profit__us_$m_ VARCHAR)<|im_end|>
<|im_start|>user
How many dollars is the revenue when the net profit is 55.4 million dollars?<|im_end|>
