human
Schema:
program (Program_ID, Name, Origin, Launch, Owner)
channel (Channel_ID, Name, Owner, Share_in_percent, Rating_in_percent)
broadcast (Channel_ID, Program_ID, Time_of_day)
broadcast_share (Channel_ID, Program_ID, Date, Share_in_percent)
Please answer with SQL.
assistant
Sure, I understand.
human
show me the programmes | Do you mean all the program ids? | yes
assistant
SELECT Program_id FROM program;
human
list the name of programme that broadcast frequently | Do you mean the name of the program that is broadcast most frequently? | yes
assistant
SELECT t1.name FROM program AS t1 JOIN broadcast AS t2 ON t1.program_id = t2.program_id GROUP BY t2.program_id ORDER BY COUNT( * ) DESC LIMIT 1 ;