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: Find the production code and channel of the most recently aired cartoon .
SQL: select production_code ,  channel from cartoon order by original_air_date desc limit 1

Question: What is the produdction code and channel of the most recent cartoon ?
SQL: select production_code ,  channel from cartoon order by original_air_date desc limit 1

Question: Find the package choice and series name of the TV channel that has high definition TV.
SQL: SELECT package_option ,  series_name FROM TV_Channel WHERE hight_definition_TV  =  "yes"

Question: What are the package options and the name of the series for the TV Channel that supports high definition TV?
SQL: SELECT package_option ,  series_name FROM TV_Channel WHERE hight_definition_TV  =  "yes"

Question: which countries' tv channels are playing some cartoon written by Todd Casey?
SQL: SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'

Question: What are the countries that have cartoons on TV that were written by Todd Casey?
SQL: SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'

Question: which countries' tv channels are not playing any cartoon written by Todd Casey?
SQL: SELECT country FROM TV_Channel EXCEPT SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'

Question: What are the countries that are not playing cartoons written by Todd Casey?
SQL: SELECT country FROM TV_Channel EXCEPT SELECT T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.written_by  =  'Todd Casey'

Question: Find the series name and country of the tv channel that is playing some cartoons directed by Ben Jones and Michael Chang?
SQL: SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Michael Chang' INTERSECT SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Ben Jones'

Question: What is the series name and country of all TV channels that are playing cartoons directed by Ben Jones and cartoons directed by Michael Chang?
SQL: SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Michael Chang' INTERSECT SELECT T1.series_name ,  T1.country FROM TV_Channel AS T1 JOIN cartoon AS T2 ON T1.id = T2.Channel WHERE T2.directed_by  =  'Ben Jones'

Question: find the pixel aspect ratio and nation of the tv channels that do not use English.
SQL: SELECT Pixel_aspect_ratio_PAR ,  country FROM tv_channel WHERE LANGUAGE != 'English'

Question: What is the pixel aspect ratio and country of origin for all TV channels that do not use English?
SQL: SELECT Pixel_aspect_ratio_PAR ,  country FROM tv_channel WHERE LANGUAGE != 'English'

Question: find id of the tv channels that from the countries where have more than two tv channels.
SQL: SELECT id FROM tv_channel GROUP BY country HAVING count(*)  >  2

Question: What are the ids of all tv channels that have more than 2 TV channels?
SQL: SELECT id FROM tv_channel GROUP BY country HAVING count(*)  >  2

Question: find the id of tv channels that do not play any cartoon directed by Ben Jones.
SQL: SELECT id FROM TV_Channel EXCEPT SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones'

Question: What are the ids of the TV channels that do not have any cartoons directed by Ben Jones?
SQL: SELECT id FROM TV_Channel EXCEPT SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones'

Question: find the package option of the tv channel that do not have any cartoon directed by Ben Jones.
SQL: SELECT package_option FROM TV_Channel WHERE id NOT IN (SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones')

Question: What are the package options of all tv channels that are not playing any cartoons directed by Ben Jones?
SQL: SELECT package_option FROM TV_Channel WHERE id NOT IN (SELECT channel FROM cartoon WHERE directed_by  =  'Ben Jones')