Database: tv_shows
Question: Show the different affiliations of city channels and the number of city channels with each affiliation.
SQL:
SELECT Affiliation ,  COUNT(*) FROM city_channel GROUP BY Affiliation