SELECT count(*) FROM radio
How many radios are there?
CREATE TABLE "city_channel" (
"ID" int,
"City" text,
"Station_name" text,
"Owned_Since" real,
"Affiliation" text,
PRIMARY KEY ("ID")
);
CREATE TABLE "radio" (
"Radio_ID" int,
"Transmitter" text,
"Radio_MHz" text,
"2FM_MHz" text,
"RnaG_MHz" text,
"Lyric_FM_MHz" text,
"ERP_kW" text,
PRIMARY KEY ("Radio_ID")
);
CREATE TABLE "tv_show" (
"tv_show_ID" int,
"tv_show_name" text,
"Sub_tittle" text,
"Next_show_name" text,
"Original_Airdate" text,
PRIMARY KEY ("tv_show_ID")
);
CREATE TABLE "city_channel_radio" (
"City_channel_ID" int,
"Radio_ID" int,
"Is_online" bool,
PRIMARY KEY ("City_channel_ID","Radio_ID"),
FOREIGN KEY (`City_channel_ID`) REFERENCES `city_channel`(`ID`),
FOREIGN KEY (`Radio_ID`) REFERENCES `radio`(`Radio_ID`)
);
CREATE TABLE "city_channel_tv_show" (
"City_channel_ID" int,
"tv_show_ID" int,
"Is_online" bool,
"Is_free" bool,
PRIMARY KEY ("City_channel_ID","tv_show_ID"),
FOREIGN KEY (`City_channel_ID`) REFERENCES `city_channel`(`ID`),
FOREIGN KEY (`tv_show_ID`) REFERENCES `tv_show`(`tv_show_ID`)
);
INSERT INTO  "city_channel" VALUES (1,"Phoenix","KNXV-TV","1985","ABC");
INSERT INTO  "radio" VALUES (1,"Cairn Hill","89.8","N/A","N/A","N/A","16");
INSERT INTO  "tv_show" VALUES (1,"Peace and Quiet","Wanted: Wade","Garfield Goes an Hawaii","September17,1988");
INSERT INTO  "city_channel_radio" VALUES (1,1,"T");
INSERT INTO  "city_channel_tv_show" VALUES (12,2,"T","F");