What are the names of customers using the most popular payment method?
CREATE TABLE customers (customer_name VARCHAR, payment_method VARCHAR)
SELECT customer_name FROM customers WHERE payment_method = (SELECT TOP 1 payment_method FROM customers GROUP BY payment_method ORDER BY COUNT(*) DESC)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE customers (customer_name VARCHAR, payment_method VARCHAR) Question: What are the names of customers using the most popular payment method? [/INST] SELECT customer_name FROM customers WHERE payment_method = (SELECT TOP 1 payment_method FROM customers GROUP BY payment_method ORDER BY COUNT(*) DESC) </s>