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
Find the names of programs that are never broadcasted in the morning.
assistant
SELECT name FROM program EXCEPT SELECT t1.name FROM program AS t1 JOIN broadcast AS t2 ON t1.program_id = t2.program_id WHERE t2.Time_of_day = 'Morning'
human
List all program origins in the alphabetical order.
assistant
SELECT origin FROM program ORDER BY origin
human
Find the name of the program that is broadcast most frequently.
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
human
List the name, origin and owner of each program.
assistant
SELECT name , origin , OWNER FROM program
human
list all the names of programs, ordering by launch time.
assistant
SELECT name FROM program ORDER BY launch
human
find the name of the program that was launched most recently.
assistant
SELECT name FROM program ORDER BY launch DESC LIMIT 1 ;