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_56 (tier INTEGER, postseason VARCHAR, season VARCHAR)
system
What is the average Tier when the postseason shows -, and the season is 2012–13?
user
SELECT AVG(tier) FROM table_name_56 WHERE postseason = "–" AND season = "2012–13"
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_56 (tier INTEGER, postseason VARCHAR, season VARCHAR)<|im_end|>
<|im_start|>user
What is the average Tier when the postseason shows -, and the season is 2012–13?<|im_end|>
