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_49 (description VARCHAR, livery VARCHAR, date VARCHAR, number_ VARCHAR, _name VARCHAR)
system
What's the Description for Scottish Tar Distillers No. 78, that's Livery is black, and a date prior to 1897?
user
SELECT description FROM table_name_49 WHERE livery = "black" AND date < 1897 AND number_ & _name = "scottish tar distillers no. 78"
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_49 (description VARCHAR, livery VARCHAR, date VARCHAR, number_ VARCHAR, _name VARCHAR)<|im_end|>
<|im_start|>user
What's the Description for Scottish Tar Distillers No. 78, that's Livery is black, and a date prior to 1897?<|im_end|>
