Database: tv_shows
Question: Show the transmitters of radios and the station names of the channels they are associated with in descending order of the ERP of the radios.
SQL:
SELECT T3.Transmitter ,  T2.Station_name FROM city_channel_radio AS T1 JOIN city_channel AS T2 ON T1.City_channel_ID  =  T2.ID JOIN radio AS T3 ON T1.Radio_ID  =  T3.Radio_ID ORDER BY T3.ERP_kW DESC