For each payment method, return how many customers use it.
CREATE TABLE customers (payment_method_code VARCHAR)
SELECT payment_method_code, COUNT(*) FROM customers GROUP BY payment_method_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE customers (payment_method_code VARCHAR) Question: For each payment method, return how many customers use it. [/INST] SELECT payment_method_code, COUNT(*) FROM customers GROUP BY payment_method_code </s>