Discussion Board Assignment | Homework Help Websites
GO
Question 1
What is on TV?
—————
This is an exact repeat of Question 7 from Lab Week 2. However, instead of using the all_data
view, instead JOIN the CHANNEL, SHOW, and SCHEDULE tables together. Consult the ERD (if needed)
to determine which columns to match in the ON parts of the JOINs.
Show the first 100 TV shows that start on 9/10/2017 at 8:00PM (StartTime is 20:00:00).
Display results in order by ChannelNumber.
Show ONLY the DisplayName, ChannelNumber, StartTime, EndTime, and Title.
Use CONVERT to format the StartTime and EndTimehh:mi:ss without the day, month, or year.
Use CAST or CONVERT make DisplayName 10 characters wide, and Title 30 characters wide.
Make sure all columns have appropriate names (using AS where needed).
Hint: A DATETIME column can be matched against a string like 8/30/1962 13:00:00.
Hint 2: Correct results will have 100 rows, and look like this:
Channel Name Channel Number Start Time End Time Title
