CREATE TABLE channel (Channel_ID NUMBER, Name CLOB, Owner CLOB, Share_in_percent FLOAT, Rating_in_percent FLOAT)
CREATE TABLE broadcast_share (Channel_ID NUMBER, Program_ID NUMBER, Date CLOB, Share_in_percent FLOAT)
CREATE TABLE program (Program_ID NUMBER, Name CLOB, Origin CLOB, Launch FLOAT, Owner CLOB)
CREATE TABLE broadcast (Channel_ID NUMBER, Program_ID NUMBER, Time_of_day CLOB)

Count the number of programs broadcast for each time section of a day. Visualize by pie chart.
SELECT Time_of_day, COUNT(*) FROM broadcast GROUP BY Time_of_day
SELECT "Time_of_day", COUNT(*) FROM "broadcast" GROUP BY "Time_of_day"