Database schema:
CREATE TABLE city_channel (
  ID NUMBER PRIMARY KEY,
  City TEXT,
  Station_name TEXT,
  Owned_Since NUMBER,
  Affiliation TEXT
);
CREATE TABLE radio (
  Radio_ID NUMBER PRIMARY KEY,
  Transmitter TEXT,
  Radio_MHz TEXT,
  2FM_MHz TEXT,
  RnaG_MHz TEXT,
  Lyric_FM_MHz TEXT,
  ERP_kW TEXT
);
CREATE TABLE tv_show (
  tv_show_ID NUMBER PRIMARY KEY,
  tv_show_name TEXT,
  Sub_tittle TEXT,
  Next_show_name TEXT,
  Original_Airdate TEXT
);
CREATE TABLE city_channel_radio (
  City_channel_ID NUMBER PRIMARY KEY,
  Radio_ID NUMBER,
  Is_online OTHERS,
  FOREIGN KEY (Radio_ID) REFERENCES radio(Radio_ID),
  FOREIGN KEY (City_channel_ID) REFERENCES city_channel(ID)
);
CREATE TABLE city_channel_tv_show (
  City_channel_ID NUMBER PRIMARY KEY,
  tv_show_ID NUMBER,
  Is_online OTHERS,
  Is_free OTHERS,
  FOREIGN KEY (tv_show_ID) REFERENCES tv_show(tv_show_ID),
  FOREIGN KEY (City_channel_ID) REFERENCES city_channel(ID)
);

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

Question: Show the transmitters of radios whose ERP is bigger than 150 or smaller than 30.
SQL: SELECT Transmitter FROM radio WHERE ERP_kW  >  150 OR ERP_kW  <  30

Question: Show the distinct transmitters of radios that are not associated with any city channel.
SQL: SELECT Transmitter FROM radio WHERE Radio_ID NOT IN (SELECT Radio_ID FROM city_channel_radio)

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

Question: What is the transmitter of the radio with the largest ERP_kW?
SQL: SELECT Transmitter FROM radio ORDER BY ERP_kW DESC LIMIT 1

Question: What is the average ERP across all radios?
SQL: SELECT avg(ERP_kW) FROM radio

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

Question: How many radios are there?
SQL: SELECT count(*) FROM radio

Question: Show the transmitters of radios and the cities of the channels they are associated with.
SQL: SELECT T3.Transmitter ,  T2.City 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

Question: List the affiliations shared by more than three city channels.
SQL: SELECT Affiliation FROM city_channel GROUP BY Affiliation HAVING COUNT(*)  >  3

Question: List the station names of city channels whose affiliation is not "ABC".
SQL: SELECT Station_name FROM city_channel WHERE Affiliation != "ABC"

Question: Show the cities and station names of city channels in ascending alphabetical order of station name.
SQL: SELECT City ,  Station_name FROM city_channel ORDER BY Station_name ASC

Question: Please show the most common affiliation for city channels.
SQL: SELECT Affiliation FROM city_channel GROUP BY Affiliation ORDER BY COUNT(*) DESC LIMIT 1