What is the payment method code used by the most orders?
CREATE TABLE INVOICES (payment_method_code VARCHAR)
SELECT TOP 1 payment_method_code FROM INVOICES GROUP BY payment_method_code ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE INVOICES (payment_method_code VARCHAR) Question: What is the payment method code used by the most orders? [/INST] SELECT TOP 1 payment_method_code FROM INVOICES GROUP BY payment_method_code ORDER BY COUNT(*) DESC </s>