Task: Text to Code
Input (English): Step 1: For each row in channel table, find the corresponding rows in broadcast table.
Step 2: find channel's Owner of the results of step 1 whose Time_of_day equals Morning.
Step 3: For each row in program table, find the corresponding rows in broadcast table.
Step 4: find program's Owner of the results of step 3 whose Time_of_day equals Night.
Step 5: show the rows that are in both the results of step 2 and the results of step 4
Output (English): SELECT T1.Owner FROM channel AS T1 JOIN broadcast AS T2 ON T1.Channel_ID = T2.Channel_ID WHERE T2.Time_of_day = "Morning" INTERSECT SELECT T3.Owner FROM program AS T3 JOIN broadcast AS T2 ON T3.Program_ID = T2.Program_ID WHERE T2.Time_of_day = "Night"