List all payment methods and number of payments using each payment methods.
CREATE TABLE Customer_Payments (payment_method_code VARCHAR)
SELECT payment_method_code, COUNT(*) FROM Customer_Payments GROUP BY payment_method_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Customer_Payments (payment_method_code VARCHAR) Question: List all payment methods and number of payments using each payment methods. [/INST] SELECT payment_method_code, COUNT(*) FROM Customer_Payments GROUP BY payment_method_code </s>