Database: tv_shows
Question: Show the transmitters of the radios and the number of city channels they are associated with.
SQL:
SELECT T2.Transmitter ,  COUNT(*) FROM city_channel_radio AS T1 JOIN radio AS T2 ON T1.Radio_ID  =  T2.Radio_ID GROUP BY T2.Transmitter