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 Rooms (roomName VARCHAR, basePrice VARCHAR)
system
List the name of all rooms sorted by their prices.
user
SELECT roomName FROM Rooms ORDER BY basePrice
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 Rooms (roomName VARCHAR, basePrice VARCHAR)<|im_end|>
<|im_start|>user
List the name of all rooms sorted by their prices.<|im_end|>
