Can you tell me the average B Score that has the Position of 2nd, and the Total smaller than 15.525?
CREATE TABLE table_name_47 (b_score INTEGER, position VARCHAR, total VARCHAR)
SELECT AVG(b_score) FROM table_name_47 WHERE position = "2nd" AND total < 15.525
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (b_score INTEGER, position VARCHAR, total VARCHAR) Question: Can you tell me the average B Score that has the Position of 2nd, and the Total smaller than 15.525? [/INST] SELECT AVG(b_score) FROM table_name_47 WHERE position = "2nd" AND total < 15.525 </s>