What is the name and capacity for the stadium with highest average attendance?
CREATE TABLE stadium (name VARCHAR, capacity VARCHAR, average VARCHAR)
SELECT TOP 1 name, capacity FROM stadium ORDER BY average DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE stadium (name VARCHAR, capacity VARCHAR, average VARCHAR) Question: What is the name and capacity for the stadium with highest average attendance? [/INST] SELECT TOP 1 name, capacity FROM stadium ORDER BY average DESC </s>