For each account type, find the average account balance of customers with credit score lower than 50.
CREATE TABLE customer (acc_type VARCHAR, acc_bal INTEGER, credit_score INTEGER)
SELECT AVG(acc_bal), acc_type FROM customer WHERE credit_score < 50 GROUP BY acc_type
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE customer (acc_type VARCHAR, acc_bal INTEGER, credit_score INTEGER) Question: For each account type, find the average account balance of customers with credit score lower than 50. [/INST] SELECT AVG(acc_bal), acc_type FROM customer WHERE credit_score < 50 GROUP BY acc_type </s>