List countries that have more than one swimmer.
CREATE TABLE swimmer (nationality VARCHAR)
SELECT nationality, COUNT(*) FROM swimmer GROUP BY nationality HAVING COUNT(*) > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE swimmer (nationality VARCHAR) Question: List countries that have more than one swimmer. [/INST] SELECT nationality, COUNT(*) FROM swimmer GROUP BY nationality HAVING COUNT(*) > 1 </s>