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 programs are there?
assistant
SELECT count(*) FROM program
human
find the names of programs whose origin is not in Beijing.
assistant
SELECT name FROM program WHERE origin != 'Beijing'
human
find the name of the program that was launched most recently.
assistant
SELECT name FROM program ORDER BY launch 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
What is the list of program origins ordered alphabetically?
assistant
SELECT origin FROM program ORDER BY origin ;