CREATE TABLE TV_Channel (
    id TEXT PRIMARY KEY,
    series_name TEXT,
    Country TEXT,
    Language TEXT,
    Content TEXT,
    Pixel_aspect_ratio_PAR TEXT,
    Hight_definition_TV TEXT,
    Pay_per_view_PPV TEXT,
    Package_Option TEXT
);
CREATE TABLE TV_series (
    id NUMBER PRIMARY KEY,
    Episode TEXT,
    Air_Date TEXT,
    Rating TEXT,
    Share NUMBER,
    18_49_Rating_Share TEXT,
    Viewers_m TEXT,
    Weekly_Rank NUMBER,
    Channel TEXT,
    FOREIGN KEY ("Channel") REFERENCES TV_Channel("id")
);
CREATE TABLE Cartoon (
    id NUMBER PRIMARY KEY,
    Title TEXT,
    Directed_by TEXT,
    Written_by TEXT,
    Original_air_date TEXT,
    Production_code NUMBER,
    Channel TEXT,
    FOREIGN KEY ("Channel") REFERENCES TV_Channel("id")
);

Question: List the title of all cartoons in alphabetical order.
SQL: SELECT Title FROM Cartoon ORDER BY title

Question: What are the titles of the cartoons sorted alphabetically?
SQL: SELECT Title FROM Cartoon ORDER BY title

Question: List all cartoon directed by "Ben Jones".
SQL: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones";

Question: What are the names of all cartoons directed by Ben Jones?
SQL: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones";

Question: How many cartoons were written by "Joseph Kuhr"?
SQL: SELECT count(*) FROM Cartoon WHERE Written_by = "Joseph Kuhr";

Question: What is the number of cartoones written by Joseph Kuhr?
SQL: SELECT count(*) FROM Cartoon WHERE Written_by = "Joseph Kuhr";

Question: list all cartoon titles and their directors ordered by their air date
SQL: SELECT title ,  Directed_by FROM Cartoon ORDER BY Original_air_date

Question: What is the name and directors of all the cartoons that are ordered by air date?
SQL: SELECT title ,  Directed_by FROM Cartoon ORDER BY Original_air_date

Question: List the title of all cartoon directed by "Ben Jones" or "Brandon Vietti".
SQL: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones" OR Directed_by = "Brandon Vietti";

Question: What are the titles of all cartoons directed by Ben Jones or Brandon Vietti?
SQL: SELECT Title FROM Cartoon WHERE Directed_by = "Ben Jones" OR Directed_by = "Brandon Vietti";

Question: Which country has the most of TV Channels? List the country and number of TV Channels it has.
SQL: SELECT Country ,  count(*) FROM TV_Channel GROUP BY Country ORDER BY count(*) DESC LIMIT 1;

Question: What is the country with the most number of TV Channels and how many does it have?
SQL: SELECT Country ,  count(*) FROM TV_Channel GROUP BY Country ORDER BY count(*) DESC LIMIT 1;

Question: List the number of different series names and contents in the TV Channel table.
SQL: SELECT count(DISTINCT series_name) ,  count(DISTINCT content) FROM TV_Channel;

Question: How many different series and contents are listed in the TV Channel table?
SQL: SELECT count(DISTINCT series_name) ,  count(DISTINCT content) FROM TV_Channel;

Question: What is the content of TV Channel with serial name "Sky Radio"?
SQL: SELECT Content FROM TV_Channel WHERE series_name = "Sky Radio";

Question: What is the content of the series Sky Radio?
SQL: SELECT Content FROM TV_Channel WHERE series_name = "Sky Radio";

Question: What is the Package Option of TV Channel with serial name "Sky Radio"?
SQL: SELECT Package_Option FROM TV_Channel WHERE series_name = "Sky Radio";

Question: What are the Package Options of the TV Channels whose series names are Sky Radio?
SQL: SELECT Package_Option FROM TV_Channel WHERE series_name = "Sky Radio";

Question: How many TV Channel using language English?
SQL: SELECT count(*) FROM TV_Channel WHERE LANGUAGE = "English";

Question: How many TV Channels use the English language?
SQL: SELECT count(*) FROM TV_Channel WHERE LANGUAGE = "English";

Question: List the language used least number of TV Channel. List language and number of TV Channel.
SQL: SELECT LANGUAGE ,  count(*) FROM TV_Channel GROUP BY LANGUAGE ORDER BY count(*) ASC LIMIT 1;

Question: What are the languages used by the least number of TV Channels and how many channels use it?
SQL: SELECT LANGUAGE ,  count(*) FROM TV_Channel GROUP BY LANGUAGE ORDER BY count(*) ASC LIMIT 1;

Question: List each language and the number of TV Channels using it.
SQL: SELECT LANGUAGE ,  count(*) FROM TV_Channel GROUP BY LANGUAGE

Question: For each language, list the number of TV Channels that use it.
SQL: SELECT LANGUAGE ,  count(*) FROM TV_Channel GROUP BY LANGUAGE

Question: What is the TV Channel that shows the cartoon "The Rise of the Blue Beetle!"? List the TV Channel's series name.
SQL: SELECT T1.series_name FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T2.Title = "The Rise of the Blue Beetle!";

Question: What is the series name of the TV Channel that shows the cartoon "The Rise of the Blue Beetle"?
SQL: SELECT T1.series_name FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T2.Title = "The Rise of the Blue Beetle!";

Question: List the title of all  Cartoons showed on TV Channel with series name "Sky Radio".
SQL: SELECT T2.Title FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";

Question: What is the title of all the cartools that are on the TV Channel with the series name "Sky Radio"?
SQL: SELECT T2.Title FROM TV_Channel AS T1 JOIN Cartoon AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";

Question: List the Episode of all TV series sorted by rating.
SQL: SELECT Episode FROM TV_series ORDER BY rating

Question: What are all of the episodes ordered by ratings?
SQL: SELECT Episode FROM TV_series ORDER BY rating

Question: List top 3 highest Rating  TV series. List the TV series's Episode and Rating.
SQL: SELECT Episode ,  Rating FROM TV_series ORDER BY Rating DESC LIMIT 3;

Question: What are 3 most highly rated episodes in the TV series table and what were those ratings?
SQL: SELECT Episode ,  Rating FROM TV_series ORDER BY Rating DESC LIMIT 3;

Question: What is minimum and maximum share of TV series?
SQL: SELECT max(SHARE) , min(SHARE) FROM TV_series;

Question: What is the maximum and minimum share for the TV series?
SQL: SELECT max(SHARE) , min(SHARE) FROM TV_series;

Question: What is the air date of TV series with Episode "A Love of a Lifetime"?
SQL: SELECT Air_Date FROM TV_series WHERE Episode = "A Love of a Lifetime";

Question: When did the episode "A Love of a Lifetime" air?
SQL: SELECT Air_Date FROM TV_series WHERE Episode = "A Love of a Lifetime";

Question: What is Weekly Rank of TV series with Episode "A Love of a Lifetime"?
SQL: SELECT Weekly_Rank FROM TV_series WHERE Episode = "A Love of a Lifetime";

Question: What is the weekly rank for the episode "A Love of a Lifetime"?
SQL: SELECT Weekly_Rank FROM TV_series WHERE Episode = "A Love of a Lifetime";

Question: What is the TV Channel of TV series with Episode "A Love of a Lifetime"? List the TV Channel's series name.
SQL: SELECT T1.series_name FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T2.Episode = "A Love of a Lifetime";

Question: What is the name of the series that has the episode "A Love of a Lifetime"?
SQL: SELECT T1.series_name FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T2.Episode = "A Love of a Lifetime";

Question: List the Episode of all  TV series showed on TV Channel with series name "Sky Radio".
SQL: SELECT T2.Episode FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";

Question: What is the episode for the TV series named "Sky Radio"?
SQL: SELECT T2.Episode FROM TV_Channel AS T1 JOIN TV_series AS T2 ON T1.id = T2.Channel WHERE T1.series_name = "Sky Radio";

Question: Find the number of cartoons directed by each of the listed directors.
SQL: SELECT count(*) ,  Directed_by FROM cartoon GROUP BY Directed_by

Question: How many cartoons did each director create?
SQL: SELECT count(*) ,  Directed_by FROM cartoon GROUP BY Directed_by