find id of the tv channels that from the countries where have more than two tv channels.
CREATE TABLE tv_channel (id VARCHAR, country VARCHAR)
SELECT id FROM tv_channel GROUP BY country HAVING COUNT(*) > 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE tv_channel (id VARCHAR, country VARCHAR) Question: find id of the tv channels that from the countries where have more than two tv channels. [/INST] SELECT id FROM tv_channel GROUP BY country HAVING COUNT(*) > 2 </s>