A list of the top 10 countries by average invoice size. List country name and average invoice size.
CREATE TABLE invoices (billing_country VARCHAR, total INTEGER)
SELECT TOP 10 billing_country, AVG(total) FROM invoices GROUP BY billing_country ORDER BY AVG(total) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE invoices (billing_country VARCHAR, total INTEGER) Question: A list of the top 10 countries by average invoice size. List country name and average invoice size. [/INST] SELECT TOP 10 billing_country, AVG(total) FROM invoices GROUP BY billing_country ORDER BY AVG(total) DESC </s>