SELECT id FROM tv_channel GROUP BY country HAVING count(*)  >  2
find id of the tv channels that from the countries where have more than two tv channels.
SELECT id FROM tv_channel GROUP BY country HAVING count ( * ) > 2
select id from tv_channel group by country having count ( * ) > value
find id of the tv channels that from the countries where have more than two tv channels .