What is the greatest B score when the A score was less than 6.5?
CREATE TABLE table_name_4 (b_score INTEGER, a_score INTEGER)
SELECT MAX(b_score) FROM table_name_4 WHERE a_score < 6.5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_4 (b_score INTEGER, a_score INTEGER) Question: What is the greatest B score when the A score was less than 6.5? [/INST] SELECT MAX(b_score) FROM table_name_4 WHERE a_score < 6.5 </s>