Find the number of concerts happened in the stadium with the highest capacity .
CREATE TABLE concert (stadium_id VARCHAR, capacity VARCHAR); CREATE TABLE stadium (stadium_id VARCHAR, capacity VARCHAR)
SELECT COUNT(*) FROM concert WHERE stadium_id = (SELECT TOP 1 stadium_id FROM stadium ORDER BY capacity DESC)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE concert (stadium_id VARCHAR, capacity VARCHAR); CREATE TABLE stadium (stadium_id VARCHAR, capacity VARCHAR) Question: Find the number of concerts happened in the stadium with the highest capacity . [/INST] SELECT COUNT(*) FROM concert WHERE stadium_id = (SELECT TOP 1 stadium_id FROM stadium ORDER BY capacity DESC) </s>