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
how many broadcast are presented on the table
assistant
SELECT COUNT( * ) FROM broadcast;
human
what are all the channel are presented on the table
assistant
SELECT * FROM channel;
human
what is the owner name of CCTV-1
assistant
SELECT owner FROM channel WHERE name = "CCTV-1" ;